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:
- Copying down a sequence e.g. days of the week, months, number sequence e.g. 1,2,3
- Move contents of cell from one location to another
- Copy contents from one location to another
- 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)