Customer Service: 800-778-7436     

To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Excel Tables and Conditional Summing (EXTB)

Wednesday, May 1, 2024
12:00 PM - 02:00 PM (Eastern)

Jeff Lenning

  • Format Webinar
  • Credits 2.00
  • Level Basic
  • Field of Study Computer Software & Applications (2)

$99.00


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.

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

Learning 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

Who should take this course:

Accounting professionals using Excel for Windows

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

None

No

No

No

loading

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:


Loading...

QAS Approval Surgent IRS Approval Surgent CFP Approval Surgent CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.