Mobile Edition


Excel Tables and Conditional Summing (EXTB) (SUEXTB03)

 
Date:Thursday, September 12, 2019
Time:1:00 PM - 3:00 PM
(Registration at 12:30PM)
Facility:Webcast or Webinar, Online
CPE Credit:2.0 Technical Business
Instructor: Jeff S. Lenning
Vendor:Surgent McCoy
Course Level:Basic
Early Bird Price:$89.00 FICPA Members, $119.00 Non-Members

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.

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 Topics:
  • Using the Table object to store data
  • Using the conditional summing function to aggregate Table data
  • Using the Table object to create mapping tables


Who Should Attend:
Accounting professionals using Excel for Windows

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

Advanced Preparation:
None

Session/Options

If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.