Advanced Excel for Data Visualization

This course teaches you data visualization, and how to build reports and dashboards using power Excel tools like Pivot Table, Power Query, Power Pivot, Maps, Slicers, Timeline, Drawings, etc.

Course OUTLINE
 The Excel Window Overview
 The Home Ribbon
 Advanced Formulas and Functions
 Data Validation
 Groupings and Subtotals
 Sorting and Filtering
 Names and Name Management
 Data Forecasting
 Drawings in Excel
 Color Management and Themes
 Conditional Formatting
 Color Scaling
 Importing and Formatting Pictures
 Charts in Excel
 Pivot Table and Pivot Charts
 Slicers and Timeline
 Links and Screen tips
 Sparklines
 Building Reports with Pivot Table and Conditional Formatting
 Maps…