Surgent’s Excel Tables and Conditional Summing
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.
Objective
Understand how and when to use the Table feature Comprehend the function arguments for conditional summing Discover how to use the mapping table technique
Advanced Preparation
None
Required Knowledge
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU), or, comparable knowledge about VLOOKUP
Who Should Attend
Accounting professionals using Excel for Windows
Credit Types
- CPE – Computer Software & Applications
Event Level:Basic
Event Code:EXTB-2026-01-WEBNR-243-01
Event Vendor:Surgent Accounting & Financial Education
Fields of Study:CPE - Computer Software & Applications
Other fields:
Registration Fees
| Registration | Type | Price |
|---|---|---|
| WRS37726: Registration – Member | Mem | $105 |
| WRS37726: Registration – Non-Member | NM | $230 |
The North Carolina Association of Certified Public Accountants is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org/.For information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call 800-469-1352.