Getting Started with Excel
Step 1 - Getting Started with Excel 2010
Getting Started with Excel 2010 provides free online training in Excel 2010. This set of tutorials includes step by step examples on how to create a basic spreadsheet in Excel 2010.
This first step in the tutorial covers entering the tutorial data into an Excel worksheet.
Step 2 - Add Rows to an Excel Worksheet
This step in the tutorial includes a step by step example of how to add rows to an Excel worksheet using the mouse.
Step 3 - Add the Current Date with the TODAY Function
This step in the tutorial covers using the TODAY function to add the current date in Excel. This tutorial includes a step by step example of using the TODAY function to add the current date in Excel.
Additional Information - Excel Formulas Overview
This tutorial gives an overview of using formulas in Excel - how they work and tips on the best way to create one. The tutorial also contains links to step by step tutorials on creating formulas in Excel.
Additional Information - Excel Mathematical Operators / Order of Operations
Mathematical operators tell Excel which operation, such as addition, subtraction, multiplication, or division, the formula is to perform. The order of operations tells Excel which of these operations it is to carry out first.
Step 4 - Adding the Total Income Formula
This step in the tutorial covers creating a basic formula in Excel. The tutorial includes a step by step example of creating a formula in Excel.
Additional Information - Excel Range Name Overview
Using a Range Name in a formula can make it easier to copy that formula to other cells in the worksheet. This tutorial gives an overview of using a range name in an Excel formula.
Step 5 - Adding a Range Name in Excel
This step in the tutorial covers adding a range name in Excel. The tutorial includes a step by step example of how to add a range name in Excel.
Step 6 - Using a Named Range in the Deductions Formula
This step in the tutorial covers using a named range in an Excel formula. The tutorial includes a step by step example of using a named range in an Excel formula.
Step 7 - Adding the Net Salary Formula
This step in the tutorial covers adding the Net Salary formula to the worksheet. The tutorial includes a step by step example of creating Net Salary formula in Excel.
Step 8 - Copying Formulas with the Fill Handle
This step in the tutorial covers using the Fill Handle to copy formulas to other areas of the worksheet. The tutorial includes a step by step example of using the Fill Handle to copy formulas in Excel.
Change Column Widths in Excel
Change Column Widths in Excel to display data
Merge and Center Data Across Cells in Excel
Excel's merge and center option allows you to merge a number of cells in a worksheet and center text across the merged cells. This step by step tutorial includes an example showing you how to merge cells and center text in Excel.
Changing Cell Alignment of Data in Excel
This tutorial covers changing the alignment of data in a cell in Excel. This tutorial includes a step by step example of how to change the alignment of data in a cell in Excel.
Excel Number Formats
This tutorial covers using number formats in Excel. This tutorial includes a step by step example of adding number formats to data in Excel.
Excel Formatting Styles
This tutorial covers using pre-set formatting styles in Excel. The tutorial includes a step by step example of using pre-set formatting styles in Excel.
Shading Alternate Rows with Conditional Formatting
Shading alternate rows in Excel using Conditional Formatting. This step by step tutorial includes a step by step example showing how to use conditional formatting for shading alternate rows in Excel.
Using the Fill Handle to Copy Formulas in Excel
This tutorial covers using the fill handle to copy formulas in Excel. This step by step tutorial includes a step by step example on using the fill handle to copy formulas in Excel.