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

YouTube

Top 10 Excel Formulas for Beginners - Essential Functions Tutorial

Simon Sez IT via YouTube

Start learning Write review
Corporate Finance Institute Ad

Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them

Learn More → Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More →

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Learn the top 10 essential Excel formulas for beginners in this comprehensive 1.5-hour tutorial. Master VLOOKUP, MATCH, XLOOKUP, COUNTIF, IF statements, and more through step-by-step explanations and practical examples. Navigate easily using provided timestamps to focus on specific topics or skip familiar content. Explore advanced concepts like nested IF statements, IFS functions, and date/time manipulations. Gain valuable skills in data analysis, conditional formatting, and randomization techniques to enhance your Excel proficiency and boost productivity.

Syllabus

- VLOOKUP
- MATCH Function
- XLOOKUP and XMATCH Functions
- Count Cells with Text COUNTIF
- IF, Nested IF, IFS
- Conditional IF Functions
- Nested IF
- IFS Function
- Conditional IF Functions
- COUNTBLANK Function
- LET Function
- Date and Time Functions
- Randomized List and RAND Function

Taught by

Simon Sez IT

Reviews

Start your review of Top 10 Excel Formulas for Beginners - Essential Functions Tutorial

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.