This course covers the most important Microsoft Excel formulas and functions, such as 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.
Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress (Excel 2010)
4.6
★★★★★ 4.6/5
37,193 students