The menu has downgraded. It is at the bottom of this page.

Excel Tips

Many of the tips in Word work in Excel as well and have not been repeated here. To see the tips in word, click on the Word option in the column on the left

Here is a link to the Excel Hot Keys (ie: shortcuts)

File

If you only want to print part of a worksheet, select the part that you want to print and then go to File, Print Area and Set Print Area.

Edit

If you want to enter the months from January to December, type in January and then position your cursor over the right hand bottom corner of the active cell, your cursor should change into a cross. Dragging the cross down will automatically enter the rest of the months in the cells below.
To automatically insert a series of numbers, type in the first number and fill down to where the last number will go. Then click Edit, Select fill and choose the Series option. This allows you to choose from a number of of options.
To copy a formula down a column quickly, type the formula into the first cell of the column. Then place your cursor at the bottom right of the cell. When it turns into a black cross, double click (left mouse button). The formula will be copied down the column (sorry folks, this does not work for rows).
If you have formatted a Worksheet extensively but want to go back to plain text, click on Edit, then select Clear and choose the Formats option.
To get rid of an unwanted Worksheet, click on Edit and then Delete Worksheet.
If you want to move or copy a Worksheet into another book, click Edit and then choose the 'Move or Copy' option. This allows you to move Worksheets around or to copy them to another book.

Insert

To insert another Worksheet in the book you are working on Click on Insert and them Worksheet.
To highlight cells from the current cell to another cell, press F5, then type in the second cell 'coodinates' (eg C12) and then hit Shift and Enter.
To insert a graph (Excel calls graphs Charts), select the cells that you need to draw the graph and then click on the Chart icon at the top of your screen, alternatively, go to Insert and select Chart. Follow the prompts to produce your chart. (Hint: In the final step, tell Excel to place the chart as a new sheet instead of as an object in the Worksheet.)
If you need to find the average or standard deviation of a set of numbers, click on Insert and Function and then select the function that you want. Functions are listed in alphabetical order with a short description of what each function does.
To add a column of numbers automatically, place your cursor in a blank cell under the numbers that you want to add and click the Autosum icon twice (the Sigma symbol - an M on its side if you don't speak Greek!)

Format

If your text is longer than the cell and you want it to wrap so that it fits, select Format, then click on Cells and select the Align Tab. Finally click Wrap Text.
To add a border or colour to your Worksheet, select the relevant cells and click on Format, Cells and then click on the Border option to choose a border. For colour, click on the Patterns tab and choose from the wide range of available options.
To format numbers so that they show to two decimal places, select the cells concerned and use the Increase Decimal icon in the formatting toolbar (click on it until you have the required number of places).
To change the format of numbers in cells, select the relevant cells and Click Format, Cells and then select the Number tab and choose format that you want.
If you want to Format a Worksheet quickly, try using the Autoformat option. This has a good range of preset formats for tables. You can Autoformat your work and then format cells to adjust the colour and style to give your work a unique look.
If you want certain values to stand out in a Worksheet (for example, values between $1000 and $3000), highlight the Worksheet and click on Format and then choose the Conditional Format option which allows you to set conditions and if a number meets those conditions, it will be formatted differently to the other numbers (you choose the new format, be sure to pick a colour and style which differ from the colour and style of the other numbers in the Worksheet).
If your columns is too small for the data in it, you can change the column length by going up to the seam at the top of the Worksheet and double clicking with your mouse when your cursor changes into a two headed arrow. Another way to increase the column width is to take your cursor up to the seam and when the cursor changes to the two headed arrow, drag with the mouse to make the column wider.

Tools

To protect a sheet or workbook, click on Tools and choose the Protect option. Doing this will prevent other people from making changes to to the Worksheet.

Data

To sort data, click on any cell that contains data and click 'Data' and then 'Sort'. If you want your sort to be case sensitive, click on 'Options' and then tick the Case sensitive box. Lowercase entries appear first (if you are doing an ascending sort). If there are blank rows in the database, the 'Sort' command will not work.

Window

You are working on a large database and have client names in the first column. You want to be able to see the client names and check them against phone numbers which is in a column G. Highlight the first column, go to 'Window' and then select 'Freeze Pains', then when you scroll right at the bottom, all of the colunms will move except for the first one which will allow you to have Column G right next to Column A (which makes it easy to check that the names and phone numbers are correct).