Excel Skill Boosting Session on LOOKUPs with XLOOKUP Function

Schedule:

29th April 2021, 9:45 pm – 10:45 pm (Dhaka)

Overview:

XLOOKUP is the one of the most powerful advanced functions in Excel. If you know the capability of XLOOKUP function, you will use this function avoiding many other Excel functions to ease your daily official works.

ThrivingSkills is offering a 1-hour Excel skill boosting session “LOOKUPs with XLOOKUP function”. In this session you will learn lots of practical business examples using XLOOKUP function that may be used as the replacement of VLOOKUP, HLOOKUP, INDEX & MATCH and other few functions

Content of the Training:

1. Concept of VLOOKUP, HLOOKUP, INDEX and MATCH function
2. Concept of XLOOKUP function
3. Data matching and calling right sided column value using XLOOKUP function
4. Calling left sided column value using XLOOKUP function
5. Handling Not Available in XLOOKUP function without IFERROR & IFNA
6. Using Approximate match mode in XLOOKUP function
7. Using Exact match mode in XLOOKUP function
8. Auto matching column index using XLOOKUP function
9. Auto matching row index using XLOOKUP function
10. Summarization techniques using XLOOKUP function
11. For duplicate matched value, pick last value or first value using XLOOKUP function
12. Questions & Answers – Any Excel Question

Notice:

• Here your certificate will be available after the live sessions.
• Videos of this training will not be available on our website after the live session.
• We will send an email with all information from “[email protected]”. Make sure this email is a safe sender to get all the information.
• This live training will conduct on Google Meet or Zoom.
• You will find the live training information in Lecture 1.1 Live Training Information, after 28th April 2021.
• Videos and Documents will be available here after the live sessions.

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
10. Microsoft Excel Advanced Data Processing and Reporting Techniques
11. Advanced Excel with Practical Business Case Studies