Excel Basic to advanced
2- quick access tollbar20:26
3- formulabar – name box05:20
4-Status bar – Data Entry – Autofll36:03
5- Date – Time – comments12:18
6- Create simple formulas – Copy frmula – Relative refrence – Absolute R – Alt = Auto Sum26:05
7-Fonts-Align-Wrap-Merge23:30
8- Borders- Numbers18:00
9- Conditional formatting 1 – 215:38
10- Table-Insert-Delete-Hide-Unhide-Move-Copy-Replace-Freezing42:04
11- Split screen-Outlining-Locking cells and protecting28:54
12- Locking cells and protecting-Simple If & Nested23:24
13- Vlookup- Exact21:50
14- CountIf AveragIf23:36
15- Sorting15:15
16- Filter12:21
17- Subtotal10:36
18- Split Data -Flash fill – Remove Duplicates16:34
19- Format Data Pivot Table17:04
20- Vlookup – Approx – Countif – Sumif – Averageif13:11
1- menu system
