Power Query is a feature that is built into Excel 2016 and later and can be added for free to Excel 2010 and 2013. In this presentation Excel expert David H. Ringstrom, CPA helps you get started with this feature that enables you to create set-and-forget data extractions and reports. The presentation leads off with creating a list of worksheets in any Excel workbook. You'll then see how to extract text from cells that even worksheet functions can't handle. You'll see how Power Query can wrestle even the most convoluted accounting report exports into in an analysis-ready format. You'll also see how to unpivot any report that has separate columns by account, class, or other measure into a list that is far better suited to data analysis.
This webinar is available with
NO ADDITIONAL FEE if you have an active
all access membership or
webinar membership or can be purchased for
$20.00!
Instructor: | David Ringstrom |
Course No: | COMP-PQUERY-G12291 |
Recommended CPE: | 2.00 |
Delivery Method: | Group Internet Based - Webinar |
Date Offered: | 2/19/2021 10:00 AM - 12:00 PM |
Level of Knowledge: | Intermediate |
Prerequisites: | None |
Advanced Preparation: | None |
Registration Requirements: | Registration with GoToWebinar is required |
Recommended Field of Study: | Webinars - Group Computer Software and Applications
|
|
|
|
Learning Objectives
- Demonstrate how to use Power Query to extract text from cells based on non-breaking spaces
- Identify the location of the Power Query commands within Microsoft Excel
- Recall how to unpivot a report into an analysis-ready format