23 Excel 2007 Tutorials

Here are 23 excellent Excel 2007 Tutorials at Microsoft Office Online that teach and explain important features of Excel with the help of webcasts. These detailed training webcasts presented by various MVPs demonstrate Excel Formulas, Excel Tips, Effective Data Management and creating charts and graphics. Also provided are video tips and mini-webcasts that show how to create and customize pivot tables, highlight and remove duplicate values, use data in Excel sheets effectively, and perform data analysis.


Excel Webcasts:
These Microsoft Excel webcasts teaches users to create attractive charts and graphics and analyzing data dynamically. Advanced tip teach users to access xml format documents in Office.

 - Summarizing Data Effectively Using New Excel 2007 Formulas and Functions
 - Top 10 Tips for Excel 2007 (Level 100)
 - Tips and Tricks to Manage Data Effectively by Using Excel Tables (Level 200)
 - Creating Attractive Charts & Graphics Using Excel 2007 (Level 200)
 - Creating Effective Conditional Formats Using Excel 2007 (Level 300)
 - Advanced Tips and Tricks: Breaking Into Your Office Open XML Format Documents (Level 300)
 - Advanced Tips and Tricks: Using Visual Basic for Applications (VBA) Every Day Is Easier Than You Think (Level 300)
 - Advanced Tips and Tricks: What You Can Really Do with Your Documents Across the 2007 Office Release (Level 300)
 - Analyzing Data Dynamically Using Excel 2007 PivotTables


Excel Video tips:
These video tips imparts knowledge on the new and improved features of Microsoft Excel, how to format and apply conditions to data in tables.

 -  Customizing Conditional Formatting in Excel 2007 256k | 750k
 -  Customizing PivotTable Reports to Create Adjustable Charts and Graphs 256k | 750k
 -  Formatting with Conditional Filtering to Organize Data 256k | 750k
 -  Getting Started with PivotTable Reports 256k | 750k
 -  Highlighting and Removing Duplicate Table Values in Excel 256k | 750k
 -  New and Improved Features 256k | 750k
 -  Organizing and Grouping with PivotTable Reports 256k | 750k


Podcasts:
The podcasts here demonstrate some important tips when using Excel and improving data analysis when using Excel 2007.

 - Summarizing Data Effectively Using New Excel 2007 Formulas and Functions
 - Top 10 Tips for Microsoft Office Excel 2007
 - Improving Data Analysis with Excel 2007 PivotTables and PivotCharts
 - Top Tips for Excel 2007


Mini-webcasts:
These mini-webcasts introduce quick tips on what’s new and different and how to get the most out of Excel 2007.

 - 5-Minute Excel Webcast
 - Excel Side By Side: What’s New & Different
 - Quick Tips for Getting the Most Out of Microsoft Office Excel 2007

Popularity: 22% [?]