Microsoft Excel 2016 - Data Analysis Add-Ins

INF1647
978-1-925349-10-8
B&W printed

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.

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

  View outline

View a detailed outline of the course material. You may need to install Adobe Acrobat Reader to open this file.

View Outline

  Download student files

Download working files to go with this course. Read the installation instructions for opening these files.

Download Files Zip