Purchase any Event and get
20% Off
CODE: TWENTY20
T&C applicable, please referFAQ
Validity : 15th Feb'25 to 25th Feb'25
Excel: Power Query Intro
- How to begin a Power Query
- How to Extract data from your Source files into the Power Query
- How to Transform the data (clean it up)
- View a few examples of the Transform process
- Learn the power of the Query Settings and the Advanced Editor
- How to Load the data and Save the Excel file
- And finally, how to re-open and edit the Power Query Settings
Overview of the webinar
Power Query is a “data-clean-up” tool useful in prepping data for further Excel analysis spreadsheets.
Power Query is a somewhat new feature, it first made its entrance in Excel 2010, and now is a standard part of Excel 2016 and 2019.
Power Query is a tool designed for Excel to handle repetitious steps specifically tied to data prep. We all know the drudgery of removing columns, shifting rows, correcting data formats… all before we can actually do the work with the data!
The old alternative was to use macros for this redundant work; but even those were hard to edit and not everyone is comfortable with VBA code.
In this crash course, you will learn how to find Power Query in Excel, load data into it, begin the process of transforming your redundant tasks (one last time!), and then how to Save and Load the Query to Excel to finish your reports.
Take this course and benefit from Andy Lanning’s 20+ years of experience. At the finish, you will realize how hard you have worked without Power Query helping you through your data prep, and soon rejoice at your new-found time savings!
Who should attend?
- Anyone that is tasked with cleaning and/or prepping data sets for further work in Excel
- All Excel Users
- Accountants
- CFOs
- Controllers
- CPA's
- Financial Consultants
- Human Resources Professionals
- Marketing Professionals
- Sales Professionals
- Supervisors
- Business Owners
- Database Administrators (DBA)
- Trainers
- Managers
Why should you attend?
When the daunting task of 'cleaning up data' comes across your desk, are you using the amazing features of Excel's Power Query?
It is surprisingly common to find oneself repeating a process daily or weekly simply because we didn’t know there was a better way. This is true with prepping data for Excel.
Attend this webinar for a crash course in Power Query and you’ll be amazed at the time you save by no longer redundantly cleaning data.
Faculty - Ms.Andy Lanning
Andy Lanning has worked extensively with Microsoft Office products since the early 1990s.
She has traveled the United States presenting at conferences and corporate classes to help attendees unlock the full potential of the most common office software programs faced daily in our lives: Microsoft.
Andy considers herself a computer “nerd” and has been training individuals and groups since 1995. She continues to teach computer VoTech classes at Boise State University in Idaho and is the owner of a computer consulting business.
She is a Certified Microsoft Office Specialist and trains most Microsoft programs. With 30+ years’ experience in the computer industry, Andy focuses every class on using software to solve common workflow issues.
Be prepared to learn more than you bargained for in her class. Andy always teaches the 5 Super Secrets to computers and believes firmly in efficiency training.
“My goal is to lower frustration and raise productivity. And maybe have some laughs along the way!”
Software specialty areas include:
- Microsoft 365: Word, Excel, Outlook, PowerPoint, Publisher, Teams
- Excel topics: Charts and Data Visualization, Formulas, Hidden Tools of the Trade, Data Analysis tools, Pivot Tables and Power Queries
- Office Processes: mail merges, forms, databases, data analysis, including
- Power BI training
- How to set up accessible PDF and Word docs to comply with the US Federal
- ADA Law (American’s with Disabilities Act)
- Video Conferences: Zoom, Teams, and standalone VTC systems
- Internet and E-mail
- Computer Basics