Skip to main content

Happy holidays! The WSCPA will be closed December 23-27th.

Need last-minute WBOA-required ethics credits? Check out this self-study program: Washington Ethics and New Developments with Mark Hugh 2024 - ON DEMAND

Power BI - Prepare Your Data Efficiently for Excel Analysis WEBCAST

-

Add to Calendar

Your Desk

2.0 Credits

Member Price $118.00

Non-Member Price $142.00

Overview

Before you can analyze data, you first must get the data. This webcast 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). After this webcast you will finally be able to get the data you need to perform data analysis.

Highlights

Getting data into the correct structure. Data sources that you can access. Working with multiple tables and data sources. Steps to import data for analysis. Introduction to Power Query and Get and Transform.

Prerequisites

Working knowledge of Excel features and functions.

Designed For

Anyone who uses Excel to analyze data.

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.

Preparation

None.

Notice

None.

Leader(s):

Leader Bios

Bryan Smith, CPA Crossings LLC

Bryan L. Smith, CPA, CITP, CISA is the co-founder of CPA Crossings in Rochester, MI. He is a CPA with a strong background in information technology and serves as a virtual CIO to CPA firms and professional organizations. He specializes in the planning and deployment of effective technology solutions. Bryan and John Higgins recently authored Ten Steps to a Digital Practice in the Cloud, which has been published by the AICPA. Bryan helps firm leaders understand the opportunities associated with deploying information technology to improve productivity, enhance client services, and increase profitability. He uses his extensive knowledge and experience to help CPAs bridge the gap between business and technology. He is a past chair of the Michigan Association of CPAs Information Technology Committee and the Leadership Committee.

Return to Top

Non-Member Price $142.00

Member Price $118.00