In this Third 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 four of the certificate program.
Completion of Part 1 and 2 and passage of the Mastery Quiz