We use cookies to provide you with a better experience. Full functionality may not be available if cookies are denied.

Your use of this website and your submission of information to BusinessWatch Network means you have agreed to BusinessWatch Network’s privacy policy.
If you do not agree to the terms of the privacy policy or want to remove your information from BusinessWatch Network, please click here BusinessWatch Network Data Removal Form to unsubscribe from such data collection.
California Residents please go to this section Privacy Notice For California Residents for more information.

  • Blog
  • MediaKit
  • Whitepapers
  • Sign In
  • Create Account
  • Sign Out
  • My Account
0
  • Training Pass
  • Webinars
    • Popular Upcoming Live Webinars
    • All Upcoming Live Webinars
    • Recorded Webinars
  • Newsletters
  • Subscribe
  • TechWatch
    Webinars
  • FinanceWatch
    Webinars
  • Sales&MktgWatch
    Webinars
  • ExecWatch
    Webinars
  • MgmtWatch
    Webinars
  • HRWatch
    Webinars
  • MFGWatch
    Webinars
  • HealthWatch
    Webinars
Home » Events » [Group Registration] Excel - Power Query: Turn Bad Data into Great Data in Minutes

[Group Registration] Excel - Power Query: Turn Bad Data into Great Data in Minutes

[Group Registration] Excel - Power Query: Turn Bad Data into Great Data in Minutes
[Group Registration] Excel - Power Query: Turn Bad Data into Great Data in Minutes

When

1/12/22 1:00 pm EDT
Our Customer Assurance Pledge
[Group Registration] Excel - Power Query: Turn Bad Data into Great Data in Minutes

If this webinar fails to meet your needs, we will refund 100% of your tuition – no hassles, no questions asked.

5-9 Attendees

Small Team
$89.00
Per Attendee

Quantity

10-19 Attendees

Medium Team
$79.00
Per Attendee

Quantity

20-29 Attendees

Large Team
$69.00
Per Attendee

Quantity

     Sign up for Business Watch Network's Training Pass to get access to our entire training library!

  • Customer Reviews
  • Speaker
  • Topics
  • Companies Who Trust Us

Event Description

Have more than 30 attendees? Issues during checkout? Or want to register your team directly with the help of a BusinessWatch Network Customer Representative? Please Reach Out To: support@bizwatchnetwork.com


Do you spend time each month importing data into Excel from other sources such as CSV files, text files, web pages, databases, and SharePoint?

Do you spend more time than is necessary getting your data into the right format for your reports, performing repetitive "data cleaning and transforming" tasks such as removing unnecessary rows and columns, filtering out data that you don't need, converting text to numbers or dates, splitting, or merging columns, removing "weird" characters, or combining files together?

Would you like to be able to do all of this with the click of a button?

With Power Query (known as Get and Transform in Excel 2016 and later) you can automate loading and updating external data into Excel and cleaning and transforming data. Of course, you can also do all of this with macros but who wants to learn VBA when you can do it using the Power Query Editor with a much shorter learning curve. (VBA still has its place.)

Why you should attend
If you work with, analyze, and generate reports from external datasets and need to clean the data each time it is imported, having a good understanding, and working knowledge of Power Query/Get and Transform is a must.

Who should attend?
This training is aimed at users of Excel who wish to learn about Power Query/Get and Transform. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.

IMPORTANT NOTE: Power Query/Get and Transform is not available on the Mac platform, the mobile platform or Excel Online (Excel in a web browser).

Customer Reviews Back To Top

 
 

Speaker Back To Top

Mike ThomasMike Thomas is a highly skilled trainer and developer in Microsoft Excel and other Office productivity tools. His webinars are well-known for his engaging, patient and thorough teaching style.

Topics Back To Top

Topics covered:

  • Import data into Excel from sources such as text files, web pages and databases
  • Avoid Excel's "million-row limitation"
  • Keep the imported data in sync with the source data using just two clicks
  • Managing Steps in the Power Query Editor
  • Save a ton of time - automate the cleaning process

Companies Who Trust Us Back To Top

Trusted Customer Logo

KEYWORDS attend , cleaning , columns , data , excel , external , files , knowledge , learn , platform , power , query , query/get , removing , reports , spend , text , time , transform , transforming
Back To Top
  • Do not Sell my Personal Information
  • Privacy Policy
  • About Us
  • Contact Us
  • Media Kit

Copyright ©2023. All Rights Reserved
Design, CMS, Hosting & Web Development :: ePublishing