-
VLOOKUP, INDEX, MATCH, SUMPRODUCT, INDIRECT, array formulas, shortcuts. From beginner to advanced!
What you'll learn:- VLOOKUP and HLOOKUP are used to create dynamic templates
- INDEX and MATCH examples and hints
- SUMPRODUCT can be used to slice and dice data
- Array formulas will help you make your formulas more powerful
- Most Excel users are unaware of the wildcard character in formulas
- Use the INDIRECT formula to get data from other worksheets
- Using the LEFT and RIGHT formulas, separate first and last names
- With dates, use the EOMonth and DATEDIF formulas
Everything you need to know in order to save time in Excel!
This course covers the most important Microsoft Excel formulas and functions, such as, VLOOKUP, INDEX + MATCH, SUMPRODUCT, array formulas, and using the wildcard character, among others.
WHAT WILL YOU LEARN?
VLOOKUP and HLOOKUP are used to create dynamic templates
INDEX and MATCH examples and hints
SUMPRODUCT can be used to slice and dice data
Array formulas will help you make your formulas more powerful
Most Excel users are unaware of the wildcard character in formulas
Use the INDIRECT formula to get data from other worksheets
Excel shortcuts and efficiency tips that I use daily
Using the LEFT and RIGHT formulas, separate first and last names
With dates, use the EOMonth and DATEDIF formulas
And there's more...
This course will instruct you on how to swiftly solve complex Excel problems. The examples are all business-related, so you can understand how to be more productive in the real world.
EXERCISE FILES AND Q&A
While watching the video lectures, you can download the exercise files that are included in each session. Put what you've learnt into practice using the exercise files.
As you improve your Excel skills, there is a Q&A part of the course where you may engage with me and ask any questions you have.
JOIN RIGHT NOW!
You will get the expertise and confidence to automate your Excel experience, saving you time and money, when you take this Excel Formulas course.
Overview
