Welcome to Global Excel Summit 2022

The Global Excel Summit is a premium global conference bringing together the brightest minds from the world of Excel.

Evently

Stay Connected & Follow us

Simply enter your keyword and we will help you find what you need.

What are you looking for?

Good things happen when you narrow your focus
Welcome to Conference
Sale

Messy to Magnificent: Cleansing and organizing your data with Power Query (with Oz du Soleil)

£99.00 inc. VAT

This is an introductory Power Query class that will teach you how to import, cleanse and reshape data so that it is useful, easy to work with and saves you tons of time.

 

Without clean, trustworthy data, you have nothing. No dashboards, no forecasts, no analysis … nothing.
– Oz du Soleil, Excel on Fire, Excel MVP & LinkedIn Instructor

 

Who is this for?

Anyone who regularly has to work with data that’s not immediately useful. Customer Service Reps, Sales Assistants, Marketers, Event Planners, Analysts, etc.

 

What will you learn?

โœ”๏ธŽ What Power Query is and how it can make your life easier and your data useful

โœ”๏ธŽ Methods for handling common data-cleansing tasks

โœ”๏ธŽ Merging datasets using Power Query’s joins

โœ”๏ธŽ Appending data from multiple sources

 

What’s included?
โ–ถ๏ธ 4.5 hours on-demand class with Oz du Soleil, Microsoft MVP
๐ŸŽ“ Claim up to 4.5 hours of CPD (Continuing Professional Development) hours / points
๐Ÿ—‚ All presentation and spreadsheet files
๐Ÿ—“ Lifetime on-demand access
๐ŸŒ Join from anywhere in the world

 

*This Masterclass is also included in our 6x Masterclasses Bundle , as well as, our all-inclusive Conference + 6x Masterclasses full event package.

In stock

Description

Masterclass Description: Too few people know about Power Query, an Excel feature that’s been around since Excel 2010. It is designed to help import, cleanse and reshape data so that the data is useful. Imagine … you finally got the data you wanted but,

  • it’s all stacked in a single column and needs to be unstacked
  • the Name, Employee ID, Email and Address are all in the same cell
  • you’ve got 15 worksheets’ worth of data that need to be swept into one place before it can be useful.
  • you need to compare datasets to identify what’s in Dataset A that’s not in Dataset B
  • your data is in a report that was structured for another purpose, but needs to be rearranged for your needs
STOP! Don’t copy-paste or start scrolling, eye-balling, dragging and typing. In this class, Oz will share methods for handling these (and other) common needs. You’ll also see how these tasks can be automated when you have to re-do them on a regular basis. Excel’s Power Query simplifies these tasks through a robust interface – minimizing or even eliminating the need to write formulas or code.

 

Skills requirements: This is an introductory Power Query Masterclass. No previous knowledge or experience with Power Query is required. However, you should be an intermediate Microsoft Excel user to follow along.

 

About your Instructor: Oz du Soleil is an Excel developer, trainer, videographer, author, LinkedIn instructor, and Microsoft Excel MVP. He is known for his brash, overly dramatic YouTube videos at Excel on Fire. Oz likes to go beyond Excel tips-&-tricks to bring you the real world why, how and when. He wants you to get the most from Microsoft Excel. Oz is a US Navy veteran and lives in Portland Oregon.ย  Fun fact: Oz is in a documentary about sriracha hot sauce. Full profile here.