02 FEB 2022
Aurora Training Advantage Expert

David H. Ringstrom, CPA - Accounting Advisors Inc.
Business Administration, Business Administration, Taxation and Accounting, Finance Facebook Twitter Linkedin David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).
My Articles
16 SEP 2021
Resolving Duplicate Values Within Excel Pivot Tables
When you transform a list of data into a meaningful report with a few mouse clicks in Excel, pivottables can feel like a blessing. On the other hand, when duplicate values appear in that pivottable, the feature may instead feel cursed. In t [...] 18 AUG 2021
Introduction to the New LET Function in Microsoft 365
Introduction to the New LET Function in Microsoft 365 The bane of many Excel users is having to repeat portions of a calculation two or more times within a single formula. Any sort of repetition in Excel formulas can be fraught with risk, a [...] 02 JUL 2021
Calculating Loan Payments in Microsoft Excel
Much of Excel’s power and utility arises from the ability to perform complex calculations by providing one or more inputs. One example is the PMT function in Microsoft Excel, which enables us to calculate a loan payment if we provide three [...] 18 MAY 2021
Filtering Tips and Tricks in Excel
Information overload is one of the perils of working with lists of data in Microsoft Excel. There’s only so much information that we can comfortably work with in any given moment, which makes filtering a great tool for fighting back. The nu [...] viewing 1 to 5 of 5
My Webinars
- 04182017-116Excel Agility: Six Summing Functions
On demand, previously recorded live webinar. Aired on April 18, 2017 - 05242018-398Exercising Spreadsheet Internal Controls
On demand, previously recorded live webinar. Aired on May 24, 2018 - 06052018-409Excel Agility: Budget Spreadsheets
On demand, previously recorded live webinar. Aired on June 5, 2018 - 09172018-459Excel Agility: Lookup Functions Part 1
On demand, previously recorded live webinar. Aired on September 17, 2018 - 10172018-479Excel Agility: Gaining Control of Large Spreadsheets
On demand, previously recorded live webinar. Aired on October 17, 2018 - 02122019-539Excel Agility: Speed Tips for QuickBooks/Excel Reports
On demand, previously recorded live webinar. Aired on February 12, 2019 - 03062019-553Excel: Preventing Errors in Your Spreadsheets
On demand, previously recorded live webinar. Aired on March 6, 2019 - 05012019-591Building Valuable and Dynamic Budget Spreadsheets in Excel
On demand, previously recorded live webinar. Aired on May 1, 2019 - 05212019-604Chart Speed Tips in Excel
On demand, previously recorded live webinar. Aired on May 21, 2019 - 07102019-634Excel Spreadsheet Fundamentals
On demand, previously recorded live webinar. Aired on July 10, 2019 - 08072019-666Interactive Spreadsheets in Excel
On demand, previously recorded live webinar. Aired on August 7, 2019 - 07262022-1880Excel for Mac
On demand, previously recorded live webinar. Aired on July 26, 2022 - 10112022-1926Excel for Administrative Assistants
On demand, previously recorded live webinar. Aired on October 11, 2022 - 11222022-1981Mastering Shortcuts in Excel
On demand, previously recorded live webinar. Aired on November 22, 2022 - 01012023-765Excel Agility: Breaking Down Formulas
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-694Excel Agility: Interactive Spreadsheets
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-693Excel Agility: Understanding Error Prompts
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-686Excel Agility: Workbook Links
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-685Excel Agility: Spreadsheet Basics Part 2
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-679Excel Agility: Spreadsheet Internal Control
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-678Excel Agility: Six Ways to Sum
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-671Excel Agility: Tips & Tricks Part 2
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-670Excel Agility: Tips & Tricks Part 1
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-731Excel Agility: SQL and Database Techniques
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-752Excel Agility - Office 365 Pros and Cons
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-1949Excel Agility: Pivot Tables - Beginners
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-2002Excel Agility: Pivot Tables - Advanced
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-1739Mastering Lookup Formulas and High Powered Alternative Techniques
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-2151Excel Agility - What-If Analysis
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-767Excel Agility: Financial Statement Automation Techniques
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-2195Excel Agility: Mastering Advanced Formulas
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-758Excel Agility - Printing and Page Layout
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-757Excel Agility - Payroll Analysis Techniques
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-878New XLOOKUP Function in Excel
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-665Excel Agility: QuickBooks/Excel Reporting Part 1
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-632Excel Agility: Pivot Table Mastery
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-626Excel Agility: Preventing Errors in Your Spreadsheets
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-625Excel Agility: Nuances and Quirks
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-624Excel Agility: Filtering and Formatting Data
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-622Excel Agility: Dealing with Duplicates
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-609Auditing Excel Spreadsheets
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-594Excel Agility: Macro Basics Part 4
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-593Excel Agility: Macro Basics Part 3
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-581Excel Agility: Spreadsheet Basics Part 1
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-108Excel Macro Basics Part 2
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-639Excel Agility: Pivot Tables Part 1
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-640Excel Agility: Pivot Tables Part 2
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-660Excel Agility: Logic Functions - IF, AND, OR, and Beyond
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-659Excel Agility: Building Valuable and Dynamic Budget Spreadsheets
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-658Excel Agility: Dashboards Part 1
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-657Excel Agility: Dashboards Part 2
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-656Excel Agility: Table Feature
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-654Excel Agility: Taming Large Spreadsheets
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-643Excel Agility: Chart Speed Tips
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-535Excel Macro Basics Part 1
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-649Excel Agility: Custom Views
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-650Excel Agility - VLOOKUP and Better Alternatives
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01012023-651Excel Agility: QuickBooks/Excel Reporting Part 2
On demand, previously recorded live webinar. Aired on January 1, 2023 - 01172023-2026Excel 101: Spreadsheet Basics
On demand, previously recorded live webinar. Aired on January 17, 2023 - 31
May
2023Live05312023-2145Mastering Lookup Formulas and High Powered Alternative Techniques
May 31, 2023 at 2:00pm - 3:40pm EST - 14
Jun
2023Live06142023-2162Preventing Errors in Your Spreadsheets
June 14, 2023 at 2:00pm - 3:40pm EST - 22
Jun
2023Live06222023-2147Excel for Administrative Assistants
June 22, 2023 at 2:00pm - 3:00pm EST