Elevate Excel skills with a comprehensive tutorial covering 11 advanced functions. Learn to use SUMIFS for precise data analysis, compare lists using VLOOKUP, master XLOOKUP and XMATCH for efficient data retrieval, filter data with formulas, implement cascading data validations, utilize the CHOOSE and INDIRECT functions for flexible solutions, create waterfall charts and Venn diagrams, record macros for task automation, and explore VBA basics. Designed for data enthusiasts, analysts, and Excel users seeking to enhance their proficiency, this tutorial provides practical insights to supercharge spreadsheet capabilities and boost productivity in the coming year.
Overview
Syllabus
- Intro Simon Sez IT
- SUMIFS in Excel
- Compare Two Lists with VLOOKUP
- Using XLOOKUP and XMATCH
- Filter Data Using a Formula
- Multiple, Cascading Data Validation
- CHOOSE Function
- Using INDIRECT Function
- Waterfall Chart
- How to Create a Venn Diagram
- How to Record a Macro
- VBA Explained
Taught by
Simon Sez IT
