fbpx

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.

play-sharp-fill

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

play-sharp-fill

Part 3 – Number Formatting

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

play-sharp-fill

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

play-sharp-fill

Using simple minus

play-sharp-fill

Using simple multiplication

play-sharp-fill

Using simple division

play-sharp-fill

 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

play-sharp-fill

Maximum

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

play-sharp-fill

Minimum

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

play-sharp-fill

Average

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

play-sharp-fill

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

play-sharp-fill

CountA

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

play-sharp-fill

Exercise on Functions

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