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)

Choose CPE Format:

Live Webinar SELECT STARTING AT $99 (4 dates)

Credits: 2

Qualifies For: CPE

Instructor(s): Jeff Lenning

$99

Choose a Webinar Date

(All Times Eastern)

Please choose a Webinar date

NO HASSLE REFUNDS & TRANSFERS
EASY CANCELLATIONS
I learned a lot - this helped me become more efficient with excel.
Jeanie

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.

Excel Tables and Conditional Summing (EXTB)

  • Customer Rating
    (14)
  • Field of Study
    Computer Software & Applications
  • Level
    Basic
  • Credits
    2
  • Qualifies for

    CPE

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

Designed for:

Accounting professionals using Excel for Windows

Prerequisite:

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

Advanced Preparation:

None

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.
loading

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:


Loading...

Thank You!

Thank You! Your request has been submitted.



Get more with an Unlimited CPE subscription

Unlimited PLUS

  • Unlimited access to ALL live CPE webinars, including premium courses

  • Unlimited 24/7 access to on-demand webcasts and self-study PDF courses

  • Includes select gamified CPE courses from Surgent Interactive

  • Access for a year from date of purchase

  • Auto-renew locks in your price for next year (can cancel any time)

$899

 BUY NOW 

Unlimited Webinars

  • Unlimited access to all non-premium live CPE webinars

  • Includes 1, 2, 3, 4 and 8 CPE sessions

  • Access for a year from purchase date

  • Auto-renew locks in your price for next year (can cancel any time)

  • Provides online grading & CPE certificates by email

  • Does NOT include Premium courses and select* courses

$749

 BUY NOW 

 


Unlimited Self-Study

  • Unlimited 24/7 access to 250+ downloadable PDF courses

  • Courses range from 1-20 credits

  • Access for a year from date of purchase

  • Auto-renew locks in your price for next year (can cancel any time)

  • Provides online grading & CPE certificates by email

  • Does NOT include Premium courses and select^ courses

$549

 BUY NOW 

 


+Excludes: ETDE, AFTR, ETTX, Certification Courses, and select Surgent Interactive games (MTT2, MTT4, MTT5, MTT6, MTT7, SAU1, SAU2, SAU4, SAU5, SAU6, BDV1, and RPA1)

*Excludes Premium Webinars & Ethics for Delaware (ETDE)

^Excludes: ETDE, ETTX, AFTR, Certificate Courses, and Interactive Games

 

Explore additional courses by topic

  • Accounting and Auditing CPE courses

    Accounting &
    Auditing

  • Business and Industry CPE courses

    Business &
    Industry

  • Ethics CPE courses

    Ethics

  • Financial Planning CPE courses

    Financial
    Planning

  • Fraud and Forensics CPE courses

    Fraud &
    Forensics

  • Government and Non-Profit CPE courses

    Government/
    Non-Profit

  • Personal Development CPE courses

    Personal
    Development

  • Practice Management CPE courses

    Practice
    Management

  • Taxes CPE courses

    Taxes

  • Tech CPE courses

    Tech

 

Qualifies for

CFP CFP® Board-approved CE for Certified Financial Planners


CMA IMA-approved CE for Certified Management Accountants

CPE NASBA-approved CPE for Certified Public Accountants


CTEC California Tax Education Council-approved CE

IRS IRS-approved CE for Enrolled Agents and the AFSP


YB GAO-fulfilling Yellow Book audit requirements

CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.