View Catalog

Use Power Query to Transform Your Data

ID: 54323
Topics: Technology
NON-MEMBERS$85.00
MEMBERS$70.00
YOUR PRICE$85.00

This class focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh. We will review various data issues including appending files, combining multiple files from a folder, adding custom columns, unpivoting data, creating a lookup table, and much more. 

Learning Objectives:

Use Power Query to solve your data clean-up issues 

Determine how Power Query allows you to get more data into Excel

Speakers

Bryan Smith
Bryan 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.