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.
Accounting professionals using Excel for Windows
Completion of Part 1 and passage of the Mastery Quiz