2 Excel Tutorials

Here are two excellent Excel Tutorials at Brown University. Excel is a spreadsheet application from Microsoft’s Office Suite and is the most widely used spreadsheet application in the world.


Excel Tutorial
This Excel tutorial covers the terminology used in Excel and its basic components such as Toolbars and Cell Navigation. The tutorial then moves onto data management that includes editing, inserting, deleting, copying and moving data between cells, not to mention sorting and filtering. One of the lesser known aspects of Excel is Natural Language Formulas which is switched off by default. Natural Language Formulas allows the use of column and row labels in formulas, rather than cell references, and this section covers this topic in depth.

Definitions:
This section goes over the defenition of terms used in Excel.

Toolbars:
This section explains about the toolbars in Excel.

Navigating Cells:
This section explains about the navigation of cells in Excel.

Data Mangemnet In Excel:
 - Editing, Moving, and Copying Data
 - Inserting, Deleting, and Clearing Data
 - Using Autofill
 - Controlling Your View of the Data
 - Sorting and Filtering Data

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

Using Natural Language Labels In Excel:
This section reviews this convenient labeling feature in Excel.

3-D References In Excel:
This section explains how formulas on one worksheet to access data on another worksheet.

The Chart Wizard In Excel:
This section explains the Chart Wizard in Excel.

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

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

Troubleshooting:
Common sources of errors occured in Excel explained here.


Riveting, Pivoting Tables Tutorial
Riveting and Pivoting tables are tables that summarize large volumes of data – this Excel tutorial covers the intricacies of Pivot and Rivet Tables including changing, formatting and grouping of data.

 - Pivot Tables In Excel
 - The Pivot Table Wizard In Excel
 - Changing Pivot Tables In Excel
 - Pivot Table Options In Excel
 - Drilling down
 - Formatting
 - Grouping Data

Popularity: 17% [?]