Excel - Get and Transform your Data with Power Query

This session teaches attendees how to use Excel's "Get and Transform (Power Query)" feature to automate data import, cleaning, and shaping, saving time and providing a solid foundation for those unfamiliar with Power Query.
  • Tuesday
  • February
  • 25
  • 2025
10:00 AM PST | 01:00 PM EST
Duration: 75 Minutes
IMG Steve Kraynak
Webinar Id: 60772
Live
Session
$119.00
Single Attendee
$249.00
Group Attendees
Recorded
Session
$159.00
Single Attendee
$359.00
Group Attendees
Combo
Live+Recorded
$249.00
Single Attendee
$549.00
Group Attendees

Overview:

This session will provide attendees with the knowledge required to get started using Excel’s feature known as “Get and Transform (Power Query)” to automate the process of importing, cleaning, and shaping their data.

Why should you Attend:

If you’re tired of tedious and repetitive steps to prepare your data in Excel, this course will save you valuable time. If you've never heard of Power Query, or you want to learn a good foundation to jump start your use of it, this course is for you.

Areas Covered in the Session:

  • You'll learn how to create a repeatable process for importing, cleaning and shaping your data in Excel
  • Understand the different types of data sources that can be imported into Excel using "Get and Transform (Power Query)"
  • Learn the key aspects and benefits of Power Query, and how to get started using it to save yourself time
  • Get an overview of the many data cleaning and transforming tools at your fingertips
  • Learn commonly used techniques for cleaning and checking your data
  • Understand how to combine data from different sources
  • Get comfortable managing your queries and loading the data into your spreadsheet

Who Will Benefit:

  • Anyone who uses Excel and wants a solid Foundation for Writing Formulas
  • Accountants and Bookkeepers
  • Administrative Professionals
  • Finance Professionals
  • Healthcare Professionals
  • HR Professionals
  • IT Professionals
  • Managers
  • Marketing Professionals
  • Planners and Project Managers
  • Scientists
  • Small Business Owners

Speaker Profile

Steve Kraynak enjoys helping others learn and succeed with Excel and is recognized as a Microsoft MVP (Most Valuable Professional) for his expertise and contributions to the community of Excel users worldwide. He is a Director at SumProduct.com, a leading modelling, training, and business consultancy firm, with offices around the world.

Steve was a Product Manager for the Excel team at Microsoft for more than a decade prior to joining SumProduct. He has nearly 30 years of experience working with Excel in the software and manufacturing industries, where he made his mark by using Excel and related tools to analyze data, solve problems, and automate and simplify many business processes.

Steve has been a featured presenter and trainer at Microsoft Ignite, Excelapalooza, Excel Summit South, Excel Virtually Global, Microsoft Business Applications Summit (MBAS), EuSpRIG, the Meonske Accounting Conference, APIC, Microsoft TechReady, the SharePoint Conference and others.

Steve likes to encourage people that "It can be done!" in Excel, so they don't limit their thinking or their goals. He also likes to provide solutions that are simple and understandable, since not everyone is an expert.