Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Clean, shape, and transform your data.
This course focuses on using Power Query to clean, shape, and transform data while still allowing you a one-click refresh. The course will review various data issues including appending files, combining multiple files from a folder, adding custom columns, un-pivoting data, and creating a lookup table. The course is resented using Excel 2019, but most concepts covered in this course apply to all versions of Excel.
Key Topics:
- File maintenance
- Custom columns
- Un-pivoting a table
- Look-up tables
This course is part of the Microsoft Power BI Bundle.
Please note, this course contains an assessment component which will only appear once the course has been viewed completely. Learners are permitted multiple attempts to complete the course assessment with a passing grade.
Key Takeaways
By the end of this course, you will be able to:
- Use Power Query to solve your data clean-up issues.
- Determine how Power Query allows you to get more data into Excel.
- Apply a one-click step to refresh your data.
Who Will Benefit
Finance Professionals looking to learn how to clean, shape, and transform their data.
Disclaimer
Most of CPA Ontario's 450+ on-demand courses are compatible with the mobile app. Unfortunately, this on demand course is not compatible. For the best learning experience, we suggest you use your computer.
How to Access the Course
To access your course, visit the CPA Ontario Blackboard site and sign in using the same username and password used for the Registration Portal.
Important: Course access begins on the date of purchase and remains available for the Access Time specified for the course under Dates and Location. Please review the access time before purchasing. Note that it may take up to 15 minutes after registration for the course to appear in Blackboard.
Registration, cancellation, withdrawal, and other CPA Ontario PD policies can be found here.
Speaker(s)
Bryan Smith, CPA, CITP, CISA, serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.