Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Microsoft PowerBI - Fundamentals of Power Query CXOPBI106W2
View Registrations Tell a Friend About This EventTell a Friend
 

Data can be messy, in other words, it is not always clean and neat. Data comes from various sources like text files, Excel spreadsheets, databases, report files, etc. This is where most data analysis project fail € the inability to get the correct data. This class focuses on using Power Query (Get and Transform in Excel 2016) to clean, shape and transform your messy data while still allowing you one click refresh.

 Export to Your Calendar 9/6/2017
When: 8:00 AM to 10:00 AM
Where: Webinar/Webcast
United States
Presenter: Bryan L. Smith, CPA.CITP, CISA
Contact: April Deneault
801-466-8547
« Go to Upcoming Event List  

Office 365

Field of Study

Computer Software & Applications - Non-Technical

Credit:  2

Level:  Advanced

Designed for:

All CPAs and Accounting Professionals that want to learn how to analyze data

Objective

After attending this presentation, you will …

  • Understand how Power Query can solve your data needs
  • Be able to use Power Query to get more data into Excel
  • Know how to create a one-click refresh of your data

Description

The major topics that will be covered in this class include using Power Query to:

  • Append files
  • Combine multiple files from a folder
  • Add custom columns
  • Unpivot a table
  • Create a lookup table from a table

 

Price:  $79.00

Link to register:  http://cpe.cpacrossings.com/CXOPBI106W2?partner=uacpa

Event Code:  7876

Keywords:

Powerbi Power Query Extract Get And Transform Excel Import Data Analysis Data Analytics Data

Membership Management Software Powered by YourMembership  ::  Legal