Automating Data Cleanup with Excel and Power Query
Help your team automate your data cleanup routines so you can update analyses with little to no human effort required.
Power Query, an automation tool for Microsoft Excel, can take your productivity to the next level by helping you import, clean up, organize and summarize data for use in Excel or any tool which can accept input from an Excel file. This revolutionary tool is included or is available for most supported versions of Microsoft Office which are licensed for use in businesses today and supplements Excel’s macro features with a new toolkit created to help users automate recurring data manipulation tasks.
Applicable For
Professionals who want to automate routine data import, export and cleanup tasks with Microsoft Excel and Power Query
Content
Upon completion of this course, participants should be able to perform the following tasks:
Identify when one might utilize key items off of the Data, Get and Transform command group in Excel, including getting data from tables, workbooks, text files, databases, web pages, and other sources
Select correct definitions/explanations for key terms associated with Power Query such as DAX, ODBC, Power Pivot, Pivot Tables, and the M programming language
Select from a list data types which can be processed using Power Query
Identify an example of when one might want to use the ""Open from Folder"" tool in Power Query
What to Expect
Upon completing the registration process, you will receive an email from the provider within two business days confirming your registration along with instructions on how to join. Registrants can come and go from the course as often as they like.
A test with 5 questions per hour and a 70% pass rate is required to confirm attendance.
How Do I Connect?
Follow the steps outlined in the provider email to join the training session.
If you are having any technical issues during the session, please view the Help resources, where you will find technical support for the most common questions. If you need additional assistance, please call 1 985.542.9390 or send an email to [email protected].
CPA Manitoba PD Terms and Conditions