skip to navigation skip to content
Self-taught course

Provided by: University Information Services - Digital Literacy Skills


This course is self taught (Materials may be loaned out).

Bookings cannot be made on this course (Course is not taking bookings).

More information about UIS self-taught courses.

Booking / availability

Microsoft Excel 2016 Data Analysis Add-Ins

Self-taught course


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.

Target audience

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.

Topics covered

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

Related courses

Booking / availability