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

Submitted URL: http://f.advanceyourcareers.com/ncey/3vodmjbV00mvrwwVpsw8V0s2x75Vnt0xV1gxchv/2/s/www.learnexcelnow.com/product/mastering-excel-l...
Effective URL: https://www.learnexcelnow.com/product/mastering-excel-lookup-functions-what-every-user-should-know/?utm_source=len_pc&utm_medi...
Submission: On April 27 via manual from IN — Scanned from DE

Form analysis 4 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="4e7a982a96"><input type="hidden" name="_wp_http_referer" value="/product/mastering-excel-lookup-functions-what-every-user-should-know/?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="a41b8ade84"><input type="hidden" name="_wp_http_referer" value="/product/mastering-excel-lookup-functions-what-every-user-should-know/?PCD">
</form>

POST

<form action="POST" class="woocommerce-pdf-catalog-email-form">
  <label for="woocommerce_pdf_catalog_email_to">To Email (split by comma for multiple emails)</label>
  <input name="woocommerce_pdf_catalog_email_to" class="woocommerce-pdf-catalog-email-to" type="text" placeholder="To Email (split by comma for multiple emails)" value="">
  <label for="woocommerce_pdf_catalog_email_text">Your message</label>
  <textarea name="woocommerce_pdf_catalog_email_text" class="woocommerce-pdf-catalog-email-text" id="" placeholder="Your message" cols="30" rows="10"></textarea>
  <label for="woocommerce_pdf_catalog_email_type">Select Catalog</label><select name="woocommerce_pdf_catalog_email_type" class="woocommerce-pdf-catalog-email-type">
    <option value="">Select Catalog</option>
    <option value="category">Category Catalog (PDF)</option>
    <option value="full">Complete Catalog (PDF)</option>
    <option value="sale">Sale Catalog (PDF)</option>
    <option value="cart">Cart Catalog (PDF)</option>
  </select>
  <div class="woocommerce-pdf-catalog-email-category-select" style="display: none;">
    <label for="woocommerce_pdf_catalog_category">Select Category</label>
    <select name="woocommerce_pdf_catalog_category" id="woocommerce_pdf_catalog_category" class="woocommerce-pdf-catalog-email-category">
      <option value="">Select Category</option>
      <option class="level-0" value="160">Office</option>
      <option class="level-1" value="161">&nbsp;&nbsp;&nbsp;OneDrive</option>
      <option class="level-1" value="162">&nbsp;&nbsp;&nbsp;Excel</option>
      <option class="level-1" value="163">&nbsp;&nbsp;&nbsp;Word</option>
      <option class="level-1" value="164">&nbsp;&nbsp;&nbsp;Outlook</option>
      <option class="level-1" value="165">&nbsp;&nbsp;&nbsp;Powerpoint</option>
      <option class="level-0" value="172">Self Paced</option>
      <option class="level-0" value="189">Custom</option>
      <option class="level-0" value="168">Sheets</option>
      <option class="level-0" value="186">Productivity</option>
    </select>
  </div>
  <button type="submit" class="woocommerce-pdf-catalog-email-send button btn btn-primary">Send PDF</button>
</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
   * Our Team
 * Training
   * Custom Training
     * Custom Virtual Group Training
     * Custom Onsite Group Training
     * Consulting Services
   * Excel
   * MS Office
   * Outlook
   * PowerPoint
   * Word
   * OneDrive
   * Google
 * All-Access
 * eLearning
   * Excel Foundations
   * Micro Courses
     * Simply Excel
     * Simply Excel Pt. II
 * Resources
   * Contact
   * FAQ
   * New User Onboarding
 * Login




MASTERING EXCEL LOOKUP FUNCTIONS: WHAT EVERY USER SHOULD KNOW

Share



SUMMARY



Ever gotten sick of manually linking data across Excel spreadsheets? Of course
you have - it takes a ton of time and it’s easy to make errors. What if you
could tell Excel what you were looking for and have it automatically find and
link the data for you? Well, you can and it’s a game changer!

