Lookup Functions, Formula Tracing & Named Ranges in Excel
Duration : 90 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
This webinar effectively teaches lookup techniques and demonstrates practical examples, providing the perspective you need to understand the depth and scope of these functions.
Course Objectives:
To gain a practical “hands-on” understanding of how to manage and effectively use lookup functions, formula auditing and named ranges with confidence, knowledge and consistency.
When it comes to dynamically looking up and retrieving information from small or huge tables of data, Lookup functions can elevate you to a new world of accuracy, productivity and time savings 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.
Understand the power of Excel and get the most out of your software investment.
Course Outline
• Creating named ranges
• 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
• 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:
• Training Materials
• Live Q&A Session 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
You don't have to be proficient in the use of Excel to attend. If you can create basic worksheets and can copy and paste and apply basic formatting to cells, you’ll be able to follow along.
Please reach us at 1-888-844-8963 for any further assistance or if you wish to register
Get In Touch
Similar Trainings
Microsoft Excel – Quick Tips to Help You Be More Productive
LIVE : Scheduled on
22-September-2023 :01:00 PM EDT
|
Microsoft Excel - Filtering and Sorting
LIVE : Scheduled on
26-September-2023 :01:00 PM EDT
|
Mastering Excel’s Top 10 Functions
LIVE : Scheduled on
27-September-2023 :01:00 PM EDT
|
Powerful Business Writing – Writing Skills for Email, Proposals, and More!
LIVE : Scheduled on
27-September-2023 :01:00 PM EDT
|
The Magic of Microsoft's OneNote
LIVE : Scheduled on
28-September-2023 :01:00 PM EDT
|
