Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

11 Excel Functions to Supercharge Your Skills in 2024

Simon Sez IT via YouTube

Start learning Write review
Unihackers Ad

Launch Your Cybersecurity Career in 6 Months

Learn More → Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course demonstrates Excel functions and workflows for comparing and filtering data, creating charts, and setting up cascading data validation. It also introduces macro recording and explains VBA.

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

Reviews

Start your review of 11 Excel Functions to Supercharge Your Skills in 2024

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.