Advanced Formulas in Excel

To truly master Excel, you need to know how formulas work together to accomplish complex tasks. In this course on advanced formulas in Excel, you will focus on a set of Excel formulas and tools that enable you to perform complex tasks and analysis. You will get started with filtering a dataset and sorting with formulas before proceeding onto more advanced concepts like creating multi-dependent drop-down lists, using two-way lookups, extracting text, using dynamic chart titles, and using XLOOKUP, among others.

By deepening your Excel skill set with these advanced techniques, you’re able to handle data in more meaningful ways. To get the most benefit from this course, you will need an intermediate knowledge of Excel.