Students leave this class with more confidence in using PivotTables and Charts in spreadsheets and a great understanding of how data in Excel can be displaying in a visual way.
In the Microsoft Excel Pivot Table and Charts training, students will come from class with more confidence in using Pivot Tables and Charts and an understanding of how data in Excel can be displayed in a visual way. They will learn how to create Pivot Tables that can calculate, compare, and total data from a table. They will also feel confident in how to use all of the various formatting tools to make their Pivot Tables pop. Students will also learn all of the different types of charts in Excel and when to use each. Additional charting techniques will be covered that will make your charts really stand out from the default templates, including drop-lines, unique axis formatting, and using trending and analysis tools