Course curriculum

    1. Course Introduction

    1. Section 1 introduction Basic spreadsheet operations

    2. 1.1 – Creating and saving workbooks

    3. 1.2 – Excel interface and navigation

    4. 1.3 – Excel ribbons and tabs

    5. 1.4 – Understanding cells and data types

    6. 1.5 – Entering and formatting data

    7. 1.6 – Managing rows and columns

    8. 1.7 – Cell formatting options

    9. 1.8 – Autofill and formatting for efficiency

    10. 1.9 – Using basic formulas

    11. Section 1 conclusion

    12. Section 1 quiz

    1. Section 2 introduction

    2. 2.1 – Sorting data in Excel

    3. 2.2 – Filtering data in Excel

    4. 2.3 – Advanced filtering techniques

    5. Section 2 conclusion

    6. Section 2 quiz

    1. Section 3 introduction – Data analysis and visualisation

    2. 3.1 – Sorting and filtering data

    3. 3.2 Intoduction to charts and graphs

    4. 3.3 – Creating and customising charts

    5. 3.4 – PivotTables and PivotCharts

    6. Section 3 conclusion

    7. Section 3 quiz

    1. Course conclusion

    2. Final quiz

About this course

  • 28 lessons
  • 1 hour of video content