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
10 Productive Excel Features for Accountants (and 3 Timewasters)IntermediateTips and TricksNEW
Advanced Excel Skills for AccountantsIntermediateSpreadsheet ManagementNEW
Analyzing Property Management ReportsIntermediateCommercial Real EstateNEW
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 AnalysisNEW
Dealing with Duplicate DataIntermediateTroubleshooting
Digging into Excels Validation FeatureIntermediateSpreadsheet ManagementNEW
Disaster Proofing Excel SpreadsheetsIntermediateTroubleshootingNEW
Dynamic ArraysIntermediateFormulas and Functions
Error-Free SpreadsheetsIntermediateSpreadsheet Management
Excel ChartsBasicTips and Tricks
Excel Error PromptsIntermediateTroubleshooting
Excel For Administrative AssistantsIntermediateTips and TricksNEW
Excel For Mac - Speed TipsIntermediateTips and TricksNEW
Excel for Sales ProfessionalsIntermediateIntroductory CoursesNEW
Excel Keyboard ShortcutsIntermediateAutomationNEW
Excel NuancesBasicTips and Tricks
Excel PranksIntermediateTips and Tricks
Excels LET and LAMBDA FunctionsAdvancedFormulas and FunctionsNEW
Filtering and Slicing DataIntermediateData Analysis
Financial Reporting Tips and Tricks in ExcelIntermediateFinancial ReportingNEW
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 AnalysisNEW
Payroll AnalysisIntermediateData Analysis
Power QueryIntermediateData AnalysisNEW
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 ManagementNEW
Spreadsheet Internal ControlsIntermediateSpreadsheet Management
Spreadsheet PranksIntermediateSpreadsheet Management
Spreadsheet Skyscrapers vs Spreadsheet SprawlBasicSpreadsheet ManagementNEW
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: