# 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 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