Microsoft Excel from medium to advanced
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
Post a Comment for "Microsoft Excel from medium to advanced"