K2's Automating Data Cleanup with Excel and Power Query - On Demand (2 Hours)
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. Attend this session and help your team automate your data cleanup routines so you can update analyses with little to no human effort required.
- Fundamentals of Power Query, including supported data types
- Important things to know and key commands available on the Power Query menus
- Practical examples of data cleanup automation techniques which can be used by attendees after the webinar
Upon completing this course, you should be able to:
- 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
Who Should Attend: Professionals who want to automate routine data import, export, and cleanup tasks with Microsoft Excel and Power Query
Course Level: Intermediate
CPE Credits: 2 Hours Computer Software and Applications
Prerequisites: Basic understanding of Microsoft Excel
Advance Preparation: None
Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.