Back to all courses

Microsoft Excel Analysing and Presenting Data

The aim of the course is to enable you to understand the tools available in Excel to summarise and present data. The course covers a variety of options that Excel and its Add-ins can give you to display summarised data in a Dashboard. It takes you through the steps of preparing your data to the final visual display of the data.

Save to my Shortlist Save to shortlist Share Share

Certification:

College Certificated

Duration:

  • One day trainer-led or virtual
Enquire now

Who is this course for?

This course for those seeking to enhance their proficiency of analysis and presenting data in Microsoft Excel.

What qualifications will I gain?

Fife College Certificate of Attendance

What will I learn on the course?

You will complete the following outcomes:
  • Preparing and shaping your data;
  • Introduction to Power Query;
  • Power Pivot;
  • Dashboard Creation with Pivot Tables, Charts and Slicers;
  • Overview of 3D mapping

Preparing and shaping your data

  • Importing data
  • Organising data
  • Trimming, Cleaning, concatenating, splitting using Functions

Introduction to Power Query

  • Understand the Power Query window
  • Understand where data can be imported from
  • Create a simple query
  • Transform by moving, splitting, merging and removing
  • Create custom columns
  • Load data into a worksheet or data model
  • Generate a Date table

Power Pivot

  • Build data models
  • The importance of Tables
  • Understand and create relationships between tables
  • Building DAX (Data Analysis eXpressions) formulas

Dashboard Creation with Pivot Tables, Charts and Slicers

  • Summarise with Pivot Tables and Pivot Charts
  • Create a Pivot Table from Power Pivot data
  • Use the GETPIVOTDATA function
  • Create charts with the same settings from a chart template
  • Use Sparklines
  • Add Slicers for filters
  • Apply Conditional formatting with Icons, Data Bars or Colour scales
  • Use Form controls to make charts more dynamic
  • Using the Camera tool
  • Use the Analyse Data tool

3D mapping overview

  • What data is required?
  • Create a 3D map
  • Visualise your data
  • Change the look of your 3D map

Application Information

What further course options are available?

Please explore our range of training courses available on our website.

How will this help my career?

This course enhances your proficiency of analysis and presenting data Microsoft Excel which you can take back into your workplace activities to improve productivity.

Related courses

View all courses