Course: Microsoft Excel Advanced Formulas

If you want to master Excel, you need to know how formulas work together to accomplish complex tasks. In thiscourse, you will focus on a set of Excel formulas, functions, and tools that enable you to perform complex tasks and analysis. Start by looking at how to filter a dataset and sort using formulas. After that, look at how to create multi-dependent drop-down lists, 2-way lookups, text extraction, dynamic chart titles and so much more! Finish the course by looking at how to use XLOOKUP.