course
Advanced Formulas in Excel - Short Course
If you want to master Excel, you need to know how formulas work together to accomplish complex tasks.
Popularity
Microsoft Excel remains one of the best tools for formula analysis. In this course, we focus on the specific formulas, and tools that Excel has to help conduct advanced formula calculations.
We start by looking at how to filter a dataset and sort using formulas. After that, we look at a number of tools and functions that can be used to perform calculations before finally moving onto the advanced skill of looking up information using XLOOKUP.
This course also includes practice exercises so you can immediately put into practice the new formula techniques that you have learnt.