Overview:
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!
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!
Speaker
Andy Lanning, owner, trainer, and Chief Nerd of Computer Software Training, LLC. Andy has 25+ years of experience teaching computer software in the corporate and university environments. She teaches basic to advanced levels in most Microsoft Office programs. She is adjunct faculty at Boise State University, since 1994 to present, where she specializes in computer training for the Center for Professional Development. She also travels to teach at company conferences across the U.S. Andy’s background includes corporate training, private training, and freelance data analysis. She has recorded several online training courses for Udemy.com, GoSkills.com, and in her career has delivered hundreds of courses and webinars on a variety of Microsoft topics.Who Should Attend
- Accountants
- Accounts
- Audit
- Aviation
- Banking
- CFOs
- Controllers
- CPAs
- Education
- Energy
- FDA
- Finance
- Financial consultants
- Human Resource
- Insurance
- Investments
- IT
- Logistics & Supply Chain
- Marketing
- Medical Devices
- Pharmaceutical
- Retail
- Sales
- Telecom
