Login
Excel Yourself/Excel Data Analysis Essentials Bundle
Get access for free

  • Free

Excel Data Analysis Essentials Bundle

  • Bundle
  • 8 Items

The big 3 topics in data analysis in Excel - Power Query - import & clean the data - Formatted Tables - store & access the data - PivotTables + Power Pivot - model & report This bundle brings these 3 skills together. Bonus: Excel Guidelines + Data Visualisation Each course has its own pdf manual, data + certificate of completion. Level: Intermediate to Advanced Duration: 8.5 hours Price : FREE
Get now

Contents

  • Free

Excel Data Visualisation Techniques

  • Course
  • 4 Lessons

This session introduces you to various techniques that can improve your use of charts and other visualisations. See how to use icons and emojis. Discover how to create a variance chart and a bullet chart in Excel. Version: Microsoft 365 Recorded: March 2026 Level: Intermediate Duration: 1 hour Price: Free
View product

  • Free

Excel Guidelines 2023

  • Course
  • 6 Lessons

Suggestions and recommendations to improve your Excel files. These guidelines will help you use and create spreadsheets that. - are more reliable - identify errors - are easier to use and understand - have more flexible formulas (can be copied to more places) - are more structured - are easy to navigate Version: All Versions Recorded: Sep 2023 Level: Intermediate Duration: 1 hour Price: Free
View product

  • Free

Excel Power Query Tips

  • Course
  • 6 Lessons

Power Query simplifies importing data into Excel. These tips help to make using Power Query a bit easier. Tips covered relate to. -listing errors -data types and why they are important -financial year hack -IFERROR in Power Query? -renaming steps -adding notes to steps -default settings Version: All Versions Recorded: August 2025 Level: Intermediate Duration: 1 hour Price: Free
View product

  • Free

Format As Table 2025

  • Course
  • 4 Lessons

Learn how make the most of tables in Excel by using Format As Table. This is an important data handing skill to master. Tables allow you to build scalable solutions in Excel. See how to use them with range names, formulas, functions and PivotTables. Version: All Versions (some content requires the subscription version) Recorded: Oct 2025 Level: Intermediate Duration: 1 hour Price: Free
View product

  • Free

Introduction to Excel Power Query - 2025

  • Closed
  • Course
  • 7 Lessons

Learn how to automate the data importation process in Excel. Import CSV files and perform data cleansing steps at the same time. See how to convert a MYOB report into real data. Version: All Versions Recorded: January 2025 Level: Intermediate Duration: 1 hour Price: Free
View product

  • Free

Introduction to Power Pivot 2026

  • Course
  • 7 Lessons

Pivot Tables on steroids - in a good way. See how to report on multiple tables in one report. Includes an introduction to DAX functions. Version: All Versions Recorded: Feb 2026 Level: Intermediate Duration: 90 minutes Price: Free
View product

  • Free

PivotTable Essentials 2025

  • Course
  • 6 Lessons

This updated session covers the basics of pivot table creation. Topics covered include - pivot cache what it is and why it is important - data rules that make creating pivot tables easier - format as table and why you need to use it -the basics of creation -pivot charts -filtering with slicers -fixing heading terminology Recorded: Dec 2025 Level: Intermediate Duration: 1 hour Price: Free
View product

  • Free

Power Query - Import Multiple Files 2024

  • Closed
  • Course
  • 7 Lessons

Learn how to automate the data importation process in Excel. Discover how to combine all the CSV files from a folder and sib-folder. See how to combine sheets from multiple Excel files. Version: All Versions Recorded: June 2024 Level: Intermediate Duration: 1 hour Price: Free
View product