It is important to save your data regularly when using Excel, you don't want to lose all that hard work. Here is how you can save it and also set up Autorecover, which is like Autosave where it saves a copy should anything go wrong.
Excel is great for working with numbers which means doing calculations. Calculations in Excel are called formulas and here is an introduction to doing some simple calculations that includes addition, subtraction, multiplication and division. You will also see how to use brackets in formulas and Autosum.
Have you ever seen the $ signs used in an Excel formula and wondering what they are for? Perhaps you have copied a formula and a cell reference has changed and you didn't want it to. What you want to know about is absolute and mixed referencing and here Gary Schwartz from Jargon Free Help explains what it is about.
If you need to do a calculation and you want to use a percentage then it is easier than you might think. In this short tutorial by Gary Schwartz from Jargon Free Help you will see how to work out the percentage of a value.
By naming cells and ranges in Excel you can make formulas and functions easier to read and also provides a great way to navigate around your worksheet and workbook. It really does speed up the way you get around from one part of the sheet to another.
It is also useful when using Scenarios.
In this video Gary Schwartz from Jargon Free Help shows you how to use the VLOOKUP function.
If you were using Excel 2003 and now using Excel 2010 you might be a bit puzzled about where everything is. Microsoft went and moved everything around in Excel 2007 and have kept it that way in Excel 2010 but have fixed a few things and added new features.