Welcome to the Microsoft Excel essentials module. This module covers some of the key features of Microsoft Excel through the simple example of using an Excel workbook to plan for a party. The idea is that you can then apply these same concepts to any workbooks of your own, including much larger ones.

If you have any questions about this module, please contact Library-UniSkills@curtin.edu.au

What you will learn

  • Some common ways to format your Excel workbook
  • How to make use of AutoFill, Flash Fill and Text to Columns to save you time when creating sequences, editing and reorganising data
  • How to sort and filter your data
  • How to write formulas and simple functions to perform calculations using your data
  • How to transpose data (i.e. swap data from rows to columns)
  • How to use the VLOOKUP function to search for one value and return another related value
  • How to organise and analyse data using PivotTables
  • How to display data in simple charts.


The information covered in this module is provided in the Microsoft Excel Essentials document below. You may choose to work through the entirety of this document to go through all the topics, or just do the parts that you are most interested in. Note that if you are working through the document from the beginning, including Section 2 (Formatting your workbook), you should download and use Party_Budget_Workbook_1. If you are just working through certain sections of the document, and/or do not want to format the workbook as detailed in Section 2, you should download and use Party_Budget_Workbook_2.