Section outline

    • Session 1 Excel Foundations


      This session is designed to focus on the most essential Excel features, and it is ideal for beginners. You will become familiar with entering, viewing, and managing data and formatting worksheets. Examples of commands we are going to explore include format cells, sort/filter, hide/unhide and freeze panes. 

      Moreover, we are going to build skills in constructing accurate spreadsheets by using keyboard shortcuts.


    • Students must
      Mark as done



      Watch this video which introduces the Microsoft Excel software and some useful terminology. 



    • Topic 1: Excel Foundations Video Presentations Book
      Students must
      Mark as done

      Now view the complete set of Excel Foundations video presentations which take you through formatting cells, organising data, viewing data, keyboard short cuts and  Excel applications.  

    • Topic 1: Excel Short Cuts File
      Students must
      Mark as done

      View and download this PDF guide which provides a list of Excel Shortcuts which you should find useful for this topic and the rest of the course.

      438.1 KB
    • Students must
      Mark as done

      Topic 1 Review: Excel Foundations

      Now you have worked through the Excel Foundations Topic, you should now be able to:

      • Understand the different components of an Excel worksheet

      • Format cells

      • Sort data using the function Sort 

      • Filter data using the function Filter 

      • Improve the visualisation of the data in the spreadsheet by using appropriate commands

      • Use keyboard shortcuts