The Story
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.
Description
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.