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.

Date/Time

Thursday, June 27, 2019
Registration Time: 12:00pm
12:00pm – 2:00pm

Add to Outlook calendar

Course Type

On-line Live Vendors

CPE Credit

2.00 hours CPE credit

Field of Study

Specialized Knowledge & Applications

Level of Knowledge

Basic

Designed For

Accounting professionals using Excel for Windows

Vendor

Surgent McCoy CPE, LLC

Prerequisites

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

Advanced Preparation

None

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

Location

N/A (This is a webcast)
Member Fee $89.00
Non-Member Fee $89.00
Your Price $89.00
View more conferences and courses

Registered for CPE? Log in to download electronic course materials.