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

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