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-800-223-8720
Live Webinar
90 minutes
Event Description
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

At the Q&A session following the live event, ask a question and get a direct response from our expert speaker.

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:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Excel as a BI Tool: Demystifying Power Query
    Presenter(s): Mike Thomas

Our Accreditation Partners Protection Status