| Accelerate Excel: Six Ways to Sum
Program Type: Recorded Webinar (Audio, PPT Presentation)
Program Level: Intermediate
Prerequisites: Previous training or research on subject matter being taught.
Advanced Preparation: None
Delivery Method: Group Internet-Based
CPE Credits: Two (2) Hours
Fields of Study: Computer Science
Shipping Weight: 0lbs. 0oz.
Excel expert David Ringstrom, CPA, covers six different worksheets available for summing data in Microsoft Excel: SUM, SUBTOTAL, AGGREGATE, SUMIF, SUMIFS, and SUMPRODUCT. You’ll learn the pros, cons, and limitations of each type of worksheet function, along with suggested uses for each.
David teaches from the version of Excel in use by the majority of attendees, but he explains any differences in Excel 2007, 2010, 2013, and 2016. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain. David’s detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. He also provides an Excel workbook that includes a majority of the examples he uses during each session.
Topics Typically Covered:
- Compare the AGGREGATE function in Excel 2010 and later to the SUBTOTAL function available in all versions of Excel
- Discover the array of functionality the SUMPRODUCT function offers
- Learn a simple design technique that greatly improves the integrity of Excel’s SUM function
- Save time when aggregating data from multiple worksheets with Excel’s INDIRECT function
- Transform SUM, MIN, and MAX into multi-criteria array formulas
- Use Excel’s OFFSET function to dynamically reference data from one or more accounting periods
- Use the SUMIF function to summarize data based on a single criterion
- Use the SUMIFS function to sum values based on multiple criteria
- Use the SUMPRODUCT function to count the number of # sign errors in a worksheet
- Verify sums and totals quickly by simply selecting cells with your mouse
After completing this webinar, attendees will be able to:
- Apply the INDIRECT and OFFSET functions to create more flexible formulas
- Define three different contexts for Excel’s SUMPRODUCT function
- Identify how to use SUBTOTAL to streamline summing multiple areas of a spreadsheet
Who Should Attend
Practitioners seeking to understand alternatives to the SUM function in Microsoft Excel
David H. Ringstrom, CPA
Mr. David H. Ringstrom is the owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. Throughout his career Mr. Ringstrom has spoken at conferences on Microsoft Excel, and written dozens of freelance articles about spreadsheets. He offers Excel and Access training and consulting services nationwide.