One day course $390
Data Analysis using MS Excel 2016 add-ins
Microsoft Excel 2016 – Data Analysis Add-Ins will show you how to use the data analysis add-ins of Microsoft Excel 2016, including using Power View to create interactive data visualisations, using Power Pivot to create a data model for use with Excel tools such as pivot tables and pivot charts, using Get & Transform to import and combine data from a variety of sources such as databases and web sites and using Power Map to visualise geographic data.
At the completion of this course you should be able to:
- use Power View to examine and analyse data
- perform a variety of analytical tasks using Power Pivot
- import and refine data with Get & Transform
- effectively create and work with data in Power Map
Microsoft Excel 2016 – Data Analysis Add-Ins assumes fluency with Microsoft Excel and the creation of workbooks. It would also be beneficial to have a general understanding of personal computers and the Windows operating system environment.
|
Power View
· Understanding Power View · Enabling Power View · Adding Power View to the Ribbon · Creating a Power View Sheet · Working With a Power View Object · Working With Power View Fields · Rearranging and Sorting Fields · Working With Measure Fields · Formatting Power View Data · Tiling Data in Power View · Filtering in Power View · Switching Visualisations · Adding More Power Views · Adding Titles and Images · Updating a Power View Report
|
Power Pivot
· Understanding Power Pivot · Understanding Relational Data · Enabling Power Pivot · Connecting to a Data Source · Working With the Data Model · Working With Data Model Fields · Changing a Power Pivot View · Creating a Data Model PivotTable · Using Related Power Pivot Fields · Creating a Calculated Field · Creating a Concatenated Field · Formatting Data Model Fields · Using Calculated Fields · Creating a Timeline · Adding Slicers
|
|
Get & Transform
· Understanding Get & Transform · Understanding the Navigator Pane · Creating a New Query From a File · Creating a New Query From the Web · Understanding the Query Editor · Displaying the Query Editor · Managing Data Columns · Reducing Data Rows · Adding a Data Column · Transforming Data · Editing Query Steps · Merging Queries · Working With Merged Queries · Saving and Sharing Queries · The Advanced Editor
|
Power Map · Understanding Power Map · Creating a Power Map Tour · Working With Location Fields · Working With Mapping Confidence · Working With Height and Category · Fields · Filtering Data · Navigating a Data Map · Changing the Look · Working With Layers · Working With Scenes · Working With Scene Options · Working With Time Settings · Viewing and Editing a Tour · Exporting a Tour as a Vid |
Computer Smart Training Centre booking form