O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Business Intelligence with Excel 2013

Video Description

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.