What you’ll learn
- A deep understanding of the most useful and advanced functions of Excel
- Apply charting techniques that the pros use and be the charting boss of your office
- VLOOKUP, HLOOKUP, Macro, VBA
- Advanced Excel Functions, Formulas
- Use advanced Excel shortcuts to navigate quickly and efficiently
- Create and use complex Excel formulas and functions to analyze data and automate tasks
- Build and use pivot tables and charts to visualize and analyze large datasets
- Use Excel macros and VBA to automate repetitive tasks and create custom functions