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. I [...]
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 [...]
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 thr [...]
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 [...]
Many Excel users, even those at the intermediate level, tend to not use one of Excel's most powerful tools out of the belief that they are more complicated than they really are. Pivot Tables are one of the most powerful tools available to yo [...]
If you aren't currently utilizing dashboards or if your dashboards haven't changed in years and stopped having an impact then this is the program for you. Join Excel guru David Ringstrom as he teaches you how to harness the power of Dashboar [...]
Learning how to effectively use Excel Macros can be a daunting task. Excel Macros are an extremely powerful tool, but typically underutilized because of their complexity. This package of courses is focused on guiding you through learni [...]
This package is designed for the business professional who is already an Excel Power User, but is looking to master the most advanced techniques. Join Excel experts as they break down the power of Macros, how to use Array Formulas and how to creat [...]
Now that you have the basics of Excel mastered it's time to take your game to the next level. This package is designed to build upon your current Excel skills and prepare you to truly utilize all of the powerful tools that Excel offers. Whether yo [...]
In this live webcast, Excel expert David Ringstrom, CPA, takes you beyond the basics of pivot tables. Step-by-step, he explains how to implement the PivotTable feature, the [...]
This introductory course will prepare you to develop and work with Excel spreadsheets. Expert David Ringstrom, CPA, walks you through the basics, providing the knowledge ne [...]