This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Mastering Formulas And Functions in Excel
Welcome!
INTRODUCTION!! (1:18)
Basics
Formulas and Function 101 (3:03)
Two more ways to create Formulas (1:01)
Operators (5:20)
Copy Formulas and Values (5:51)
Absolute Referencing (2:06)
Named Range (1:15)
Getting Help in Excel (1:01)
QUIZ TIME
Basic Statistical and Maths Function
Summarizing Data (3:49)
Auto Sum & Quick Analysis Tool (2:09)
Rank function (1:35)
Large and Small functions (1:48)
Countblank (1:38)
Count and Counta (2:29)
Rand and Randbetween function (3:38)
Round and Roundup (2:35)
MROUND (3:07)
Mod Function (4:28)
Aggregate fn (3:35)
Welcome to the world of IF Functions
Nested if function (2:23)
If function (2:46)
AND OR operator (4:30)
Ifs function (1:45)
Summarize data using Conditional Function
Countif, Sumif and Averageif (5:53)
Countifs, Sumifs and Averageifs (6:36)
Maxifs and Minifs (2:35)
Subtotal (3:47)
Lookup and Reference Functions
Choose and Switch function (4:43)
VLOOKUP (3:57)
Match and Index function (3:56)
Two way lookup (3:10)
XLOOKUP (2:02)
Offset function (4:38)
DATE AND TIME FUNCTIONS
Date Time function (2:57)
Understanding date and time functions (5:38)
Today, now and Datevalue (2:15)
Workday and Networkday function (2:25)
Datedif dunction (2:38)
EDATE and EOMONTH (1:23)
TEXT FUNCTIONS
Left, Right and Flash fill (3:25)
Find, Search and Mid function (2:37)
Merge data (3:22)
Text formatting (3:14)
Replace and Substitute (4:29)
Textafter, Textbefore and Textsplit (1:56)
Conclusion
What Next!! (1:01)
Countifs, Sumifs and Averageifs
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock