Excel Tips for both Windows and Mac

How to sort your data on more than one level in Excel 2010 and Excel 2007.

In this short video tip, find out how to create a basic chart in Excel 2010 and in Excel 2007. You will find out about a Column Chart and a Pie Chart.

You can use Conditional Formatting to show up data that matches a certain criteria. So if you would like to format all cells with a value greater than £10 you can get Excel to change the font and shading.

Find out how Auto Fill can help you to create a series, copy data and generally save you hours.

Find out how to create a simple Sum formual using the Autosum icon and also how to get Excel to Average a column of numbers.

Find out how to Freeze the top row of your spreadsheet and the first column as well.

Have you ever typed up a list of for example, first name and then surname and then thought that it would be useful to have a column where they are combined? Well that is what Concatenate does.

Learn how to build a formula from scratch, you will be able to create a subtraction, an addition a multiplication or a division.

You are filling in a long list of entries and you find that you are repeating the same thing over and over. It would be handy to have a drop down or pick-list to select from. Here is how to get an instant drop down list by using the Right Mouse button.

You can set Excel up to allow you or someone else to enter data that meets criteria that you set. For example, on an order form, the quantity to be ordered may be in a particular range. Say between 10 and 20 units. You can set this up so that if the person entering the data puts a number in that is below 10 or above 20

Get Excel to show you where the errors that are shown in your Spread Sheet come from. This will work in both Excel 2007 and Excel 2010.

Learn how to create a work sheet to summarise content from other worksheets.

Find out how to add borders to cells in Excel 2007 and Excel 2010

How to create a chart in Excel 2008. We look at simple Column Charts and Pie Charts.

Use Conditional Formatting to make data stand out if it matches your criteria - if profit is more than £10 then make the font and shading change colour.

Learn how to fix a cell reference in a formula so that the formula adjusts correctly when you copy it using Auto Fill.

Find out how to use Auto Fill in Excel to copy data, create a series and generally to save you hours.

Find out how to create a simple Sum formula using the Autosum icon and also how to get Excel to Average a column of numbers.

Find out how to freeze the top row and the first column of a spreadsheet so that you can scroll through and your headings stay put.

Create a chart in seconds with a brilliant keyboard shortcut and find out how to add a title.

Find out how to get Excel 2008 to add up a list of numbers based on a criteria. For example I have a list of CDs with a column for Genre and a column for Number and I want Excel to add up each genre and count how many there are.

Have you ever typed up a list of for example, first name and then surname and then thought that it would be useful to have a column where they are combined? Well that is what Concatenate does

Learn how to build a formula from scratch. Add subtract multilply or divide.

You are filling in a long list of entries and you find that you are repeating the same thing over and over. It would be handy to have a drop down or pick-list to select from. Here is how to get an instant drop down list by using the Right Mouse button.

.You can set Excel up to allow you or someone else to enter data that meets criteria that you set. For example, on an order form, the quantity to be ordered may be in a particular range. Say between 10 and 20 units. You can set this up so that if the person entering the data puts a number in that is below 10 or above 20

Get Excel 2008 to show you where the errors in your spread sheet come from.

Learn how to create a worksheet to summarise the contents of other worksheets in the workbook.

Find out how to add borders to your Excel 2008 spread sheet.