Surgent's Excel Tables and Conditional Summing
Overview
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.
Delivery Method: Individual webcast
CPE Credit: Computer software & applications
Program Level: Basic
This course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Highlights
- Using the Table object to store data
- Using the conditional summing function to aggregate Table data
- Using the Table object to create mapping tables
Prerequisites
Surgent’s Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU), or, comparable knowledge about VLOOKUP
Designed For
Accounting professionals using Excel for Windows
Objectives
- Understand how and when to use the Table feature
- Comprehend the function arguments for conditional summing
- Discover how to use the mapping table technique
Preparation
None
Leader(s):
- Jeff Lenning, CalCPA Education Foundation
Non-Member Price $104.00
Member Price $99.00