My Shopping Cart
There are no items in your shopping cart.

Excel as a BI Tool: Demystifying Power Query (IMEO18A)

Presented by: Mike Thomas
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
90 minutes
Event Description
See the sneak peek before you buy!
1.0 CPE

Handle Big Data Efficiently

Do you import and manipulate large, unwieldly datasets in Microsoft Excel? Then you’re already well aware of the software’s limitations! But Power Query (known as Get and Transform in Excel 2016) is designed to break through those limitations, allowing you to work efficiently and effectively with datasets of a million rows or more—imported  from virtually any source.

Mike Thomas has a passion for teaching Excel and has hosted hundreds of courses and webinars showing users how to move beyond the program’s basic functions. Power Query is Excel’s most powerful data tool, and Thomas can teach you to use it to transform big data into a format ready for pivot tables and reports.

In this session, you will learn to import data into Excel from external sources, link to external sources, create pivot tables from external data sources, use the Query Editor to clean and transform data, and create calculated columns in pivot tables. Get expert guidance for using this tool and unleash the power of big data.

Session Highlights

This program will teach you how to:

  • Import data into Excel from external sources
  • Link to external sources
  • Create pivot tables from external data sources
  • Use the Query Editor to create calculated columns in pivot tables
  • Use the Query Editor to clean and transform data

Who Should Attend

  • C Level Executives
  • Executive Assistants
  • Accountants
  • Administrators
  • Office Managers
  • Attorneys
  • CPA
  • Finance Professionals
  • Business Analyst
  • Accountants
  • Bookkeeper
  • HR Professionals
About Our Speaker(s)

Mike Thomas | Microsoft Excel Technology Training SpeakerMike Thomas
Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Excel as a BI Tool: Demystifying Power Query
    Presenter(s): Mike Thomas

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team