Valid From -05/ 01/2023 to 11/01/2023
Course Features
- Lectures 77
- Quizzes 0
- Duration 1 week
- Skill level All levels
- Language English
- Students 6283
- Certificate No
- Assessments Yes
Curriculum
- 14 Sections
- 77 Lessons
- 1 Week
Expand all sectionsCollapse all sections
- Unit -16
- Unit -211
- 2.1Main workbook download
- 2.2The three different types of references. Part 18 Minutes
- 2.3The three different types of references. Part 24 Minutes
- 2.4References exercise5 Minutes
- 2.5Formulas and functions. What’s the difference?3 Minutes
- 2.6How to write formulas10 Minutes
- 2.7Basic function variations you must know11 Minutes
- 2.8Basic function variations you must know. SumIF and AverageIF10 Minutes
- 2.9Functions exercise instructions2 Minutes
- 2.10Concatenate function4 Minutes
- 2.11The IF Function13 Minutes
- Unit -38
- 3.1Introduction to charts2 Minutes
- 3.2Inserting a chart7 Minutes
- 3.3Chart exercise instructions2 Minutes
- 3.4Charts solution video and more!6 Minutes
- 3.5Formatting data into a table8 Minutes
- 3.6Formatting data into a table. Part 26 Minutes
- 3.7The If/And/Or functions. Part 19 Minutes
- 3.8The If/And/Or functions. Part 25 Minutes
- Unit -411
- 4.1Introduction to printing2 Minutes
- 4.2Printing your first spreadsheet11 Minutes
- 4.3Printer settings2 Minutes
- 4.4Printing the second spreadsheet. Solution/exercise5 Minutes
- 4.5Building a Navigation paneI9 Minutes
- 4.6Vlookup10 Minutes
- 4.7Conditional formatting5 Minutes
- 4.8Subtotaling data. Part 110 Minutes
- 4.9Subtotaling data. Part 28 Minutes
- 4.10“Goals” Exercise instructions4 Minutes
- 4.11Goals solution video!12 Minutes
- Unit -54
- Unit -65
- Unit -72
- Unit -83
- Unit -93
- Unit -107
- 10.1Must know functions. Part 19 Minutes
- 10.2Must know functions. Part 29 Minutes
- 10.3Must know functions. Part 36 Minutes
- 10.4Splitting names with the ‘Find’, ‘Left’, ‘Right’ and ‘Len’ Function. Part 18 Minutes
- 10.5Splitting names with the ‘Find’, ‘Left’, ‘Right’ and ‘Len’ Function. Part 27 Minutes
- 10.6Missing Draw tab1 Minute
- 10.7Excels drawing tools and more6 Minutes
- Unit -115
- Unit -125
- Unit -133
- Unit -144
