November 23, 2022


Webinar


2 Total CPE Credits

product-artwork-1764083

K2's Excel Power Query - Ten Things You Need to Know

  • Instructor

    Ward Blatch

Learning Objectives

  • List Excel versions that include Power Query
  • Create Power queries to Pivot and Unpivot data
  • Construct Power Queries to split data columns and combine data columns
  • Build Power Queries to group data by fiscal quarters and years
  • Identify opportunities to utilize Power Query to support reporting functions

Major Topics

  • What is Power Query
  • Importing data from various sources, including text, Excel, web sites, and databases
  • How to clean-up imported data

CPE Credits Available

2
Total CPE
2
Computer Software & Applications

Things to Know About This Course

Course Level

  • Intermediate

Prerequisites

Fundamental knowledge of computer operations, including Excel

Advanced Preparation

None

Intended Audience

Accounting, financial, and business professionals who want to learn how to use Excel’s Power Query feature

Provider

ACPEN

This event has ended.