Surgent's Excel Tables and Conditional Summing
Monday, November 11, 2024
Webcast or Webinar, Online
1:00 PM - 3:00 PM (opens at 12:30PM) EST
2Credits
Technical Business
Registration is Open
Members
$99.00 Regular Price
Non-Members
$129.00 Regular Price
CPE PowerPass Users
Click the "Apply PowerPass" button to use your PowerPass for the applicable course below.
$40.00 Members / $56.00 Non-Members
Don't have a CPE PowerPass? Click
here to find out more about the CPE PowerPass program.
Course Type: Webcast
Course Code: 24/SUEXTB57
Level: Basic
Vendor: Surgent
Field of Study: Computer Software and Applications
Overview:
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
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