Excel 2007 Tutorial

This excellent Excel 2007 Tutorial at Brown University discusses and teaches Excel 2007 in detail. Excel is a spreadsheet application from Microsoft’s Office Suite and is the most widely used spreadsheet application in the world. This Excel tutorial explains the new features of Microsoft Office 2007, and how it compares with its predecessors. The various definitions used in Excel, cell navigation and data manipulation which include editing, moving, copying and the Autofill feature in Excel is discussed in detail. For more advanced Excel users, Excel formulas, Natural Language Labels, Pivot table and Excel sheet printing is explained. As a footnote, a section on troubleshooting in Excel is also presented.


New In Office 2007:
This section talks about the new features added in the Office 2007.

Definitions In Excel 2007:
This section list out and define the different words used in Excel 2007.

Navigating Cells In Excel 2007:
This section talks about the different ways of navigations used in cell.

Data In Excel 2007:
 - Editing, Moving, and Copying Data
 - Inserting, Deleting, and Clearing Data
 - Using Autofill
 - Using Autofill with a text series
 - Using Autofill with a numeric series
 - Controlling Your View of the Data
 - Sorting and Filtering Data

Excel 2007 Formulas:
 - Autofill with Formulas
 - Cell References
 - AutoSum
 - Functions
 - The Function Wizard
 - AutoCalculate

Using Natural Language Labels In Excel 2007:
This section talks about the labelling feature in Excel.

3-D References In Excel 2007:
This section explains how we can access the formulas from one sheet to another.

The Chart Wizard In Excel 2007:
This section explains the way to create different charts using the Chart Wizard in Excel.

Pivot Table In Excel 2007:
 - Arranging data on the table.

Printing In Excel 2007:
 - What if you want to print only part of the spreadsheet?
 - Not able to highlight the region you wanted to print?

Troubleshooting In Excel 2007:
This section details the common sources of the errors occurred in Excel.

Popularity: 24% [?]