If you were using Excel 2003 and now using Excel 2010 or more recent versions 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. In this video Gary Schwartz from http://www.jargonfreehelp.com gives a quick overview that will get you started. Gary has many more videos on Excel 2010 and creating more all the time so come back or visit his website.

You can create a new blank workbook in Excel or create one using one of the templates which are built in or readily available to download. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how.

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. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how.

Auto Fill is a great way to add data such as months, dates, or repetitive information. There are also some useful tricks like adding a series of dates and leaving out weekends. Related videos: Fill weekdays using AutoFill: https://youtu.be/sVAAWa5pPKw Fill months and years using AutoFill: This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 For more tutorials see my website http://www.jargonfreehelp.com I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

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. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how. Introduction to Functions: http://youtu.be/vkwQwWY_lKQ Introduction to Function on a Mac: http://youtu.be/B9mSM9B01o4 AutoSum: http://youtu.be/75Y_AsIavPs Autofill: http://youtu.be/2FTxjK60gKM

Totalling up figures in Excel is easy using AutoSum and even if you know how to use it there are some useful tricks here to. Gary Schwartz from http://www.jargonfreehelp.com show us how.

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 http://www.jargonfreehelp.com shows us 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 http://www.jargonfreehelp.com 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 http://www.jargonfreehelp.com shows you how to use the VLOOKUP function.