Lookup Functions with Practical Business Case Study

Webinar Outline:

Sometimes you are struggling with Excel to get your required output and waste huge time every day those are just draining out. If you know the capability of Excel and can use those features, it will definitely help you to avail those times and you can think to generate new things.

This 02 hour will help you to learn a bunch of methods how to use Lookup & Reference functions to find and call the required data from a large dataset within a very short time

Key Contents those will be Covered:

1. LOOKUP function
2. VLOOKUP function
3. HLOOKUP function
4. INDEX function
5. MATCH function
6. OFFSET function
7. CHOOSE function
8. Combination of INDEX & MATCH
9. Reconciliation techniques using LOOKUPs
10. Magic tricks to use TRUE in VLOOKUP function
11. Error handling techniques
12. Common mistakes in VLOOKUP, HLOOKUP and MATCH functions
13. 2-way Lookups – Auto matching column index number
14. Lookup value matching multiple columns
15. Make your lookup values dynamic using the drop-down
16. Reverse Lookup
17. Data Lookup from multiple sheets
18. Risk of incomplete lookup execution
19. PRO tips of lookup functions
20. The carefulness of using lookup functions

Target Audience:

1. Regular Excel users
2. Regular business reporters
3. Students who want to sharpen their capability

Note:

• All participants will get a digital certificate from Thriving Skills Limited.
• Must set up your first name, last name, and display name from settings of your profile for your certificate.
• Don’t click on the “FINISH COURSE” button.
• If you click on the “FINISH COURSE” button then the webinar will be finished and a Certificate will be generated.

Course Instructor:

Nazmul Muneer

Courses of this Instructor:

1. Microsoft Excel – Advanced Level
2. Most Common Features of Excel for Professionals
3. Microsoft Excel – VBA & Macro
4. Microsoft Excel VBA & Macro Basics
5. Lookup Functions with Practical Business Case Study
6. Excel VBA & Macro
7. Microsoft Excel-Professional Tips & Tricks
8. Most Out of Excel
9. Advanced Automated Dashboard Reporting System Using Excel