My Shopping Cart
There are no items in your shopping cart.

Lookup Function Essentials in Microsoft Excel 2010 To 2016 (IME761M)

Presented by: Roman Kondratiuk
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
60 minutes
Event Description
See the sneak peek before you buy!
1.0 CPE

Learn the Keys to Effectively Using Powerful VLOOKUP Functions in Excel

To work efficiently with lookup functions you must start with clear understanding, good habits, and application of correct structure and syntax. Gaining this knowledge is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including accounting, financial analysis, government and business administration.

This session by expert speaker Roman Kondratiuk will present useful VLOOKUP techniques with practical examples—providing you with the perspective you need to understand the depth and scope of these functions.

Understand the power of this exciting application and get the most out of your software investment. Attend this informative and value-packed 60-minute webinar with your team to boost efficiency and maximize your ‘return on investment’ in MS Office (2010-2016).

Session Highlights:

  • Understanding VLOOKUP
  • Examples of using VLOOKUP
  • Create a VLOOKUP table
  • Understand absolute references in VLOOKUP functions
  • VLOOKUP to find approximate match
  • VLOOKUP to find exact match
  • Creating named ranges for VLOOKUP
  • Link VLOOKUP to external data
  • Cleansing data for common VLOOKUP issues
  • Performing calculations with VLOOKUP
  • Use the Insert Function technique to create lookup functions
  • Using HLOOKUP
  • Formula Auditing with lookup functions

What’s Inside?

  • Comprehensive step-by-step Learner Guide
  • Exercise files
  • Demonstrations
  • Practice exercises
  • Productivity techniques, tips and shortcuts
  • Q&A session

Who should attend?

Any person or organization seeking to significantly boost efficiency, productivity, job satisfaction and effective use of their technology investment, including:

  • Business and financial analysts
  • Accountants
  • Data analysts
  • Office administrators
  • Managers and executives
  • Investment Bankers
  • Financial industry professionals
  • Payroll personnel
  • Business owners
About Our Speaker(s)

Roman Kondratiuk | Microsoft Management Training SpeakerRoman Kondratiuk
Roman has qualifications in Management, Accounting, Training and Assessment and has delivered training to over 15,000 students, consistently receiving outstanding evaluations from his clients who include multi-national corporations and large government organisations. With over 20 years of experience in Learning Develo... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Lookup Function Essentials in Microsoft Excel 2010 To 2016
    Presenter(s): Roman Kondratiuk

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team