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

5/14/2015
When: 5/14/2015
11:00 AM - 1:00 PM
Where: Webcast/Webinar
Presenter: Jeff Lenning
Contact: April Deneault
801-834-6634


Online registration is closed.
« Go to Upcoming Event List  

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 Subjects:

* 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 2007, Excel 2010, or Excel 2013 for Windows

 

Prerequisite:

Basic knowledge of Excel for Windows

 

Advanced Prep: None

  

Speaker: Jeff Lenning

Vendor: Surgent McCoy

Field of Study: Info Tech

Level: Basic

CPE Credit: 2 Hours

Acronym: EXTB

 

Registration Fees:

$89

 


Membership Management Software Powered by YourMembership  ::  Legal