www.learnexcelnow.com Open in urlscan Pro
3.89.178.98  Public Scan

Form analysis
3 forms found in the DOM

POST

<form method="post" class="login">
  <p class="woocommerce-FormRow woocommerce-FormRow--wide form-row form-row-wide">
    <label for="username">Username <span class="required">*</span></label>
    <input type="text" class="woocommerce-Input woocommerce-Input--text input-text" name="username" id="username" value="">
  </p>
  <p class="woocommerce-FormRow woocommerce-FormRow--wide form-row form-row-wide">
    <label for="password">Password <span class="required">*</span></label>
    <span class="password-input"><input class="woocommerce-Input woocommerce-Input--text input-text" type="password" name="password" id="password"><span class="show-password-input"></span></span>
  </p>
  <p class="form-row">
    <input type="hidden" id="woocommerce-login-nonce" name="woocommerce-login-nonce" value="2af4efdf8b"><input type="hidden" name="_wp_http_referer" value="/product/power-query-101-import-clean-transform-your-big-data/?PCD=">
  </p>
  <p>
    <label for="rememberme" class="inline">
      <input class="woocommerce-Input woocommerce-Input--checkbox" name="rememberme" type="checkbox" id="rememberme" value="forever"> Remember me </label>
  </p>
  <input type="submit" class="woocommerce-Button button" name="login" value="LOGIN">
  <p></p>
  <p class="woocommerce-LostPassword lost_password">
    <a id="lost-password" href="#woo-login-popup-sc-password" class="woo-login-popup-sc-toggle">Forget Your Username or Password?</a>
  </p>
</form>

POST

<form method="post" class="woocommerce-ResetPassword lost_reset_password">
  <p>Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.</p>
  <p class="woocommerce-FormRow woocommerce-FormRow--first form-row form-row-first">
    <label for="user_login">Username or Email Address</label>
    <input class="woocommerce-Input woocommerce-Input--text input-text" type="text" name="user_login" id="user_login">
  </p>
  <div class="clear"></div>
  <p class="woocommerce-FormRow form-row">
    <input type="hidden" name="wc_reset_password" value="true">
    <input type="submit" class="woocommerce-Button button" value="Get New Password">
  </p>
  <p class="woocommerce-plogin">
    <a id="lost-pass-login" href="#woo-login-popup-sc-login" class="woo-login-popup-sc-toggle">Log In</a>
  </p>
  <input type="hidden" id="_wpnonce" name="_wpnonce" value="2705cb6d51"><input type="hidden" name="_wp_http_referer" value="/product/power-query-101-import-clean-transform-your-big-data/?PCD=">
</form>

<form action="" onsubmit="LO.submit_chat(); return false;">
  <div id="lo_chat_input" style="position:relative; width: 100%; ">
    <div class="lo-fx-hr" style="height:0px; margin-bottom:0px; margin-top:0px; width:100%; border-top:1px solid #000000;border-bottom:1px solid #4f4f4f"></div>
    <div style="padding:10px;"><label for="lo_chat_textarea" style="display:none">Chat Input Box</label><textarea id="lo_chat_textarea" disabled="disabled" rows="2"
        style="color: black; background-color: rgb(255, 255, 255); border-radius: 5px; padding: 7px; height: auto; width: 100%; font-family: sans-serif; text-transform: none; resize: none;" dir="null" data-last-scroll-height="0"></textarea></div>
    <div id="lo_chat_sound_holder" style="position:absolute; right:0px; top:-25px; width:100%;">
      <div style="cursor: pointer; float:right; opacity:0.6; padding-right:10px; height:16px;" id="lo_chat_sound"><img alt="Click to mute chat sounds" src="https://d10lpsik1i8c69.cloudfront.net/graphics/sound-on-white.png"></div>
      <div id="lo_chat_status" style="padding-left:10px; font-size:11px; color:#6d6d6d"></div>
      <div style="clear:both;"></div>
    </div>
  </div>
</form>

Text Content

Learn Excel Now

Conquer the Fear of Excel

 * Home
 * Training
   * Excel
   * MS Office
   * Outlook
   * PowerPoint
   * Word
   * OneDrive
   * Google
 * All-Access
 * eLearning
   * Excel Foundations
 * Resources
 * Login




POWER QUERY 101: IMPORT, CLEAN & TRANSFORM YOUR BIG DATA

Share
 * 
 * 
 * 
 * 




SUMMARY



In this 90-minute, highly interactive instructor-led training, you will learn
how to transform big data much more efficiently.  Discover how to import data
into Excel from a variety of sources and automate the data cleaning process -
with a click of the button!

Gain must-have skills for working with imported data and join us for this
hands-on training to discover:



 * How to navigate the UI: Master the Power Query Editor
 * Simple solutions for automating the data cleansing process
 * 2 simple steps for repeating the data import & cleansing process
 * The “power” of Power Query: Import & manage large datasets with ease


WHY YOU SHOULD ATTEND

