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-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Thu, July 28, 2016
Event Description
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 Office Training ExpertRoman Kondratiuk
Since 1995 Roman Kondratiuk has delivered expert training and consulting, through to advanced levels, to over 10,000 end-users in a wide range of Microsoft applications including Excel, PowerPoint, Access, Project, Word, Outlook, Visio and Publisher. Roman’s professional and relaxed style reflects his thorough un... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Lookup Function Essentials in Microsoft Excel 2010 To 2016
    Presenter(s): Roman Kondratiuk Protection Status