VLOOKUP, HLOOKUP and XLOOKUP formulas give you that power and more - and once
you master them, there’s no turning back.

Join us for an interactive 90-minute, instructor-led training, where you’ll
learn the ins and outs of Excel’s powerful lookup functions. Using plenty of
examples, Excel expert Mitzi Katz will show you what they are, how to use them,
and what they can do for you.

After this workshop:



 * You’ll be ready to use Excel’s VLOOKUP, HLOOKUP and XLOOKUP formulas
 * You’ll understand when these lookups can - and should - be used
 * You’ll be able to confidently employ them to save time, work with data more
   efficiently and be more productive.
 * You’ll also walk away with great ideas on structuring your data that will
   help you going forward - even when lookups don’t come into play
 * & MUCH more!


PROGRAM HIGHLIGHTS

LOOKUP functions explained

 * What are lookup functions?
 * What can they do, why should I use them, and how can they help me?
 * What are the differences between VLOOKUP, HLOOKUP and XLOOKUP?
 * The importance of structuring - or restructuring - your data to get the most
   out of them
   

Mastering the VLOOKUP and HLOOKUP Functions

 * How to construct and use the VLOOKUP and HLOOKUP functions
 * Picking the right function for the right job
 * Unleashing the power of nested lookups
 * How to perform two-dimensional lookups
 * How exact match and approximate match differ - and why it matters
 * Error-proofing lookup formulas - avoiding the dreaded #NA
 * Watch you instructor create - and explain - many examples and variations

NEW: The XLOOKUP Function

 * What is XLOOKUP and which Excel versions use it?
 * What can XLOOKUP do that VLOOKUP and HLOOKUP can’t? (short answer: you’ll be
   amazed)
 * Using the XLOOKUP function - examples created and explained
 * Replacing VLOOKUP & HLOOKUP with XLOOKUP in your existing spreadsheets - it’s
   surprisingly easy!


ADDITIONAL TOOLS:

 * 15 minutes of assisted exercises to boost your performance right away
 * 30 minutes of interaction & live Q&A session!


ABOUT THE SPEAKER



Mitzi Gibson Katz has trained thousands of end users and developed curriculum
for over twenty-five years.



 * As a consultant, she specializes in the Microsoft Office suite including
   Excel, Access, PowerPoint, Word, Outlook and much more.
 * After teaching a variety of special education classes in Kansas, Montana, and
   Alaska for the early part of her career, Mitzi became interested in
   technology as the first personal computers were introduced to the market. She
   made the change in careers from public school education to private computer
   training and has been teaching students how to use software applications ever
   since.
 * Mitzi helps students understand Microsoft Applications by her passion: "It's
   the people part of the business that keeps me involved.


PROGRAM BENEFITS



After this interactive 90-minute, instructor-led training, you’ll have mastered
use of Excel’s VLOOKUP, HLOOKUP and XLOOKUP functions. You’ll know when and how
to use them and be able to confidently employ them to save time, work with data
more efficiently and be more productive. BONUS: You’ll also get great ideas on
structuring your data that will help you going forward.




PURCHASE THIS ON-DEMAND WORKSHOP


MASTERING EXCEL LOOKUP FUNCTIONS: WHAT EVERY USER SHOULD KNOW

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.
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.


PURCHASE THIS ON-DEMAND WEBINAR


MASTERING EXCEL LOOKUP FUNCTIONS: WHAT EVERY USER SHOULD KNOW

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


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-484-259-7664 or 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 © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · 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





To Email (split by comma for multiple emails) Your message Select CatalogSelect
CatalogCategory Catalog (PDF)Complete Catalog (PDF)Sale Catalog (PDF)Cart
Catalog (PDF)
Select Category Select Category Office    OneDrive    Excel    Word    Outlook
   Powerpoint Self Paced Custom Sheets Productivity
Send PDF
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