|
Accelerate Excel: Six Ways to Sum | (160822_N) |
Course CPE: 2 hours Fields of Study: Personal Development–2 hrs Program Level: Intermediate Prerequisites: Previous training or research on subject matter being taught. Such persons are often at a mid-level within the organization, with operational and/or supervisory responsibilities. Advanced Preparation: None Delivery Method: Self-Study |
Item
Number: 16PPM0822
Shipping Weight: 0lbs. 0oz. |
Price:
$140.00 |
|
|
Recording Date: August 8, 2016
Presenter: David Ringstrom
Program Description:
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 course, you will be able to:
- Recognize the INDIRECT and OFFSET functions to create more flexible formulas
- Identify three different contexts for Excel’s SUMPRODUCT function
- Identify how to use SUBTOTAL to streamline summing multiple areas of a spreadsheet
For more information regarding refund or concerns, please contact our offices at (800) 677-2009.
The Consultants’ Training Institute (CTI) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
|
|
|