Surgent's Excel Tables and Conditional Summing (EXTB)

Course Details

Date

Friday, November 13, 2020

7:00am – 9:00am

Field of Study

Technology

Course Number

SU0404

CPE Credit

2.0 hours CPE credit

Level of Knowledge

Basic

Vendor

Surgent McCoy CPE, LLC

Prerequisites

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

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

Designed For

Accounting professionals using Excel for Windows

Registration for this course has passed.

Course Pricing

Member Fee

Applicable if you are a HSCPA member in good standing.

$89.00
Non-Member Fee

Applicable if you are not a HSCPA member.

$119.00
Your Price $119.00

CPE Choice

Learn more about CPE Choice.
This course does not qualify for CPE Choice.

View All Webcasts