Excel 2013 is a game changer for any Excel user. Excel 2013 provides new technologies and tools for the business user to easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets.
This course is for all business users who want to learn how to create management reports, analyze data and create interactive dashboards using Excel 2013.
In this course we learn the following:
Cleaning up Data
Loading data to PowerPivot
Create relationships between Tables
Manage millions of rows of data
Custom Calculations, Key Metrics and KPIs
Analyzing Data with Pivot Tables
Analyzing Date data
Creating Tables and Cards
Visualizing data with Graphs
Creating Interactive dashboards
Filter and Ask Questions of your Data
Powerful data analysis with ScatterPlots and BubblePlots
Visualize Geographical data and maps
Mapping Data with Power Map
Changing the Method of Visualization
Changing the Method of Aggregation
Mapping Data over Time
This course will provide you with an easy to follow step by step approach to using the new Business Intelligence technology in Excel 2013.