Basic Excel Formulas Tutorial

By Ted French, About.com Guide

Basic Excel Formulas Tutorial Overview

This tutorial is part 1 of a basic Excel 2010 overview and covers the steps to creating a basic spreadsheet in Excel 2007 / 2010.

The topics for the tutorial, listed below, focus on entering data into a worksheet and using functions and formulas for calculations.

Part 2 of this tutorial covers basic formatting options in Excel 2010.

Tutorial Topics

• Entering the Tutorial Data


• Adding Rows to the Worksheet


• Using the TODAY Function to Add the Current Date


• Adding a Formula to Calculate Total Income


• Using a Range Name in Excel Formulas


• Adding the Employee Deductions Formula


• Adding the Net Salary Formula


• Copying Formulas with the Fill Handle

Previous

• Working with Data, Formulas, and Functions
• Data Entry in Excel
• Insert Rows to the Worksheet
• Using the TODAY Function to Add the Current Date
• Adding a Formula to Calculate Total Income
• Using a Named Range in Excel Formulas
• Adding the Employee Deductions Formula
• Adding the Net Salary Formula
• Copying Formulas with the Fill Handle

Next