Available Topics

David H. Ringstrom, CPA, is currently a nationally recognized instructor. David has developed these training courses based on almost 30 years of consulting experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what many users don’t know but should know about Microsoft Excel.

David can present any of the following classes on-site or online. Choose from the sessions below or request training that’s tailored to your needs, including courses specific to Microsoft 365 or any version of Excel as far back as Excel 2007.

Click the Most Popular/NEW column below to see that topics that David has taught live the most times over the past 5 years as well as new topics that have been added in recent months.

PresentationLevelSubjectMost Popular/New
Power BI Dashboard BasicsBasicIntroductory CoursesNew for 2024
QuickBooks Online Analysis BasicsBasicIntroductory CoursesNew for 2024
Advanced QuickBooks Online AnalysisIntermediateData AnalysisNew for 2024
Keyboard ShortcutsBasicIntroductory CoursesNew for 2024
Dynamic Array-Based Financial StatementsIntermediateFinancial ReportingNew for 2024
Managing Budgets in QuickBooks OnlineBasicIntroductory CoursesNew for 2024
Spreadsheet AIIntermediateTips and TricksNew for 2024
Introduction to PythonAdvancedData AnalysisNew for 2024
Automating Financial Statements with Power BIIntermediateAutomationNew for 2024
Introduction to Power BIBasicIntroductory CoursesNew for 2024
Macros versus Power QueryIntermediateAutomationNew for 2024
Form ControlsIntermediateInteractive SpreadsheetsNew for 2024
Introduction to Python in ExcelAdvancedData AnalysisNew for 2024
AI and Microsoft ExcelIntermediateTips and TricksNew for 2024
Introduction to Power BIBasicIntroductory CoursesNew for 2024
Excel Macros versus Power QueryIntermediateAutomationNew for 2024
10 Productive Excel Features for Accountants (and 3 Timewasters)IntermediateTips and Tricks
Advanced Excel Skills for AccountantsIntermediateSpreadsheet Management
Analyzing Property Management ReportsIntermediateCommercial Real Estate
Auditing SpreadsheetsIntermediateData Analysis
Basic Excel Skills for AccountantsBasicIntroductory Courses
Benefits and Hazards of Excel Microsoft 365BasicIntroductory Courses
Breaking Down Excel FormulasIntermediateFormulas and Functions
Budget SpreadsheetsIntermediateData Analysis
Creating Real Estate ModelsIntermediateCommercial Real Estate
Conditional FormattingIntermediateData Analysis
Custom ViewsIntermediate
Data Analysis
Dashboards: Part 1IntermediateData Analysis
Dashboards: Part 2IntermediateData Analysis
Database TechniquesIntermediateDatabase Integration
Dates and TimesIntermediateData Analysis
Dealing with Duplicate DataIntermediateTroubleshooting
Digging into Excels Validation FeatureIntermediateSpreadsheet Management
Disaster Proofing Excel SpreadsheetsIntermediateTroubleshooting
Dynamic ArraysIntermediateFormulas and Functions
Error-Free SpreadsheetsIntermediateSpreadsheet Management
Excel ChartsBasicTips and Tricks
Excel Error PromptsIntermediateTroubleshooting
Excel For Administrative AssistantsIntermediateTips and Tricks
Excel For Mac - Speed TipsIntermediateTips and Tricks
Excel for Sales ProfessionalsIntermediateIntroductory Courses
Excel Keyboard ShortcutsIntermediateAutomation
Excel NuancesBasicTips and Tricks
Excel PranksIntermediateTips and Tricks
Excels LET and LAMBDA FunctionsAdvancedFormulas and Functions
Filtering and Slicing DataIntermediateData Analysis
Financial Reporting Tips and Tricks in ExcelIntermediateFinancial Reporting
Interactive SpreadsheetsIntermediateForms
Introduction to Spreadsheets: Part 1BasicIntroductory Courses
Introduction to Spreadsheets: Part 2BasicIntroductory Courses
Linked WorkbooksIntermediateSpreadsheet Management
Logic Functions: IF, AND, OR, and MoreIntermediateFormulas and Functions
Lookup Functions: Part 1BasicFormulas and Functions
Lookup Functions: Part 2IntermediateFormulas and Functions
Macros: Part 1IntermediateAutomation
Macros: Part 2IntermediateAutomation
Macros: Part 3AdvancedAutomation
Macros: Part 4AdvancedAutomation
Minimize Data Entry in ExcelIntermediateData Analysis
Payroll AnalysisIntermediateData Analysis
Power QueryIntermediateData Analysis
Pivot Tables: Part 1BasicIntroductory
Pivot Tables: Part 2IntermediateData Analysis
Pivot Tables: Part 3AdvancedData Analysis
Printing and Page LayoutBasicIntroductory Courses
QuickBooks/Excel Analysis: Part 1IntermediateData Analysis
QuickBooks/Excel Analysis: Part 2IntermediateData Analysis
Speed Tips: Part 1Intermediate
Tips and Tricks
Speed Tips: Part 2Intermediate
Tips and Tricks
Spreadsheet Accessibility FeaturesBasicSpreadsheet Management
Spreadsheet Internal ControlsIntermediateSpreadsheet Management
Spreadsheet PranksIntermediateSpreadsheet Management
Spreadsheet Skyscrapers vs Spreadsheet SprawlBasicSpreadsheet Management
Summing FunctionsIntermediateFormulas and Functions
Table FeatureIntermediateSpreadsheet Management
Taming Large SpreadsheetsIntermediateSpreadsheet Management
Waterfall CalculationsAdvancedCommercial Real Estate
What-If AnalysisIntermediateData Analysis
What's New in Excel 2019IntermediateIntroductory Courses
XLOOKUPIntermediateFormulas and Functions
Zombie ExcelIntermediateSpreadsheet Management

Scheduling:

If booking options don’t appear above you may also click the Make an Appointment button: