Webcast: Excel Tables and Conditional Summing (XSEXTB219)
Tell a Friend About This EventTell a Friend
 

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.

9/12/2019
When: September 12, 2019
12:00 PM until 2:00 PM
Where: Webcast
Surgent
EXTB-2019-01-WEBNR-255-01
United States
Presenter: Jeff Lenning


Online registration is closed.
« Go to Upcoming Event List  

Acronym XSEXTB219
CPE 2 hours
Vendor Surgent
Category
Management
Level Basic
Yellow Book? No
CFP Credit? No
Registration Fees
Members* $89
CPA Non-Members $114

*The member rate applies to LCPA members, other state CPA society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

Texas CPAs: Our Texas State Board of Public Accountancy Sponsor number is #010423.

Course 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

Designed For

Accounting professionals using Excel for Windows

Requisite Knowledge:

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

Note: Login instructions will be provided by the webcast vendor (Surgent).