5-mixed ref | Excel Masters

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

5-mixed ref

Complete and Continue