How to Use Microsoft Excel 07

If you have been using previous versions of Microsoft Excel, such as 2003, XP or 2000, making the transition to Microsoft Excel 2007 can be difficult. The familiar toolbars of past versions are gone. In their place is something called "The Ribbon." You might not even be able to find the "Help" menu. Before you throw in the towel and go on a hunt for Excel 2003, though, become more familiar with the newest version of this Microsoft Office application.

Things You'll Need

• Microsoft Excel 2007

Instructions

1. 

   Make a chart. To create a chart in Excel 2007, go to the "Insert" tab of the ribbon. Select a type of chart from the chart group of the tab, or click the "Chart Dialog Box Launcher" in the lower right corner of the chart group.

2. 

   Sort data. To sort cells in columns based on criteria you determine, go to the "Data" tab of the ribbon. Click "Sort" in the "Sort & Filter" group.

3. 

   Set up the layout of the spreadsheet page. Go to the "Page Layout" tab of the ribbon. In the "Page Setup" group, you can set margins, change the page orientation and more.

4. 

   Insert a header or footer. Go to the "Insert" tab of the ribbon. Select "Header & Footer" from the "Text" group. Choose to work in either the header or the footer in the dialog box.

5. 

   Insert functions. Go to the "Formulas" tab of the ribbon. Click the "Insert Function" button to open the "Insert Function" dialog box, or select a function from the "Function Library" group.

Tips & Warnings

• If you cannot find a command in the ribbon, add it to the Quick Access Toolbar. Click the drop down arrow at the end of the Quick Access Toolbar and click on "Customize Quick Access Toolbar." Select the command from the list, click "Add" and then "OK."

Resources

• Excel 2003-2007 Interactive Guide