Microsoft Excel from medium to advanced
Wednesday, July 17, 2024
Microsoft Excel from medium to advanced, Learn to use Microsoft Excel and become faster, better and more confident
What you'll learn
- Nested IF, IF and logical functions
- INDEX(MATCH(...)
- VLOOKUP extended right for retrieving values from multiple columns
- nested XLOOKUP
- Pivot table in depth
- Charts in depth
- Error handling with IFERROR and AGGREGATE
- GOAL SEEK
- SOLVER
- Advanced Filters
- Nested lists for data validation