Lookup Function Essentials in Microsoft Excel
Duration : 60 Minutes
Ray Evans,
Performing key roles in a the private and public sectors and also as a Board Director, Ray's proven experience includes management, business analysis, audit, report writing, system documentation, website design and video production.
Ray has qualifications in Frontline Management, Accounting, Training and Assessment an Read more
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.
Course Objectives:
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).
Course Outline:
• 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 You Get:
• Comprehensive step-by-step Learner Guide
• Exercise file(s)
• Demonstrations
• Productivity techniques, tips and shortcuts
• Training Reference Materials
• Live Q&A with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
• Accountants
• CPAs
• CFOs
• Financial Consultants
• Controllers
• Banking
• Finance
• Insurance
• Education
• Telecom
• IT
• Marketing
• Sales
• Investments
• Pharmaceutical
• Medical Devices
• FDA
• Aviation
• Energy
• Retail
• Human Resource
• Logistics & Supply Chain
• Accounts
• Audit
Any Excel user who needs to go beyond the basics of using formulas or simply wants to become more comfortable and productive in using Excel formulas and functions
Any Excel user who deals with large lists needs these tools and techniques to effectively manage the lists and become more productive. Nearly all Excel users, except for those just getting started, are candidates for this webinar.
Please reach us at 1-888-844-8963 for any further assistance or if you wish to register
100% MONEY BACK GUARANTEED
Refund / Cancellation policyGet In Touch
Similar Trainings
Microsoft Excel - A Beginner's Guide to Formulas
LIVE : Scheduled on
10-January-2025 :01:00 PM EST
|
3 Hour Microsoft Excel Automation Boot Camp
LIVE : Scheduled on
13-January-2025 :01:00 PM EST
|
Excel Lookup Functions Xlookup & Error Suppression
LIVE : Scheduled on
14-January-2025 :03:00 PM EST
|
Data-Driven Decision Making
LIVE : Scheduled on
15-January-2025 :01:00 PM EST
|
Automate Excel Spreadsheets with Basic Macros
LIVE : Scheduled on
17-January-2025 :01:00 PM EST
|
