Back to Search

Excel Tables and Conditional Summing Webinar

CPE

When
Sept. 12
1:00 - 3:00 p.m.

CPE Credits
2-Other

Details

 Pricing

PICPA Member: $89 | Nonmember: $114


 More Information

Course No.
EXTB-2019-01-WEBNR-255-01
Level
Basic
Prerequisites
Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU), or, comparable knowledge about VLOOKUP
Note
This webinar is hosted by PICPA's partner, Surgent CPE. After registering, you will receive an email from Surgent CPE with the log-in information.

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.

Highlights

  • Understand how and when to use the Table feature
  • Comprehend the function arguments for conditional summing
  • Discover how to use the mapping table technique


Speaker(s)


You May Also Like

IRS Internet Resources for Accountants Webinar
Feb. 24 | Webinar
The course provides a concise overview of the Internet services offered by the Internal Revenue Service or IRS, the tax agency of the United States federal government. Discover scores of ...
Power BI - Use Advanced Calculations with DAX Formulas Webinar
Feb. 24 | Webinar
* This course is #7 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see suggested viewing order. * This course focuses ...
Word - Learn the Fundamentals Webinar
Feb. 24 | Webinar
Microsoft Word is probably the most under-utilized application of the Microsoft Office Suite of applications. As a matter of fact, most people use Word as a glorified typewriter. During this ...