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

  • Free

Excel Data Analysis Essentials

  • Bundle
  • 6 Products

The big three in data analysis in Excel are: - Power Query - to import & clean the data - Formatted Tables - to store & access the data - PowerPivot - to model & report on the data This bundle brings these three skills together in one bundle. Bonus: Excel Guidelines course. Each course has its own pdf manual, data + certificate of completion. Level: Intermediate to Advanced Duration: 6.5 hours Price : FREE
Get now

Contents

  • 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

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

Format as Table Feature 2024

  • Closed
  • 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. Version: All Versions Recorded: Jan 2024 Level: Intermediate Duration: 1 hour Price: Free
View product

  • Free

Introduction to Excel Power Query - 2025

  • 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 2022

  • 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: Aug 2022 Level: Intermediate Duration: 1.5 hours 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