YoVDO

Top 10 Excel Formulas for Beginners - Essential Functions Tutorial

Offered By: Simon Sez IT via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Spreadsheets Courses VLOOKUP Courses MATCH function Courses COUNTIFS Courses XLOOKUP Courses

Course Description

Overview

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

Related Courses

Microsoft Excel - Excel from Beginner to Advanced
Udemy
Microsoft Excel Advanced Functions with INDEX and MATCH
Udemy
Learn Microsoft Excel from A-Z: Beginner To Expert Course
Udemy
Microsoft Excel - MS Excel Formulas & Functions in just 3hrs
Udemy
Excel上級者へのVLOOKUPマスター(INDEX+MATCH関数入り)手を動かして学ぶ忍者シリーズ「疾風の書」
Udemy