Online tutorials & videos
The following online tutorials are mostly free and will teach you quite a bit about Excel. In fact they are better than some of the expensive classroom training courses.
- Online introduction to Excel: If you are just starting to use excel, this is the perfect resource for you. Here you will find dozens of audio courses that take a step by step approach to learning excel.
- DataPig Technologies: The guys from Data Pig Technologies made a comprehensive collection of videos that explain almost every aspect of Excel. From basic Excel concepts to VBA programming. And most of the videos are free!
- Online Charts Tutorial: Jon Peltier is an Excel-charting superstar. You can use his online tutorial to get you started on Excel charting and also as a reference.
- Basic Formulas Guide: This excellent tutorial will help you master Excel formulas in no time.
- Common uses for Formulas: This collection of samples will help you understand what can be achieved by using excel formulas.
- An introduction to Pivot Tables: The Pivot Table is an amazing tool, but people often shy away from it because Pivot Tables seem complicated. The first page of this PDF contains a clear description of Pivot Tables and how they can be used.
- Creating a Pivot table: A 7-minute video shows you how to create and work with Pivot Tables.
- Pivot Tables in Excel 2007: Excel 2007 Pivot Tables are much easier to use. If you use excel 2007, check out this slightly promotional yet excellent introduction to Pivot Tables.
- Practicing Pivot Tables: This step by step tutorial from Microsoft will help you sharpen your Pivot Table skills.
- Microsoft Excel help / 2007: When all else fails, Microsoft Excel Help is a good source to try.
