1 - Course Introduction (40.17 MB)
2 - What is Data DefinationCategoriesTypesQualities (10.29 MB)
3 - Data Types in Excel (2.55 MB)
4 - AutoFilling (60.17 MB)
5 - Dataset Navigation (45.62 MB)
6 - How to find a freepublic Dataset (26.42 MB)
10 - Proper UPPER and lower Functions (70.56 MB)
11 - Nested Functions (26.27 MB)
12 - Data Type Formating (47.23 MB)
13 - Currency Data Type Formating (32.63 MB)
14 - Filter and Sort Features (98.64 MB)
15 - Text Concatenation (22.28 MB)
16 - Text to Column (29.93 MB)
17 - Flash Filling (14.11 MB)
18 - Substitute Function (30.03 MB)
19 - Formating data as a Table (98.96 MB)
7 - 5 Traits of Quality Data (4.83 MB)
8 - Identifying Duplicates and Blanks (53.99 MB)
9 - TRIM Function (86.69 MB)
20 - Mean Median and Mode (20.35 MB)
21 - Name Labeling (9.39 MB)
22 - Sum Function (24.44 MB)
23 - SumIF Function (16.53 MB)
24 - Operators (15.29 MB)
25 - Minimum and Maximum Value Functions (17.44 MB)
26 - Count Functions (36.23 MB)
27 - IF Nested IF and IFS (107.01 MB)
28 - VLOOKUP Function (43.92 MB)
29 - HLOOKUP Function (28.27 MB)
30 - Introduction to PivotTables (2.83 MB)
31 - How to create a PivotTable (69.14 MB)
32 - How to format data in a PivotTable (18.15 MB)
33 - How to apply calculations on data in a PivotTable (31.96 MB)
34 - How to Sort data in a PivotTable (19.95 MB)
35 - Recommended PivotTables (26.97 MB)
36 - Slicers (44.35 MB)
37 - Bar Charts (5.26 MB)
38 - Column Charts (5.63 MB)
39 - Line Charts and Combo Charts (3.94 MB)
40 - Pie and Doughnut Chart (3.36 MB)
41 - How to Create a PivotChart (35.04 MB)
42 - How to Apply A Slicer to a PivotChart (14.73 MB)
43 - How to manually Style your PivotChart (14.51 MB)
44 - Step One Prepare data for analysis (72.23 MB)
45 - Step Two Data Extraction and Analysis (70.52 MB)
46 - Step Three Dashboard and Data Visualization (115.62 MB)