Microsoft Excel 2016 Data Analysis Add-Ins LoanNew
Microsoft Excel 2016 - Data Analysis Add-Ins will show you how to use the data analyis 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.
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
- 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 Video
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
Watsonia workbook with 63 topics. Files for the exercises are provided on a CD or can be downloaded here
Approximately 20 hours
Booking / availability