Microsoft PowerBI - Fundamentals of Power Query

Description

Data can be messy. Since data comes from various sources, like text files, Excel spreadsheets, databases and report files, it is not always clean and neat. This inability to get the correct and clean data is exactly why most data analysis projects fail. This webcast focuses on using Power Query, as well as Get and Transform in Excel 2016, to clean, shape and transform your messy data while still allowing you the 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.

Date/Time

Monday, November 11, 2019
Registration Time: 9:00am
9:00am – 11:00am

Add to Outlook calendar

Course Type

On-line Live Vendors

CPE Credit

2.00 hours CPE credit

Field of Study

Specialized Knowledge & Applications

Level of Knowledge

Advanced

Designed For

All accounting professionals

Vendor

AICPA

Prerequisites

Knowledge of Microsoft Excel

Advanced Preparation

None

Objectives

When you complete this webcast, you will be able to:

 Understand how Power Query can solve your data needs.

 Use Power Query to get more data into Excel.

 Create a one-click refresh of your data.

Location

N/A (This is a webcast)
Member Fee $99.00
Non-Member Fee $129.00
Your Price $129.00
View more conferences and courses

Registered for CPE? Log in to download electronic course materials.