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.
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.
- Creating a Drop Down List in Excel 2007 Part 1
- Creating a Drop Down List in Excel 2007 Part 2
- Using Goal Seek in Excel
- Using the Clipboard Viewer in Excel 2007
- Protect Data in Excel 2007 Pt. 1
- Protect Data in Excel 2007 Pt. 2
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 2007 Step by Step Database Tutorial
- Excel 2003 Step by Step Database Tutorial
- Remove Duplicate Data Records in Excel 2007
- Microsoft Excel Sort Feature (Video)
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 2007 Macro Tutorial
- Excel 2003 Macro Tutorial
- Create Excel Pivot Tables (Video)
- Excel 2003 Conditional Formatting
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.
- Freeze Panes in Excel
- How To Use Excel's Flow Chart Template
- Customizing Excel 2003 Auto Fill Handle
- Change the Sheet Tab Color of Excel Spreadsheets
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.
- Create a Custom Excel 2003 Chart
- Changing Excel 2003's Default Chart Type
- One Touch Excel 2003 Charts
- Excel's Flow Chart Template
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.
