Customer Service: 800-778-7436     

To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Power Query Series: Introduction and First Connection (PQS1)

Choose CPE Format:

Self-Study SELECT STARTING AT $59 (On Demand)

On-Demand Webcast

Credits: 1

Qualifies For: CPE

$59
Reviews Not Available.

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.

Power Query Series: Introduction and First Connection (PQS1)

  • Customer Rating
    Reviews Not Available.
  • Field of Study
    Information Technology
  • Level
    Basic
  • Credits
    1
  • Qualifies for

    CPE

Overview

This course is designed for the Excel user to begin their data analytics journey with an introduction to a product created for their skill set: Power Query, using the Excel version. Power Query is an ”ETL” tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the first in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.

Major Topics:

  • What is Power Query?
  • Why should I learn Power Query?
  • What are the benefits of using Power Query?
  • Power Query is not just for Excel
  • Power Query versions are not the same
  • What version of Power Query do I have?
  • How to get Power Query
  • Making your first connection in Power Query
  • Hands-on examples: connection query, editing a query, duplicating a query

Learning Objectives

  • Understand what Power Query is and the benefits of using it
  • Understand how to access Power Query

Designed for:

Excel users who want to develop data analytics skills

Prerequisite:

None

Advanced Preparation:

Save all data sets provided to a central location on your computer

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.
loading

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:


Loading...

Thank You!

Thank You! Your request has been submitted.



Get more with an unlimited CPE subscription

Unlimited Plus

  • Unlimited access to ALL live CPE webinars, including premium courses

  • Unlimited 24/7 access to on-demand webcasts and self-study PDF courses

  • Includes select gamified CPE courses from Surgent Interactive

  • Access for a year from date of purchase

  • Auto-renew locks in your price for next year (can cancel any time)

$899

 BUY NOW 

Unlimited Webinars

  • Unlimited access to all non-premium live CPE webinars

  • Includes 1, 2, 3, 4 and 8 CPE sessions

  • Access for a year from purchase date

  • Auto-renew locks in your price for next year (can cancel any time)

  • Provides online grading & CPE certificates by email

  • Does NOT include Premium courses and select* courses

$749

 BUY NOW 

 


Unlimited Self-Study

  • Unlimited 24/7 access to 250+ downloadable PDF courses

  • Courses range from 1-20 credits

  • Access for a year from date of purchase

  • Auto-renew locks in your price for next year (can cancel any time)

  • Provides online grading & CPE certificates by email

  • Does NOT include Premium courses and select^ courses

$549

 BUY NOW 

 


+Excludes: ETDE, AFTR, ETTX, Certification Courses, and select Surgent Interactive games (MTT2, MTT4, MTT5, MTT6, MTT7, SAU1, SAU2, SAU4, SAU5, SAU6, BDV1, and RPA1)

*Excludes Premium Webinars & Ethics for Delaware (ETDE)

^Excludes: ETDE, ETTX, AFTR, Certificate Courses, and Interactive Games

 

Explore additional courses by topic

  • Accounting and Auditing CPE courses

    Accounting &
    Auditing

  • Business and Industry CPE courses

    Business &
    Industry

  • Ethics CPE courses

    Ethics

  • Financial Planning CPE courses

    Financial
    Planning

  • Fraud and Forensics CPE courses

    Fraud &
    Forensics

  • Government and Non-Profit CPE courses

    Government/
    Non-Profit

  • Personal Development CPE courses

    Personal
    Development

  • Practice Management CPE courses

    Practice
    Management

  • Taxes CPE courses

    Taxes

  • Tech CPE courses

    Tech

 

Qualifies for

CFP CFP® Board-approved CE for Certified Financial Planners


CMA IMA-approved CE for Certified Management Accountants

CPE NASBA-approved CPE for Certified Public Accountants


CTEC California Tax Education Council-approved CE

IRS IRS-approved CE for Enrolled Agents and the AFSP


YB GAO-fulfilling Yellow Book audit requirements

CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.