GES – Module 01

Module 1 | Revision

If you are not familiar with Excel, start at Part 1 and work your way through the videos.

If you are familiar with Excel, complete the exercises so you know where you are at.

Part 1 – Navigating around Excel

A key part of working with Excel is learning how to get clever with moving, copying, and pasting cells.

View this video to see how to learn how to move around quickly.

Exercise

Open a blank spreadsheet in Excel and practise the following:

  1. Copying down a sequence e.g. days of the week, months, number sequence e.g. 1,2,3
  2. Move contents of cell from one location to another
  3. Copy contents from one location to another
  4. Don’t forget the undo key.

Part 2 – Text Formatting

Click on the video below to see how to format text in Excel

Part 3 – Number Formatting

Click on the video below to see how to format numbers in Excel

Part 4 – Creating Simple Formulas

In these videos I show you how to use simple plus (+), minus (-), multiply (*) and divide (/) . At the end of this section, there is a file for you to practise all of these techniques on it.

Using simple addition

Using simple minus

Using simple multiplication

Using simple division

 Here is the file for you to practise on. It also has the solutions tab so you can check your answers.

Part 5 – Using Basic Functions

In this part we are going to look at 6 basic functions in Excel:

  • Autosum
  • Maximum
  • Minimum
  • Average
  • Count
  • CountA

Autosum

In this video you will see how easy it is to add up large columns of numbers using Autosum

Maximum

Click on the video below to see how to use the maximum function

Minimum

Click on the video below to see how to use the minimum function

Average

Click on the video below to see how to use the average function

Count

The Count function only counts NUMBERS. If you want to count lists of names (for example) you should use the CountA function. Click on the video below to see how to use the count function

CountA

This function counts ANYTHING.Click on the video below to see how to use the counta function

Exercise on Functions

Click on this link to download a file you can practise on (complete with solutions)