Advanced Tutorials in Excel and Other Spreadsheets
By Ted French, About.com Guide to Spreadsheets
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.
Working with Dates in Excel
Dates are very important in spreadsheet programs like Excel. Most spreadsheets make use of dates in some way. The articles below list a number of date-related tutorials, each or which includes a step by step example of working with dates in Excel.
- Sort by Date and Other Excel 2007 Date Options
- Subtract Dates in Excel
- Excel Date Functions - Calculate the Number of Days Between Dates
- Excel Date Functions - Adding the Date to a Spreadsheet
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 Database and List Tutorials
- Excel Pivot Table Tutorials
- Excel Data Entry Form for Excel Databases Tutorials
Excel 2007 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.
- Protect Data in Excel 2007 Pt. 1
- Protect Data in Excel 2007 Pt. 2
- Excel 2007 Freeze Panes
- Excel Conditional Formatting Tutorials
- Using Goal Seek in Excel
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.
- Excel 2007 VLOOKUP Step by Step Tutorial
- Excel 2007 VLOOKUP Function - Short Tutorial
- Excel 2007 HLOOKUP Function
- Excel 2003 VLOOKUP
- Excel 2003 HLOOKUP
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)
- Create a Template in Excel 2007
- Create a Formatting Style in Excel 2007
- Copy a Formatting Style in Excel 2007
- Excel 2007 Custom Header
- Excel 2007 Custom Footer
- Excel 2007 Options Button
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 2003
- Excel 2003 Conditional Formatting
- Excel 2003 Data Entry Form
- Customizing Excel 2003 Auto Fill Handle
- More Excel 2003 Charts
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.
