Course curriculum
-
-
Course Introduction
-
-
-
Section 1 introduction Basic spreadsheet operations
-
1.1 – Creating and saving workbooks
-
1.2 – Excel interface and navigation
-
1.3 – Excel ribbons and tabs
-
1.4 – Understanding cells and data types
-
1.5 – Entering and formatting data
-
1.6 – Managing rows and columns
-
1.7 – Cell formatting options
-
1.8 – Autofill and formatting for efficiency
-
1.9 – Using basic formulas
-
Section 1 conclusion
-
Section 1 quiz
-
-
-
Section 2 introduction
-
2.1 – Sorting data in Excel
-
2.2 – Filtering data in Excel
-
2.3 – Advanced filtering techniques
-
Section 2 conclusion
-
Section 2 quiz
-
-
-
Section 3 introduction – Data analysis and visualisation
-
3.1 – Sorting and filtering data
-
3.2 Intoduction to charts and graphs
-
3.3 – Creating and customising charts
-
3.4 – PivotTables and PivotCharts
-
Section 3 conclusion
-
Section 3 quiz
-
-
-
Course conclusion
-
Final quiz
-

About this course
- 28 lessons
- 1 hour of video content