by Ian Littlejohn | Publisher: Stone River eLearning | Release Date: February 2018 | ISBN: 200000006A0430

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: Power Query Cleaning up Data Merging Data Appending Data Grouping Data Loading data to PowerPivot Power Pivot Create relationships between Tables Manage millions of rows of data Custom Calculations, Key Metrics and KPIs Analyzing Data with Pivot Tables Analyzing Date data Power View 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 Power Map Mapping Data with Power Map Changing the Method of Visualization Changing the Method of Aggregation Mapping Data over Time Creating Tours This course will provide you with an easy to follow step by step approach to using the new Business Intelligence technology in Excel 2013.

1. Promo 00:02:25
2. Introduction
   • Introduction to Excel Business Intelligence Technologies 00:02:59
   • Activating Addins 00:02:21
3. Working with Power Query
   • Power Query Interface 00:08:40
   • Cleaning and Transforming Data with Power Query 00:14:40
   • Appending Data with Power Query 00:09:22
   • Merge Data with Power Query 00:08:53
   • Using the Group By Feature 00:08:06
   • Load Data to Power Pivot 00:10:15
4. Working with Power Pivot / Data Model
   • Introduction to Power Pivot 00:01:50
   • Loading Data into PowerPivot 00:07:28
   • Creating Relationships 00:03:42
   • Analyzing Data with Pivot Tables 00:08:57
   • Calculated Columns 00:12:11
   • Calculated Fields 00:11:34
   • Pivot Tables and Pivot Charts 00:14:30
   • Creating Interactive Dashboards 00:14:31
5. Excel Power View
   • Introduction to Power View 00:04:12
   • Tables and Tiles in Power View 00:08:15
   • Visualization Column and Bar Charts 00:14:27
   • Visualizations Line 00:05:56
   • Interactive Dashboard 00:09:55
   • Using Filters in Power View 00:06:04
   • Creating Scatterplots in Power View 00:07:12
   • Creating ScatterPlots over Time 00:04:25
   • Mapping Data 00:07:49
6. Power Map
   • Introduction to Power Map 00:03:00
   • Mapping Data in Power Map 00:03:39
   • Changing the Method of Visualization 00:05:32
   • Mapping Over Time 00:01:43
   • Changing the Method of Aggregation in Power Map 00:04:43
   • Creating Tours of Power Map Data 00:03:04
7. Conclusion
   • Conclusion 00:00:51