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

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