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 | |
| QuickBooks Online Analysis Basics | Basic | Introductory Courses | |
| Advanced QuickBooks Online Analysis | Intermediate | Data Analysis | |
| Keyboard Shortcuts | Basic | Introductory Courses | |
| Dynamic Array-Based Financial Statements | Intermediate | Financial Reporting | |
| Managing Budgets in QuickBooks Online | Basic | Introductory Courses | |
| Spreadsheet AI | Intermediate | Tips and Tricks | |
| Introduction to Python | Advanced | Data Analysis | |
| Automating Financial Statements with Power BI | Intermediate | Automation | |
| Introduction to Power BI | Basic | Introductory Courses | |
| Macros versus Power Query | Intermediate | Automation | |
| Form Controls | Intermediate | Interactive Spreadsheets | |
| Introduction to Python in Excel | Advanced | Data Analysis | |
| AI and Microsoft Excel | Intermediate | Tips and Tricks | |
| Introduction to Power BI | Basic | Introductory Courses | |
| Excel Macros versus Power Query | Intermediate | Automation | |
| 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 Data Validation | 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 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 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 | |
| XLOOKUP | Intermediate | Formulas and Functions | |
| Excel for Operations Management | Intermediate | Spreadsheet Management | |
| Zombie Excel | Intermediate | Spreadsheet Management |
Scheduling:
If booking options don’t appear above you may also click the Make an Appointment button:
