Events Calendar Courses

Home / Professional Development / Courses

Surgent’s Excel Tables and Conditional Summing (SU1423/22)

Loading Events

« All Events

  • This event has passed.

Surgent’s Excel Tables and Conditional Summing (SU1423/22)

Member Price $99
Non-Member Price $129
If you are a member, please login to activate member pricing.

November 14 @ 1:00 pm - 3:00 pm

Event Description

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.

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

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

Prerequisites

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

Instructions

None

Details

Date:
November 14
Time:
1:00 pm - 3:00 pm

Other

Credit Hours
2
Max Registrations
0
Course Level
B
Course Type
Webinar