Advanced Excel: Mastering Lookups – with XLOOKUP and INDEX & MATCH. 1 pm Toronto, 2 pm Halifax, 10 am Vancouver, 11 am Calgary

Course No: DATW-06B

Format: HANDS-ON ONLINE WORKSHOP. This is a Live Workshop with an Instructor. Participants will work hands-on on practice data, and interact with an instructor online.

Duration: 2 Hours in 1 module of 2 hours. Participants will work on examples hands-on with the instructor

PRICE & BOOKING: Individual Registrations @ $90 per person. Discounts available for Organization or group booking. (mention group booking in the registration form alongside)

What will be covered

  • A very brief discussion on Vlookup – capabilities and limitations
  • Going beyond Vlookup with INDEX and MATCH
    • How to lookup data where the lookup column is not the first
    • How to do a two-variable lookup using Index and Match
  • Going beyond Vlookup with the newer XLOOKUP function
    • Working with Xlookup – understanding syntax and optional arguments
    • Nesting Xlookups to go beyond its apparent limitations for two-variable lookups
    • How to merge data from one table to another
    • Exploring the dynamic array nature of Xlookup
  • Special Lookup situations
    • How to do multiple parameter lookups when duplicates exist – use INDEX and MATCH or XLOOKUP
    • How to do Tier-based calculations with INDEX and MATCH
    • How to do Tier-based calculations with any sort order using XLOOKUP

What’s Included

  • Live instruction, interaction and course instruction during the workshop
  • One or more files filled with practice data and examples
  • One or more PDF files with course notes
  • Links to view the recording for one month after the workshop

Important Instructions:
• Office 365 will be used in the workshop demonstration. Participants are welcome to use older versions, but significant differences may exist and where possible the instructor will mention suitable workarounds. Microsoft Office Starter Edition will not be adequate.

  • 00

    days

  • 00

    hours

  • 00

    minutes

  • 00

    seconds

Date

May 31 2024

Time

1:00 pm - 3:00 pm

Cost

CAD$90.00

REGISTER


    Course Title Start Date

    Your Name (include lastname)Your Email
    City Province/State Country

    I would like to register for

    To register please also read these Terms and ConditionsI agree

    How your Privacy is protected

    • All webcams are disabled by default and only you can enable your webcam.
    • You have the choice to send questions or messages in private to the instructor, or publicly to all participants. If you ask a question privately the instructor will answer without identifying the person who asked the question
    • We don't use email addresses for marketing purposes. We use it only to communicate with you regarding your login credentials, course materials, and any other emails that you request.

    Free Video Resources on our YouTube Channel

    Free Excel Quick Reference Card

    Download this handy quick reference card of Keyboard Shortcuts and Commonly used functions

    Free Video Resources on our YouTube Channel

    May 2024
    No event found!
    Top