1. Computing

Basic Excel 2003 Spreadsheet Tutorial

By , About.com Guide

4 of 9

Adding the Date and a Range Name
Adding a Named Range

Adding a Named Range

© Ted French

Adding the Date in Excel

It is normal to add the date to a spreadsheet. Built into Excel 2003 are a number of DATE functions that can be used to do this. In this tutorial we will use the TODAY function.

Tutorial Steps

  1. Click on cell C4.

  2. Type = TODAY ( )

  3. Press the ENTER key on the keyboard.

  4. The current date should appear in cell C4

Adding a Named Range

A named range is used to simplify entering cell references into a formula.

In addition, when the formula is copied, the cell reference doesn't change

Tutorial Steps

  1. Select cell C6 in the spreadsheet.

  2. Click on the Name Box.

  3. Type "rate" (no quotes) in the Name Box.

  4. Cell C6 now has the name of "rate". We will use the name to simplify creating formulas in the next step.

©2013 About.com. All rights reserved.