In the next section of this course we will be dealing with Microsoft Excel. Excel is a spreadsheet, but what does this mean?
Well it simply means that it has been specifically designed to work with numbers. Can you think of any instances where we may use a spreadsheet?
Financial (monetary) presentations, like budgets, profit and loss statements, teachers making use of excel to keep track of students marks, or keeping track of your own personal finances are some of the areas where a spreadsheet can be handy.
We can also use excel to draw graphs and tables that illustrate numerical information.
An Excel spreadsheet is made up of smaller sections called worksheets, a worksheet is a single page document, you could also have a number of worksheets that belong to a single document and these together will be referred to as a "Workbook‟.
So just as you could have a Word document that has multiple pages, you can also have multiple pages in a Spreadsheet.

The Ribbon
Excel's ribbon contains the following headings:
File, Home, Insert, Page layouts, Formulas, Data, Review, View, AddIns and Acrobat.
Each heading or tab as they will be referred to from now on, is divided into different groups.
These groups contain the features that fall under each specific tab(heading).
Home: Clipboard, Fonts, Alignment, Number, Styles, Cells, Editing.
Insert: Tables, Illustrations, Charts, Links, Text.
Page Layouts: Themes, Page Setup, Scale to Fit, Sheet Options, Arrange.
Formulas: Function Library, Defined Names, Formula Auditing, Calculation.
Data: Get External Data, Connections, Sort & Filter, Data Tools, Outline.
Review: Proofing, Comments, Changes.
View: Workbook Views, Show/Hide, Zoom, Window, Macros.


Adding up Columns
In order to make Excel add the columns for us we need to enter a ‘Formula’.
A formula is a set of mathematical instructions that Excel uses to perform calculations. Whenever we enter a formula it always starts with an = sign.
There are various ‘elements’ that make up an excel formula, it is easier for you to understand what you are asking the computer to do when you type in a formula rather than just trying to memorise it.
When we enter the = we are telling the computer we need it to find the answer. (= means find the answer) Next we need to tell the computer what we need the answer to, in other words:
if, we want to find the totals for a bunch of columns this is the procedure we would follow:
(Look at the image to see our example)
 We will start with the first column, column A
 We want our answer to appear below the information is column A so we click on A8 and enter an =
 A small drop down menu will appear, you can either scroll down the menu till you get to SUM or you can type in SUM
 We then open our brackets ( and move the cursor to A4 (That is where we want to start adding)
 Click on A4 we then type a .(full stop) this tells Excel that we want to add a string of numbers.
 Now move the cursor down and click on A7 and close your brackets ) press enter
 The total for the column will appear in cell A8

