- Credits: 2
- Format: Self-Study Video
- Field of Study: Computer Software and Apps
- Author/Speaker: David Ringstrom
|Course ID:||Advanced Preparation:||Experience Level:|
|Published Date:||Program Prerequisites:||Other Course Formats:|
|© June 2020||Basic Understanding of Technology||N/A|
In this informative presentation, Excel expert David Ringstrom, CPA, shows you how to create resilient and easy-to-maintain budget spreadsheets. Among other techniques, David explains how to separate inputs from calculations, build out a separate calculation spreadsheet, create both an operating and a cash flow budget, transform filtering tasks, and preserve key formulas.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
- Building operating budgets quickly based on detailed supporting schedules that provide an audit trail.
- Understanding why it’s worthwhile to build out supporting schedules to break down calculations used in budgets.
- Avoiding the complexity of nested IF statements with Excel’s CHOOSE function.
- Preserving key formulas using hide and protect features.
- Crafting formulas to compute gross margins, projected sales, commissions, and related amounts.
- Using range names to streamline formulas and bookmark key inputs within a workbook.
- Understanding the use of the MONTH function to return the month portion of a date or month name.
- Copying formulas efficiently down one or more columns at the same time.
- Improving the integrity of budget spreadsheets by isolating all inputs to a single worksheet.
- Employing the SUMIF function to sum values related to multiple instances of criteria you specify.
After reading the course material, you will be able to:
- Identify the first level of Excel’s Order of Operations when calculating formulas.
- State where range names assigned to worksheet cells appear within Excel’s user interface.
- State which tabs within the Format Cells dialog box contains the Hidden checkbox.
Who Should Attend:
- All Certified Public Accountants (CPAs)