Learn to analyze data with Pivot Tables that allow you to view and organize your Excel data quickly and easily! Pivot Tables are the main focus of this course, but you will also learn to build, sort and filter lists of information, work with the Excel Table feature, and use the database functions like DSUM. You will create Pivot Tables and Pivot Charts/Report, organize and format Pivot Tables, perform calculations on a Pivot Table, and create and modify Pivot Charts. A discussion of Power Pivot is included in this class and you will learn how to link multiple Workbooks with a Key Field, treating Excel like an Access Database. Once linked, you will be able to analyze the data using built-in Pivot Tables. Textbook is included. Prerequisite: Excel Level One course or equivalent experience.