Courses

Surgent's Excel Tables and Conditional Summing

Register

Member Price: $99.00 Non-Member Price: $129.00

Date/Time:: Feb 21, 2025, 10:00am–12:00pm
Developer:: SURGENT MCCOY SELF-STUDY CPE, LLC
CPE Credits:: Computer Science: 2.00
Fields of Study:: Computer Science
Level:: Basic

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.

Objective

Understand how and when to use the Table feature
Comprehend the function arguments for conditional summing
Discover how to use the mapping table technique

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

Designed For

Accounting professionals using Excel for Windows

Prerequisite

Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU), or, comparable knowledge about VLOOKUP

Advanced Preparation

None