| Attend upcoming webinar and earn continuing education credits. | Several Approaches to Summing Excel Data | | | | | | | | February | | | | 14 | | 1 pm - 2:40 pm ET | | | Presenter: David Ringstrom, CPA, Owner and Founder of Accounting Advisors, Inc. | | | Credits: CPE (Credit Details) | | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | | | In this webinar, you'll learn about six different worksheet functions available for summing data in Microsoft Excel: SUM, SUBTOTAL, AGGREGATE, SUMIF, SUMIFS, and SUMPRODUCT. You'll also learn how to use Excel's INDIRECT, OFFSET and Subtotal features. Upon completion of this course, you'll be able to: - Apply the INDIRECT and OFFSET functions to create more flexible formulas
- Define two different contexts for Excel's SUMPRODUCT function
- Identify how to use SUBTOTAL to streamline summing multiple areas of a spreadsheet
- Compare the AGGREGATE function in Excel 2010 and later to the SUBTOTAL function available in all versions of Excel
- Describe the array of functionality the SUMPRODUCT function offers
- Insert totals into lists with a few mouse clicks by way of Excel's Subtotal feature
- Identify a simple design technique that greatly improves the integrity of Excel's SUM function
- Quickly sum disparate sections of a spreadsheet with the SUBTOTAL function
- Explain how to save time when aggregating data from multiple worksheets with Excel's INDIRECT function
- 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
- Verify sums and totals quickly by simply selecting cells with your mouse
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. | | | | | | | | | | David H. Ringstrom, CPA, is the owner and founder of Accounting Advisors, Inc., a spreadsheet consulting firm. Mr. Ringstrom is an author and nationally recognized instructor who teaches scores of webinars each year and provides Microsoft Excel training and consulting services nationwide. Mr. Ringstrom's Excel courses are based on 25 years of consulting and teaching experience. | | | | | | | | | | | ● Earn continuing education credit for no additional fee
● Access courses on your computer, tablet, or smartphone
● More than 75 live webinars each month
● More than 1,000 on-demand courses | | | | | | |
No comments:
Post a Comment