Excel LOOKUP Formulas - Capsule Training
Are you struggling and spending too much time on creating Excel Lookup Formulas? Or you don't have enough Lookup skills as your friends and colleagues have?
Then, I invite you to my Capsule Training on Excel Lookup Formulas where you are going to learn to work on Excel Lookups that you never did before.
Knowing Excel Lookup formulas will transform you to Excel Guru in your office and I'll do my best to make this painless, but you might need to get a capsule. 💊💊
Gone are the days that you were impressed with Excel's ability to return the result from a simple SUM function! By now you are probably ready to face the challenge of being able to get virtually any result from any data, and so you should be! In this training we will teach you how you can easily write those mega formulas that you have seen elsewhere.
As with all our training we are not satisfied with simply showing' advanced lookup formulas, we will also teach you how to understand them. By taking this approach you will be armed with the knowledge and confidence to tackle almost any lookup formula problem.
The topics that we are going to cover in this training are:
💡 Introduction to Excel Lookup
💡 Core functions - VLOOKUP, HLOOKUP, LOOKUP, INDEX, MATCH, CHOOSE, TEXTJOIN
💡 The Magical XLOOKUP
💡 The Dynamic FILTER Function
💡 Lookup All records
💡 Lookup nth records
💡 Case Sensitive Lookup
💡 Lookup from Image
💡 Lookup first integer
💡 Lookup text
💡 Index with multiple Range
💡 The magical MATCH-INDEX
💡 Reverse Lookup
💡 Integrating Lookup with Arrays
💡 Lookup from Multiple tables
💡 Lookup from Pivot Table
💡 VLOOKUP with OFFSET
💡 VLOOKUP with CHOOSE
💡 Using ROW and COLUMN function in LOOKUP
💡 The magical ADDRESS - INDIRECT
💡 VLOOKUP without Source Table
💡 Dealing with Dynamic Range in LOOKUP
💡 Fetching data based on multiple condition
💡 Fetching data based on dynamic range
💡 Lookup from Multiple Sheets
💡 Name Management in Lookup
💡 Working with Complex Lookup
By the end of the session, you will be more confident on Lookup Formulas. Capsule training is designed to give you in-depth knowledge of topics. As the name.. So its effect.
As it is a certification course, therefore participants will get the Course Completion Certificate (Soft Copy) after the training.
My brief profile:
An MCA Professional and a Microsoft Certified Microsoft Office Specialist working as a Chief Mentor and currently heading Future in Hands. I worked with the Top corporates like Mphasis, Motherson Group with 15+ years of industry exposure. I have received several Best Trainer Awards from corporates for Microsoft Office based workshops. I facilitated 98000+ professionals from 500+ companies like Taj Group, ICAI, British Council, BSI, NIIT, IndiaMart, MetLife, Mahindra and lots more from Executive level to Sr. Management. Learners says my sessions are like magic shows.
You can also refer to my LinkedIn profile.
So, if you are serious about being a master in Excel, then you should not miss this capsule training. Eventually, your BOSS will become your FAN.
In case of any queries, please contact me @ +918744007662.
See you at the training!