1. Computing

Advanced Tutorials in Excel and Other Spreadsheets

By

Advanced tutorials, such as working with dates, macros, lookup functions, database tutorials, and pivot tables, can be found here. These topics are explained and covered in a variety of ways including videos, tips, step by step tutorials, and general information articles on the topics.
  1. Excel Formulas
  2. Excel's LOOKUP Functions
  3. Working with Dates in Excel
  4. Data Management
  1. Excel Tools
  2. Other Advanced Topics
  3. Excel 2003 Tools
  4. Excel 2003 Videos

Excel Formulas

The tutorials listed here include how to create array formulas and nested functions. An array formula can perform multiple calculations on one or more cells of data. Nested functions refers to one or more functions being placed inside another. Doing this extends the capabilities of the formula.

Excel's LOOKUP Functions

In large tables or lists of data in Excel you can use lookup functions to find specific data or entire records quickly and easily.

Working with Dates in Excel

Dates are very important in spreadsheet programs like Excel. Most spreadsheets make use of dates in some way. The tutorials below list a number of date-related tutorials, each or which includes a step by step example.

Data Management

Tutorials cover how to create a database in Excel as well as a number of Excel's data tools. These tools include using a form to simplify data entry, sorting and filtering data, removing duplicate records, and creating drop down lists.

Excel Tools

Covered in this section are tools such as protecting worksheets, conditional formatting, as well as Add-Ins and templates that can help to make using Excel as straightforward and as painless as possible.

Other Advanced Topics

Topics include creating macros and using pivot tables in Excel.

Excel 2003 Tools

Covered in this section are features such freeze panes, protecting worksheets, as well as Add-Ins and templates that can help to make using Excel as straightforward and as painless as possible.

Excel 2003 Videos

Videos on advanced topics in Microsoft Excel 2003. A full transcript is provided so you can follow the training videos on your own.

©2014 About.com. All rights reserved.