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

Part 2: Taking Control of Your Data with Tables and Conditional Summing (CSC2)

Choose CPE Format:

Self-Study SELECT STARTING AT $59 (On Demand)

On-Demand Webcast

Credits: 0

Qualifies For:

$59
Buy Now
This new course has not yet been reviewed. Check back soon!
Leave a Review

Interested in bringing this course into your firm?

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

Part 2: Taking Control of Your Data with Tables and Conditional Summing (CSC2)

  • Customer Rating
    Not Yet Rated
  • Field of Study
    Spec. Knowledge
  • Level
    Basic
  • Credits
    0
  • Qualifies for

Overview

In this second module of the Excel Critical Skills Certificate Program we will explore the powerful concept of splitting data from reports, and dig into the mechanics that enable this technique. The key to it all is the Tables feature, and the function that lets you take control of your data with tables is the multiple condition summing function. We’ll first understand these items fully and then apply them in a variety of ways. Upon completing this two-hour module and passing the mastery quiz you’ll have the tools to take control of your data with tables—and you’ll be ready to take your skills to the next level with module three of the certificate program.

Major Topics:

  • Using the Table object to store date
  • 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:

Completion of Part 1 and passage of the Mastery Quiz

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:

GO BACK
CHECK OUT NOW

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)

  • Does NOT include select+ courses

$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

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.