Surgent's Excel Tables and Conditional Summing (EXTB)

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.

Highlights:

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

Prerequisites:

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

Category:

CS (Computer Science)

Credits:

2

Course Level:

Basic

Members

Standard Fee: $89.00

Non-Members

Standard Fee: $99.00

Register Now

Vendor:

Surgent McCoy CPE, LLC

Start:

September 12, 2019 1:00pm

End:

September 12, 2019 3:00pm

Designed For:

Accounting professionals using Excel for Windows
No

Find A CPA