|
|
|
4min
|
|
|
|
6min
|
|
|
|
13min
|
|
04 Number Format - Text, Number, Currency, Accounting, Date, Time
|
|
9min
|
|
05 Number Format - Percentage, Fraction, Scientific
|
|
12min
|
|
06 Number Format - Digit Grouping, Custom Formats
|
|
8min
|
|
07 Conditional Formatting - Writing Data
|
|
12min
|
|
08 Conditional Formatting - Rules
|
|
10min
|
|
09 Conditional Formatting - Color Scales, Manage Rules, Styles
|
|
10min
|
|
10 Cells - Insert, Delete, Format
|
|
8min
|
|
11 Editing - Fill, Flash Fill, Clear, Sort n Filter
|
|
12min
|
|
12 Insert - Pivot Table Creation
|
|
12min
|
|
13 Pivot Table - Analysis
|
|
11min
|
|
14 Recommended Pivot Table
|
|
9min
|
|
15 Charts, Maps, Sparklines
|
|
13min
|
|
16 Insert - Slicer, Timeline, Header Footer, Symbols
|
|
7min
|
|
|
|
18min
|
|
18 Formulas Tab - Function, Name Manager
|
|
16min
|
|
19 Formula Auditing, Watch Window, Calculation
|
|
9min
|
|
20 Formulas - Sum, Average, Count, Max, Min
|
|
7min
|
|
21 Formulas - EMI Calculation (PV, Rate, NPER, PMT)
|
|
14min
|
|
22 Formulas - Financial (Future Value, PER, IPMT, PPMT)
|
|
11min
|
|
23 Formulas - Depriciation (DB)
|
|
8min
|
|
24 Formulas - Logical Functions (If, And, Or)
|
|
6min
|
|
25 Formulas - Logical Functions Combination (If, And, Or, Not)
|
|
11min
|
|
26 Formulas - Text Functions (Trim, Left, Right, Mid)
|
|
6min
|
|
27 Formulas - Text Function (Find)
|
|
7min
|
|
28 Formulas - Text Function (Replace)
|
|
3min
|
|
29 Formulas - Text Functions (Concatenate, Upper, Lower, Proper)
|
|
4min
|
|
30 Formulas - Date n Time (Now, Date, Days360)
|
|
11min
|
|
31 Formulas - Today, Day, Month, Year, Hour, Minute, Networdays, Networkdays.Intl
|
|
7min
|
|
32 Formulas - Lookup (V Lookup)
|
|
9min
|
|
33 Formulas - VLookup (Absolute Reference, Exact Match)
|
|
15min
|
|
34 Formulas - Vlookup (Approximate Match)
|
|
5min
|
|
35 Formulas - Lookup (HLookup)
|
|
5min
|
|
36 Formulas - Lookup (Match, Index)
|
|
9min
|
|
37 Formulas - ABS, Log, Power, Fact, Rand, Randbetween, Decimal, Dec2Hex, Base, Hex2Dec
|
|
13min
|
|
|
|
8min
|
|
39 Data - Get Data, Connections, Filter
|
|
10min
|
|
|
|
13min
|
|
41 Data - Text to Columns, Remove Duplicates
|
|
20min
|
|
|
|
6min
|
|
|
|
11min
|
|
44 Data - Whatif Analysis (Scenario Manager, Goal Seek)
|
|
11min
|
|
45 Data - Whatif Analysis (Data Table)
|
|
11min
|
|
|
|
4min
|
|
47 Data - Group, Ungroup, Subtotal
|
|
9min
|
|
48 Workbook Views, Zoom, Arrange, Freezepanes, Split, Switch Windows
|
|
9min
|
|
|
|
8min
|
|
50 Review - Proofing, Comments, Protect, Ink(Draw)
|
|
7min
|