We’ll cover the following & more!


 * 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
 * Using the Power Query Editor to Create data transformation actions
 * Managing actions in the Power Query Editor
 * No-code Query creation
 * Unpivot – the hidden gem of the Power Query Editor
 * Calculations without formulas – the power of The Query Editor Ribbon
 * Save a ton of time - automate the data cleaning process

Additional tools:

 * Your questions & specific use-cases will be addressed in real-time, all
   throughout the workshop
 * A 15-minute question & answer, plus wrap-up & review session


ABOUT THE SPEAKER



Mike Thomas has worked in the IT training business since 1989. He is a subject
matter expert in a range of technologies including Microsoft Office and Apple
Mac. During his career, he has produced nearly 200 written and video-based Excel
tutorials. He’s also delivered hundreds of courses and webinars on a variety of
Excel topics.



Mr. Thomas is a Fellow of The Learning and Performance Institute and has worked
with and for many global and UK-based companies and organizations across a
diverse range of sectors. In addition to training, he also designs and develops
Microsoft Office-based solutions that automate key business tasks and processes


PROGRAM BENEFITS



If you work with, analyze, and generate reports from large datasets, having a
good understanding and working knowledge of Power Query is a must! In this
workshop, you’ll discover how to transform big data more efficiently, with fast,
plus powerful data gathering and cleansing capabilities.

If you'd like this program customized for your organization, call us at
1-800-964-6033.
We're certain we can fulfill your training needs, while making it fit in your
budget!



REGISTRATION


POWER QUERY 101: IMPORT, CLEAN & TRANSFORM YOUR BIG DATA

Live event begins Wednesday, June 29, 2022, 1PM (ET)

Live + On-Demand $199 + applicable taxes
more info
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the
speaker's presentation, real-time training with our expert instructor, and an
interactive question & answer period. Two to three business days after each live
training concludes, an email is sent to registrants which contains a link for
unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation
email. On-demand recordings also include a copy of the speaker's presentation
and the ability to submit your questions to the expert, for up to 7 days after
viewing.
3 Workshop
Bundle $300 + applicable taxes
more info
Take advantage of our three workshop bundle to enhance your learning beyond the
training you initially selected. Our workshop bundle allows you to select three
workshops (Live or On-Demand) at a discounted price.
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the
speaker's presentation, real-time training with our expert instructor, and an
interactive question & answer period. Two to three business days after each live
training concludes, an email is sent to registrants which contains a link for
unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation
email. On-demand recordings also include a copy of the speaker's presentation
and the ability to submit your questions to the expert, for up to 7 days after
viewing.
One-year subscription (All Access Membership) $699 + applicable taxes
more info
With this subscription, you will receive 1 year of unlimited access to our full
library of on-demand trainings as well as priority access to trainings that are
upcoming.
For the live training(s):
You will receive access to the live event(s) which includes a copy of the
speaker's presentation, real-time training with our expert instructor, and an
interactive question & answer period. Two to three business days after each live
training concludes, an email is sent to registrants which contains a link for
unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s):
You'll receive access to our full library of on-demand trainings along with the
speaker's presentation and handouts for each event.

If you can’t make it live, no worries! You’ll receive the recording and
materials after the event.

Add To Cart

Guaranteed to be Good

All training experiences include a 7-day 100% money-back guarantee.

Full-Team Pass

Simply share the invite link with your team so you can learn and grow together!

Yours Forever

The event recording and materials are yours to rewatch and share as you choose.


REGISTER NOW


LIVE EVENT

Wednesday, June 29, 2022

at 1PM (ET)

Live + On-Demand $199 + applicable taxes
3 Workshop Bundle $300 + applicable taxes
One-year subscription (All Access Membership) $699 + applicable taxes


If you can’t make it live, no worries! You’ll receive the recording and
materials after the event.

Add To Cart

Guaranteed to be Good

All training experiences include a 7-day 100% money-back guarantee.

Full-Team Pass

Simply share the invite link with your team so you can learn and grow together!

Yours Forever

The event recording and materials are yours to rewatch and share as you choose.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and
instructor-led training and free strategies and guides, we leave no Excel
mystery unsolved.

 * Home
 * Training
 * All-Access
 * Excel Foundations
 * Resources

CONNECT WITH US

Facebook
Linkedin

CONTACT

Learn Excel Now
questions@learnexcelnow.com
1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation
in the United States and other countries. All rights reserved.

Copyright © 2021 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2022 · News Pro Theme on Genesis Framework · WordPress · Log in




WELCOME BACK!

Enter your username and password below to log in

Username *

Password *



Remember me



Forget Your Username or Password?


RESET PASSWORD

Lost your password? Please enter your username or email address. You will
receive a link to create a new password via email.

Username or Email Address





Log In




All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering
Microsoft Office applications, with workshops, exercises and quick reference
eGuides. It's perfect for anyone that needs to brush up on certain skills or
even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You
will cover the most essential topics to develop a solid foundation of Excel or a
lifetime of mastery.

Saving...
Live Chat is Online 
Chatting
0
×
–

undefined



Chat Input Box

Chat
Powered by