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.
Presentation | Level | Subject | Most Popular/New |
---|---|---|---|
Power BI Dashboard Basics | Basic | Introductory Courses | New for 2024 |
QuickBooks Online Analysis Basics | Basic | Introductory Courses | New for 2024 |
Advanced QuickBooks Online Analysis | Intermediate | Data Analysis | New for 2024 |
Keyboard Shortcuts | Basic | Introductory Courses | New for 2024 |
Dynamic Array-Based Financial Statements | Intermediate | Financial Reporting | New for 2024 |
Managing Budgets in QuickBooks Online | Basic | Introductory Courses | New for 2024 |
Spreadsheet AI | Intermediate | Tips and Tricks | New for 2024 |
Introduction to Python | Advanced | Data Analysis | New for 2024 |
Automating Financial Statements with Power BI | Intermediate | Automation | New for 2024 |
Introduction to Power BI | Basic | Introductory Courses | New for 2024 |
Macros versus Power Query | Intermediate | Automation | New for 2024 |
Form Controls | Intermediate | Interactive Spreadsheets | New for 2024 |
Introduction to Python in Excel | Advanced | Data Analysis | New for 2024 |
AI and Microsoft Excel | Intermediate | Tips and Tricks | New for 2024 |
Introduction to Power BI | Basic | Introductory Courses | New for 2024 |
Excel Macros versus Power Query | Intermediate | Automation | New for 2024 |
10 Productive Excel Features for Accountants (and 3 Timewasters) | Intermediate | Tips and Tricks | |
Advanced Excel Skills for Accountants | Intermediate | Spreadsheet Management | |
Analyzing Property Management Reports | Intermediate | Commercial Real Estate | |
Auditing Spreadsheets | Intermediate | Data Analysis | |
Basic Excel Skills for Accountants | Basic | Introductory Courses | |
Benefits and Hazards of Excel Microsoft 365 | Basic | Introductory Courses | |
Breaking Down Excel Formulas | Intermediate | Formulas and Functions | |
Budget Spreadsheets | Intermediate | Data Analysis | ★ |
Creating Real Estate Models | Intermediate | Commercial Real Estate | |
Conditional Formatting | Intermediate | Data Analysis | |
Custom Views | Intermediate | Data Analysis | |
Dashboards: Part 1 | Intermediate | Data Analysis | ★ |
Dashboards: Part 2 | Intermediate | Data Analysis | |
Database Techniques | Intermediate | Database Integration | |
Dates and Times | Intermediate | Data Analysis | |
Dealing with Duplicate Data | Intermediate | Troubleshooting | |
Digging into Excels Validation Feature | Intermediate | Spreadsheet Management | |
Disaster Proofing Excel Spreadsheets | Intermediate | Troubleshooting | |
Dynamic Arrays | Intermediate | Formulas and Functions | |
Error-Free Spreadsheets | Intermediate | Spreadsheet Management | ★ |
Excel Charts | Basic | Tips and Tricks | |
Excel Error Prompts | Intermediate | Troubleshooting | |
Excel For Administrative Assistants | Intermediate | Tips and Tricks | |
Excel For Mac - Speed Tips | Intermediate | Tips and Tricks | |
Excel for Sales Professionals | Intermediate | Introductory Courses | |
Excel Keyboard Shortcuts | Intermediate | Automation | |
Excel Nuances | Basic | Tips and Tricks | |
Excel Pranks | Intermediate | Tips and Tricks | |
Excels LET and LAMBDA Functions | Advanced | Formulas and Functions | |
Filtering and Slicing Data | Intermediate | Data Analysis | |
Financial Reporting Tips and Tricks in Excel | Intermediate | Financial Reporting | |
Interactive Spreadsheets | Intermediate | Forms | |
Introduction to Spreadsheets: Part 1 | Basic | Introductory Courses | ★ |
Introduction to Spreadsheets: Part 2 | Basic | Introductory Courses | |
Linked Workbooks | Intermediate | Spreadsheet Management | |
Logic Functions: IF, AND, OR, and More | Intermediate | Formulas and Functions | |
Lookup Functions: Part 1 | Basic | Formulas and Functions | ★ |
Lookup Functions: Part 2 | Intermediate | Formulas and Functions | ★ |
Macros: Part 1 | Intermediate | Automation | ★ |
Macros: Part 2 | Intermediate | Automation | |
Macros: Part 3 | Advanced | Automation | |
Macros: Part 4 | Advanced | Automation | |
Minimize Data Entry in Excel | Intermediate | Data Analysis | |
Payroll Analysis | Intermediate | Data Analysis | |
Power Query | Intermediate | Data Analysis | |
Pivot Tables: Part 1 | Basic | Introductory | ★ |
Pivot Tables: Part 2 | Intermediate | Data Analysis | |
Pivot Tables: Part 3 | Advanced | Data Analysis | |
Printing and Page Layout | Basic | Introductory Courses | |
QuickBooks/Excel Analysis: Part 1 | Intermediate | Data Analysis | |
QuickBooks/Excel Analysis: Part 2 | Intermediate | Data Analysis | |
Speed Tips: Part 1 | Intermediate | Tips and Tricks | ★ |
Speed Tips: Part 2 | Intermediate | Tips and Tricks | |
Spreadsheet Accessibility Features | Basic | Spreadsheet Management | |
Spreadsheet Internal Controls | Intermediate | Spreadsheet Management | |
Spreadsheet Pranks | Intermediate | Spreadsheet Management | |
Spreadsheet Skyscrapers vs Spreadsheet Sprawl | Basic | Spreadsheet Management | |
Summing Functions | Intermediate | Formulas and Functions | |
Table Feature | Intermediate | Spreadsheet Management | |
Taming Large Spreadsheets | Intermediate | Spreadsheet Management | |
Waterfall Calculations | Advanced | Commercial Real Estate | |
What-If Analysis | Intermediate | Data Analysis | |
What's New in Excel 2019 | Intermediate | Introductory Courses | |
XLOOKUP | Intermediate | Formulas and Functions | |
Zombie Excel | Intermediate | Spreadsheet Management |
Scheduling:
If booking options don’t appear above you may also click the Make an Appointment button: