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.

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/simple_navigation.mp4′]

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

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/basic_formatting_text.mp4′]

Part 3 – Number Formatting

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

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/simple_number_formatting.mp4′]

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

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/simple_addition.mp4′]

Using simple minus

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/16_using_minus.m4v’]

Using simple multiplication

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/15_multiplication.m4v’]

Using simple division

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/simple_divide.mp4′]

 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

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/01autosumdemo.m4v’]

Maximum

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

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/04_max_demo.m4v’]

Minimum

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

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/05_min_demo.m4v’]

Average

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

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/02_average_demo.m4v’]

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

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/count_function.mp4′]

CountA

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

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/06counta_demo.m4v’]

Exercise on Functions

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