YoVDO

11 Excel Functions to Supercharge Your Skills in 2024

Offered By: Simon Sez IT via YouTube

Tags

Microsoft Excel Courses Data Filtering Courses Data Validation Courses VLOOKUP Courses XLOOKUP Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.

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

Related Courses

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera