February 19, 2026


Vendor Webinar


2 CPE Credits

K2's Accessing Your Company's Data With Power Query And Power BI

February 19, 2026
Vendor Webinar
2 CPE Credits

K2's Accessing Your Company's Data With Power Query And Power BI

Learning Objectives

  • Outline Power Query's noteworthy features and functions and how you can use them for reporting projects
  • Demonstrate how to connect Power Query to web resources, spreadsheets, and databases to extract, transform, and load data into your reports
  • List the various methods to transform your data using Power Query before importing it into a report
  • Demonstrate connecting Power Query and Power BI to a sample data server

Major Topics

  • Utilizing Power Query to access data from the web, spreadsheets, folders, and databases
  • Using Power Query to perform various transformations to clean up data before importing it to Power BI or Excel
  • Producing various reporting documents from data delivered from Power Query

CPE Credits Available

2 CPE Credits
2
General

Things to Know About This Course

Course Level

  • Intermediate

Prerequisites

Fundamental knowledge of Excel

Advanced Preparation

None

Intended Audience

Financial professionals who want to save time, improve accuracy, and promote efficiency with their reporting projects

Provider

ACPEN

Register For This Event

  • MSCPA Member

    $ 79 79
    Join
  • MSCPA Non-Member

    $ 109 109
    Your Price

Please login to register.