Surgent's Excel Tables and Conditional Summing
Friday, June 13, 2025
Noon-2 p.m. Central
2 CPE (2 non-technical)
Course code: 25WS-0378
View pricing
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.
Major subjects
-
Using the Table object to store data
-
Using the conditional summing function to aggregate Table data
-
Using the Table object to create mapping tables
Learning 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
Who should take this program?
- Accounting professionals using Excel for Windows
Pricing
|
Standard Member Fee |
$99.00
|
 Standard Nonmember Fee |
$99.00
|
Our records indicate
you are a
nonmember.
If you register, you will be charged
$99.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Instructor
Jeff Lenning, CPA, CITP
Location
Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (2.0)
Level
Basic
Format
Group Internet Based
Sponsor
NASBA ID#: 103212
Prerequisites
Prereq.
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU), or, comparable knowledge about VLOOKUP
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business
days before the event start date.
Learn more
Search CPE catalog
