1 - Course-Workbooks (135.01 KB)
1 - Introduction (24.64 MB)
2 - Udemy Platform (21.65 MB)
3 - Walk though VLOOKUP formula (23.6 MB)
75 - Introduction Text Functions (10.85 MB)
76 - CONCAT and (74.62 MB)
77 - LEFT RIGHT MID (71.34 MB)
78 - LEN (21.77 MB)
79 - SUBSITUTE (57.95 MB)
80 - UPPER and LOWER (17.14 MB)
81 - SEARCH and FIND (106.75 MB)
82 - Text Functions Exercise Overview (36.72 MB)
83 - Text Functions Exercise Solutions (81.42 MB)
84 - Date and Time Functions Introduction (12.44 MB)
85 - TODAY NOW (27.45 MB)
86 - YEARMONTHDAYHOURMINUTESECOND Functions (53.5 MB)
87 - DATE (64.69 MB)
88 - WEEKDAY WEEKNUM (52.84 MB)
89 - NETWORKDAYS NETWORKDAYSinlt (79.11 MB)
90 - WORKDAY WORKDAYinlt (50.88 MB)
91 - YEARFRAC (23.55 MB)
92 - Date and Time Functions Exercise Overview (26.41 MB)
93 - Date and Time Functions Exercise Solutions (94.25 MB)
100 - XLOOKUP Tips and Tricks (379.67 MB)
101 - INDIRECT (30.67 MB)
102 - COLUMN ROW (61.91 MB)
103 - ADDRESS (51.57 MB)
104 - OFFSET (155.69 MB)
105 - Lookup and Reference Formulas Exercise Overview (45.3 MB)
106 - Lookup and Reference Formulas Exercise Solutions (229.37 MB)
94 - Introduction Lookup and Reference Formulas (7.9 MB)
95 - VLOOKUP HLOOKUP (141.48 MB)
96 - MATCH (79.84 MB)
97 - INDEX (95.77 MB)
98 - MATCH and INDEX Formulas (98.02 MB)
99 - XLOOKUP (147.46 MB)
107 - Analysing Data Introduction (7.46 MB)
108 - What If Analysis Goal Seek (80.46 MB)
109 - What if Analysis Scenario Manager (101.2 MB)
110 - What if Analysis Data Table (143.92 MB)
111 - Pivot Tables (219.79 MB)
112 - Analysing Data Exercise Overview (10.16 MB)
113 - Analysing Data Exercise Solutions (41.18 MB)
114 - Introduction Charts (14 MB)
116 - Creating Charts and Selecting Data (121.15 MB)
117 - Adding Elements (56.35 MB)
118 - Quick Layouts and Chart Styles (75.11 MB)
119 - Formatting Charts (74.58 MB)
120 - Formatting Axis and Data Series (97.46 MB)
121 - Map Charts (40.91 MB)
122 - Pivot Charts (65.84 MB)
123 - Recommended Charts (44.91 MB)
124 - Ideas (102.91 MB)
125 - Charts Exercise Overview (6.96 MB)
126 - Charts Exercise Solution (17.22 MB)
135 - Dependent Drop Downs (37.8 MB)
10 - Moving Around (60.6 MB)
5 - Introduction Overview of the Excel Programme (12.31 MB)
6 - Workbooks and Sheets (63.83 MB)
7 - Cells and Ranges (95.12 MB)
8 - The Ribbon (180.54 MB)
9 - Excel Options (157.58 MB)
11 - Introduction to Quick Keys (24.9 MB)
12 - Common Quick Keys (73.59 MB)
13 - Function Keys (64.4 MB)
14 - Formatting and Other (82.35 MB)
15 - Introduction Formulas (14.52 MB)
16 - Entering Formulas (50.84 MB)
17 - Characters Used in Formulas (51.64 MB)
18 - SUM and COUNT (70.75 MB)
19 - IF Functions (104.3 MB)
20 - AND OR (97.81 MB)
21 - SUMIF and SUMIFS (126.82 MB)
22 - COUNTA COUNTBLANCK COUNTIF COUNTIFS (114.63 MB)
23 - AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS (193.37 MB)
24 - MIN MINA MINIFS MAX MAXA MAXIFS (95.14 MB)
25 - LARGE SMALL (104.97 MB)
26 - SUBTOTAL (126.53 MB)
27 - IFERROR (88.2 MB)
28 - ROUND ROUNDUP ROUNDDOWN MROUND (44.71 MB)
29 - Introduction to Formulas Exercise Overview (109.25 MB)
30 - Introduction to Formulas Exercise Solution (193.56 MB)
31 - Introduction Formatting (13.01 MB)
32 - Fonts Colours Fills (148.64 MB)
33 - Boarders (55.7 MB)
34 - Manipulation Columns and Rows (39.17 MB)
35 - Format Painter (13.84 MB)
36 - Conditional Formatting (168.18 MB)
37 - Illustrations (141.01 MB)
38 - Text Boxes and Word Art (80.21 MB)
39 - Links (204.14 MB)
40 - Notes and Comments (37.23 MB)
41 - Paste Special (217.37 MB)
42 - Protection (77.5 MB)
43 - Formatting Exercise Overview (26.71 MB)
44 - Formatting Exercise Solution (123.49 MB)
45 - Data Categories Introduction (9.53 MB)
46 - General Number Text and Others (50.41 MB)
47 - Date and Time (83.04 MB)
48 - Currency and Accounting (52.46 MB)
49 - Data Categories Exercise Overview (15.27 MB)
50 - Data Categories Exercise Solutions (22.6 MB)
51 - View and Printing Sheets Introduction (7.81 MB)
52 - Views (205.53 MB)
53 - Printing Page Setup (110.95 MB)
54 - Printing Scaling and Sheet Options (35.55 MB)
55 - Viewing and Printing Sheets Summary (7.78 MB)
56 - Introduction Organising Data (10.63 MB)
57 - Sorting (153.21 MB)
58 - Auto Filter (136.3 MB)
59 - Advanced Filter (168.42 MB)
60 - Grouping (296.47 MB)
61 - Data Validation (142.16 MB)
62 - Text to Columns (174.47 MB)
63 - Find and Select tools (205 MB)
64 - Tables (137.19 MB)
65 - Tables Formulas (97.54 MB)
66 - Organising Data Exercise Overview (41.34 MB)
67 - Organising Data Exercise Solutions (46.77 MB)
68 - Math Functions Introduction (11.14 MB)
69 - PI (16.62 MB)
70 - Deg Radions (12.04 MB)
71 - SIG COS TAN (7.2 MB)
72 - SQRT SQRTPI (10.9 MB)
73 - POWER (8.87 MB)
74 - CONVERT (20.69 MB)