skip to navigation skip to content
Self-taught course

Provided by: University Information Services


Booking

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
LoanNew

Self-taught course

Description

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.

Prerequisites

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
Objectives

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
Format

Watsonia workbook with 63 topics. Files for the exercises are provided on a CD or can be downloaded here

Duration

Approximately 20 hours

Related courses
Theme
Spreadsheets

Booking / availability