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: Making a Connection (PQS2)

Choose CPE Format:

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

On-Demand Webcast

Credits: 1

Qualifies For: CPE

$59
Buy Now
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: Making a Connection (PQS2)

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

    CPE

Overview

This course explores the workflow of making connections to various data sources using the Excel version of Power Query. 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 second 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:

  • Workflow of making a connection
  • Get data
  • Navigator dialog box
  • Query options
  • Global and current workbook
  • Data load options
  • Queries and connections
  • Data source settings
  • Hands-on examples: importing files and databases

Learning Objectives

  • Recognize the many connectors Power Query can work with and how to connect to multiple data sources
  • Understand how to import various types of files and databases

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:

GO BACK
CHECK OUT NOW

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)

  • Does NOT include select+ courses

$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

QAS Approval Surgent IRS Approval Surgent CFP Approval Surgent CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.