Microsoft Excel Advanced

---

This Advanced Excel course is designed to take Excel users to the next level by illustrating advanced functions and formulas. Learn the most advanced formulas, functions, and types of financial analysis to be an Excel power user. It is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level. 

This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

It will increase your awareness of the most useful Excel features to work faster and smarter. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method.

1. Build a solid understanding of the basics of Microsoft Excel
2. Learn the most common Excel functions used in the office
3. Maintain large sets of Excel data in a list or table
4. Create dynamic reports by mastering one of the most popular tools, PivotTables
5. Harness the full power of Microsoft Excel by automating your day-to-day tasks through Macros and VBA
6. Unlock dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more