Show Menu

Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

Webinar

Surgent's Excel Tables and Conditional Summing

Monday, April 14, 2025
9-11 a.m. Central
2 CPE (2 non-technical)

Course code: 25WS-0041
View pricing

Register Me     Register Multiple

Firm administrators: Please log in before starting the employee registration process.


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
checkmark 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.
Register Me     Register Multiple

Firm administrators: Please log in before starting the employee registration process.

More program information

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 Surgent
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