Introduction to Data Analysis using Excel

Course objectives

Build a basic understanding of the importance of data analysis and how this can be carried out using Microsoft Excel. Data analysis is as a crucial step in any decision-making process to ensure successful outcomes company wide, and Excel is one of the most highly rated tools for data analytics globally. In this course, you will learn how to perform data analysis using Excel’s most popular features such as pivot tables, slicers, charts, and formulas. You'll learn how to maximise these features to flexibly summarise, explore, and critically analyse data on a personal or organisation-wide scale.

What you will learn

In this course, you will learn how to:

  • Create flexible data aggregations using pivot tables
  • Represent data visually using pivot charts
  • Calculate margins and other common ratios using calculations on pivot tables
  • Filter data using slicers in multiple pivot tables
  • Create aggregate reports using formula-based techniques

Prerequisites

  • A basic understanding of creating formulas and how rows and columns reference cells within Excel. (You can find many helpful topics on Excel at the Microsoft Office Support Site if required)

What is included  

  • Videos and reading resources
  • Hands-On Labs  
  • A total of 74 questions
  • Certification

Course Outline

  1. Introduction to reporting in Excel
  2. Excel tables
  3. Basic pivot tables
  4. Dashboards
  5. Profitability analysis and finding anomalies
  6. Comparing year over year in pivot tables
  7. Reporting hierarchical data
  8. Introduction to multi-table pivot tables and the data model