Basic Excel 2007 Spreadsheet Tutorial

Adding the Date and a Range Name

Using a Date Function in Excel 20007

© Ted French

Adding the Date in Excel 2007

Note: For help on these steps, refer to the image above.

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

1. Click on cell C4.
   
   
2. Click on the Formulas tab.
   
   
3. Click on the Date & Time option on the ribbon to open the list of date functions.
   
   
4. Click on the Today function.
   
   
5. Click OK on the Functions Arguments dialog box.
   
   
6. Today's date should be added to the spreadsheet

Adding a Range Name in Excel 2007

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.

Return to Index page

Index: Basic Excel 2007 Spreadsheet Tutorial

1. Excel 2007 Step by Step Tutorial
2. Entering Data into Excel 2007
3. Widening Columns in Excel 2007
4. Adding the Date and a Range Name
5. Adding Formulas in Excel 2007
6. Excel 2007 Formatting - Applying Styles
7. Excel 2007 Formatting - Changing Data Alignment
8. Excel 2007 Formatting - Number Formatting
9. Excel 2007 Formatting - Changing Font Color