SUPER CONDITIONAL FORMATTING

Course Objective

VLOOKUP is one of the most traditional and widely used formulas in Excel for searching for information in other spreadsheets or reports. Mastering this function is essential for anyone working with data analysis and cross-referencing. In this course, students will learn in a practical way everything that really matters to use VLOOKUP safely and efficiently in their daily professional work.

The student will learn:

• How to correctly use the approximate VLOOKUP function, a simpler alternative to creating multiple nested IF functions.
• How to search for values using wildcard characters, expanding search possibilities.
• How to avoid common mistakes when building VLOOKUP and ensure reliable results.

Program content

1.     VLOOKUP – Concept
2.     Practical Exercise
3.     Concept of VLOOKUP (Approximate VLOOKUP)
4.     Exercise 1 – Approximate VLOOKUP
5.     Exercise 2 – Approximate VLOOKUP
6.     PROCV ERRORS
7.     VLOOKUP WITH WILDBOARD CHARACTERS
8.     RIGHT PROCV SEMI-AUTOMATIC
9.     VLOOKUP TABLE
10. AUTO VLOOKUP
11. Bonus – VLOOKUP vs. XLOOKUP
12. Bonus – VLOOKUP INDEX & MATCH
13. Bonus – VLOOKUP DOUBLE SEARCH
14. Bonus – VLOOKUP APPROXIMATE SEARCH
15. Bonus – VLOOKUP ERRORS

Supporting material for download | Super VLOOKUP

Methodology

Content presented with practical examples, guided exercises, and clear explanations to facilitate understanding and immediate application at work.

Instructor

Known as Edu do Excel, the instructor is a Microsoft-certified expert, entrepreneur, and professional with over 25 years of experience as an executive. Supply Chain in large multinational industries.
Throughout his career, he used Excel as a strategic tool for data analysis, report creation, and decision support, standing out for his ability to transform complex information into clear and objective analyses.
Currently, he dedicates himself to sharing this knowledge through his own teaching method, based on real-world challenges and situations, providing practical and applied learning relevant to everyday professional life.

Target Audience

Professionals who use Excel for data analysis and need to cross-reference information between spreadsheets, such as analysts, assistants, and professionals in administrative, financial, and operational areas.

General Recommendations

Basic knowledge of Excel and familiarity with spreadsheets is recommended.

About Instructors

Reviews