Print Page   |   Contact Us   |   Sign In   |   Join
Surgent's Excel Tables and Conditional Summing (EXTB)
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.

6/30/2016
When: Thursday, June 30, 2016
11:00 AM - 1:00 PM
Where: Webinar/Webcast
United States
Contact: April Deneault
801-466-8022


Online registration is closed.
« Go to Upcoming Event List  

Acronym EXTB
CPE 2 hours
Category
Spec. Knowledge
Level Basic
Vendor Surgent
Who should attend

Accounting professionals using Excel 2007, Excel 2010, or Excel 2013 for Windows

Prerequisite
Basic knowledge of Excel for Windows
Fees: Early Bird
Standard
Member N/A
$89
Non-Member: N/A
$109

The Member rate applies to UACPA members and reciprocal state society members. To register online, use the ‘Register’ button above. To register by phone, call the UACPA at 801.466.8022, Monday through Friday, 8am to 4pm.

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.

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

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

Membership Management Software Powered by YourMembership  ::  Legal