Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

20WS-0634: Surgent's Excel Tables and Conditional Summing (Webinar)

If you have questions about this event, please call us at 952-831-2707.

Friday, September 11, 2020
12:00pm - 2:00pm Central Time
2 CPE (2 non-technical)

Alternate dates & more options

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 subjects

  • 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 objective(s)

  • 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 program?

Accounting professionals using Excel for Windows

Fees

Our records indicate you are a nonmember. If you register, you will be charged $89.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.
Standard Member Fee $89.00
checkmark Standard Nonmember Fee $89.00

More program information

Instructor Jeff Lenning, CPA, CITP
Location Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (2.0)
Level Basic
Format Group Internet Based
Sponsor Surgent
NASBA ID#: 103212
Prerequisites Prereq. Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU), or, comparable knowledge about VLOOKUP
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business days before the event start date. Learn more

Not a member? Join the MNCPA to start saving on CPE and accessing members-only benefits.

Search CPE catalog

If you have questions about this event, please call us at 952-831-2707.