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)
Teach online with
4-update value
Complete and Continue