View Catalog

Prepare Your Data for Analysis

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

This course focuses on getting data into Excel using different data sources. Whether your data is text, comma delimited (CSV), reports, Excel, databases, web, applications and/or many others, Excel provides the ability to access that data. You will learn about tools that have been added to Excel that will make accessing that data even easier, such as data models and Power Query (Get and Transform).

Learning Objectives:

Differentiate between improper and proper data structure

Select the best way to import data into Excel

Identify ways to use Power Query to clean your data

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.