Excel Training Videos - Tutorials
Excel 2007: Advanced Formulas and Functions - Training Videos - Tutorials
Author: Dennis Taylor | Running Time: 5.25 hours | Training Level : Advanced

In Excel 2007: Advanced Formulas and Functions, author and trainer Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. He then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and even work with financial data using advanced formulas. Dennis focuses on practical examples that will help users easily transition to using these formulas and functions in real-world scenarios. Exercise files accompany this course.
Excel 2007: Pivot Tables for Data Analysis - Training Videos - Tutorials
Author: Curt Frye | Running Time: 2.75 hours | Training Level : Advanced

In Excel 2007: Pivot Tables for Data Analysis, Microsoft Most Valuable Professional Curt Frye helps dispel the common fear of the Pivot Table feature, by demonstrating how to use this powerful tool to discover valuable business intelligence. Curt shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and make visual presentations of data using Pivot Chart reports. Exercise files accompany this course.
Excel 2007: Introduction to Formulas and Functions - Training Videos - Tutorials
Author: Curt Frye | Running Time: 2.5 hours | Training Level : Intermediate

Excel 2007: Introduction to Formulas and Functions shows how to build impressive spreadsheets with the application's built-in capabilities. Excel expert and Microsoft Most Valuable Professional Curt Frye shares his vast knowledge of Excel, demonstrating how to build various arithmetic and statistical analysis formulas. Curt explains how to summarize values in sets of cells, create conditional formulas using IF and other related functions, and use validation rules to make data entry more accurate. He even teaches how to search for data within a list or table using the VLOOKUP and HLOOKUP functions. Exercise files accompany this course.
Excel 2008 for Mac DVD - Training Videos - Tutorials
Author: David Rivers | Running Time: 8.5 Hours | Training Level : Beginner

From customizing the interface to producing professional reports, this Microsoft Excel 2008 for Mac Training Video fully explores the intricacies of working with this information management software. Using real-world examples, this Excel training video explains how to manipulate workbooks; use formulas and functions; perform goal-seeking analyses; layout and present text and charts; use basic templates; and create custom Excel templates, themes, and layouts. Exercise files accompany the tutorials.
Microsoft Excel 2007 Tutorial - Training Videos - Tutorials
Author: Bill Jelen | Running Time: 6 hours | Training Level : Intermediate / Advanced

Now that you got your feet wet learning the new features in Microsoft Excel 2007 in the first video series, Total Training for Microsoft Excel 2007: Essentials, you're ready to dive into the advanced capabilities. While creating pivot tables and macros seems daunting, you'll be at ease learning some new techniques that will streamline your next data analysis project. Sit back and discover how to unleash the power of Excel with this in-depth video series.
Microsoft Excel 2007 Tutorial - Training Videos - Tutorials
Author: Michael Alexander | Running Time: 5 hours | Training Level : Beginner

Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers. This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time!
Excel 2007 - Training Videos - Tutorials
Author: Lorna Daly | Running Time: 5.25 hours | Training Level : Beginner

Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. This Excel 2007 Training Video on DVD , introduces the new version in detail. The training begins with the essentials of using Excel, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. The tutorials then move on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
Excel 2003 DVD - Training Videos - Tutorials
Author: Mark Swift | Running Time: 4 hours | Training Level : Beginner

This Microsoft Excel 2003 Training Video on DVD is authored by Mark Swift, and it's an ideal comprehensive learning resource for users who are new to working with spreadsheets, or those wanting to improve their skills. This training begins with a basic overview of Excel and quickly advances to cover useful formulas, functions, techniques for enhancing spreadsheets, charts, and much more. Exercise files accompany the training, allowing you to follow along with the tutorials at your own pace.