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 Excel Formulas and Functions
0-Introduction
Course Introduction (1:41)
1- Creating Formulas and Functions
Exercise files- Download it first
1-create formula and functions (4:26)
2-copy formula (2:42)
3-absolute ref (4:38)
4-autosum (2:22)
5-mixed ref (5:14)
2-Tips Shortcut
Exercise files- Download it first
1-3d formula (3:23)
2-find a fomula (1:32)
3-convert formula to value (5:51)
4-update value (2:40)
5-range name (2:19)
3-Statical Functions
Exercise files- Download it first
1-median - mode (2:06)
2-rank (3:05)
3-large small (3:10)
4-countblank (1:58)
5-count - counta (3:09)
4-Math Functions
Exercise files- Download it first
1-rounding (9:39)
2-mround (4:32)
3-mod (3:06)
4-convert (2:53)
5-aggregate (3:19)
5-Count Family
Exercise files- Download it first
1-countif (6:30)
2-countifs (5:26)
3-maxifs-minifs (2:04)
4-subtotal (3:08)
6-If Function
Exercise files- Download it first
1-sample if (6:09)
2-nested if (6:10)
3-ifs (2:16)
4-compound if (4:48)
7-Lookup Functions
Exercise files- Download it first
1-vlookup exact match (6:55)
2-vlookup approximat match - hlookup (4:52)
3-Lookup functions (2:50)
4-match (3:19)
5-index (3:38)
6-index-match (7:31)
7-index-match (7:33)
8-Text Functions
Exercise files- Download it first
1- find - mid (6:17)
2-left right (3:50)
3-trim (2:16)
4-CONCATENATE (4:47)
5-proper (1:58)
6-REPLACE - SUBSTITTUTE (6:04)
9-Dates & Times
Exercise files- Download it first
1-dates and time (2:35)
2-DATE YEAR MONTH DAY MINUTE (2:29)
3-today - now (4:15)
4-weekday (1:19)
5-networkdays (2:49)
6-workday (1:26)
7-datedif (3:06)
8-time currency (1:35)
10-Refrencess Functions
Exercise files- Download it first
1-offset (9:56)
2-indirect (4:23)
3-indirect - dependent drop down list (4:52)
11-New array function excel 2021-365
Exercise files- Download it first
1-summary of updates (2:07)
2-formula spill (4:10)
3-filter (7:44)
4-sort - sortby (5:31)
5-unique (5:14)
6-combine formulas (5:47)
7-xlookup (13:43)
3-today - now
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock