Lookup Functions, Formula Tracing and Named Ranges In Excel
-
Speaker : RAY EVANS
-
When : Tuesday, March 11, 2025
-
Time : 11 : 30 AM EST
-
Add To Calendar
Refer a Friend
Ray’s professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.
With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher.
Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
Having trained over 25,000 students and authored a wide range of complex reports, training, and procedural documentation, Ray has demonstrated strong ability in written communication, change management, and knowledge transfer.
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.
This webinar effectively teaches lookup techniques and demonstrates practical examples, providing the perspective you need to understand the depth and scope of these functions.
Learning 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.
Areas Covered
- Creating named ranges
- Understanding VLOOKUP
- Examples of using VLOOKUP
- Create a VLOOKUP table
- Understand absolute references in VLOOKUP functions
- VLOOKUP to find an approximate match
- VLOOKUP to find an 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
Course Level - Basic / Intermediate
Who Should Attend
Anyone seeking to significantly boost profits, competitive advantage, productivity, job satisfaction, and effective use of their technology.
Why Should You Attend
- Understand the latest powerful and most relevant MS Office functions available
- Work smarter, faster, and more effectively
- Boost profit, efficiency, and productivity
- Improve job satisfaction, team performance, and professionalism
- Gain a strong competitive advantage at the peer and business level
- Achieve more in less time with higher-quality results
- Strengthen your resume and justification for increased salary
-
$160.00
-
