Several Approaches to Summing Excel Data

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Several Approaches to Summing Excel Data September   8 1 pm - 2:40 pm ET Presenter: David Ringstrom, CPA, author and nationally recognized Excel instructor 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 Course Reviews: View Testimonials Learn More Register Today Course Description   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 Course Reviews from Past Attendees 100% of attendees recommend this webinar. "I liked the recreation of the formulas to follow each step." "I learned so much!" "Told me how to use some functions differently." Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. Learn More Register Today All-Access Membership   ● 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 Learn More Upcoming Webinars International Tax Forms Update September 5 at 1 pm ET Learn More Nexus and Drop Shipments and Sales and Use Tax September 5 at 3 pm ET Learn More Microsoft Excel Tools of the Trade September 6 at 3 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.