1. Home
  2. Computing & Technology
  3. Spreadsheets

Advanced Topics in Excel and other spreadsheets

By Ted French, About.com Guide to Spreadsheets

Advanced topics, such as working with macros, lookup functions, 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 2007 Tools
  2. Data Management
  3. Excel's LOOKUP Functions
  4. Other Advanced Topics
  1. Excel 2003 Tools
  2. Advanced Chart Features
  3. Excel Tips

Excel 2007 Tools

Covered in this section are tools such as protecting worksheets, creating drop down lists, and using the clipboard viewer as well as Add-Ins and templates that can help to make using Excel as straightforward and as painless as possible.

Data Management

This section covers how to create a database in Excel and other spreadsheets. A database can be used to keep track of valuable information such as phone numbers, DVD collections, or a contact list of your organization's members. Spreadsheets like Excel has built in database tools that make it easy to sort and filter a database file to find the information you want.

Excel's LOOKUP Functions

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

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.

Advanced Chart Features

This section includes some of the lesser used charting features such as creating a custom chart, changing the default chart type, and using downloaded templates for creating flow charts and time lines in Excel.

Excel Tips

This section contains tips to help you create effective and eye catching spreadsheets. It also includes shortcuts and explanations for completing a variety of operations in Excel.

Newsletters

  1. Home
  2. Computing & Technology
  3. Spreadsheets

©2008 About.com, a part of The New York Times Company.

All rights reserved.