---

• Webcasts

• Video tips

• Podcasts

• Mini-webcasts

---

Webcasts

Recorded from live events by Microsoft Office experts, these roughly 60-minute webcasts can be viewed at your own pace and include presentation slides and audio. Click on the provided URL to access the WMV recording. The file can also be downloaded to your own computer for offline viewing. You do not need to have Microsoft Office Live Meeting installed to view these webcasts, as they are WMV files.

Summarizing Data Effectively Using New Excel 2007 Formulas and Functions
Run time: 00:57:00
In this one-hour webcast, Microsoft Office Excel Most Valuable Professional (MVP) Curtis Frye demonstrates the powerful new formulas and functions that let you summarize data more effectively than ever in Microsoft Office Excel 2007.

Top 10 Tips for Excel 2007 (Level 100)
Run time: 01:02:48
Explore how Excel 2007 takes advantage of a new, results-oriented user interface (UI) that provides easy access to powerful productivity tools, offers a larger workspace, and delivers faster performance.

Tips and Tricks to Manage Data Effectively by Using Excel Tables (Level 200)
Run time:Run time: 00:56:30
Join us for this webcast that will help you streamline your calculations and summaries by storing your information in Excel data tables.

Creating Attractive Charts & Graphics Using Excel 2007 (Level 200)
Run time: 00:58:57
Come learn tips and tricks for organizing your data, creating effective charts, managing colors, and designing organizational charts and other useful graphics.

Creating Effective Conditional Formats Using Excel 2007 (Level 300)
Run time: 00:58:11
Get tips and tricks for summarizing your data, discovering business intelligence (BI), and designing effective information dashboards in Excel 2007.

Advanced Tips and Tricks: Breaking Into Your Office Open XML Format Documents (Level 300)
Run time: 01:05:36
Join us for a guided tour through the XML behind your documents, along with an introduction to how you can edit the XML directly to get more from your documents than ever before.

Advanced Tips and Tricks: Using Visual Basic for Applications (VBA) Every Day Is Easier Than You Think (Level 300)
Run time: 01:14:04
Focusing primarily on tasks in Word 2007, this webcast introduces some core essentials of VBA that can you apply in Word 2007, Excel 2007, and PowerPoint 2007, and provides tips and tricks for using VBA as a daily productivity tool.

Advanced Tips and Tricks: What You Can Really Do with Your Documents Across the 2007 Office Release (Level 300)
Run time: 01:12:25
Join this webcast for a high-level overview of the breadth of document production capabilities across the 2007 Microsoft Office release.

Analyzing Data Dynamically Using Excel 2007 PivotTables
Run time: 1:02:00
Join Office Excel Most Valuable Professional (MVP) Curt Frye as he demonstrates how Office Excel 2007 PivotTable reports can enable you to analyze your spreadsheet data effectively.

 Top of Page

Video tips

Experts show off step-by-step instructions covering the spectrum of the 2007 Office system. Often, you see the presenter at their computer with screenshots as they demonstrate. You'll also find shorter segmented videos for more quick tips. Click on the provided URL and watch at your leisure.

Customizing Conditional Formatting in Excel 2007
Run time: 00:03:11
How to sort a list or table using a adjustable rules.
256k | 750k

Customizing PivotTable Reports to Create Adjustable Charts and Graphs
Run time: 00:05:02
Introduction and definition of conditional formatting.
256k | 750k

Formatting with Conditional Filtering to Organize Data
Run time: 00:02:40
Introduction and definition of conditional formatting.
256k | 750k

Getting Started with PivotTable Reports
Run time: 00:02:50
Introduction to pivot tables in Excel 2007.
256k | 750k

Highlighting and Removing Duplicate Table Values in Excel
Run time: 00:01:00
How to highlight duplicate values in tables.
256k | 750k

New and Improved Features
Run time: 00:07:32
Intro to how you can more easily work with extremely large Excel 2007 spreadsheets.
256k | 750k

Organizing and Grouping with PivotTable Reports
Run time: 00:02:18
Use grouping to easily organize and analyze information.
256k | 750k

 Top of Page

Podcasts

Audio-only version of previously recorded webcasts and 5-10 minute "mini" podcasts focused more on specific function or task within a Microsoft Office product. Click on the provided URL at your leisure to launch the audio file. Or save to your audio device by simply right-clicking the link and saving to a folder you synchronize to your device.

Summarizing Data Effectively Using New Excel 2007 Formulas and Functions
Run time: 00:53:54

Top 10 Tips for Microsoft Office Excel 2007
Run time: 1:03:21

Improving Data Analysis with Excel 2007 PivotTables and PivotCharts
Run time: 00:09:25

Top Tips for Excel 2007
Run time: 1:00:00

 Top of Page

Mini-webcasts

Five-minute webcast focusing on quick tips. Mini-webcasts provide a good way to preview what a full-length webcast is all about. Click on the provided link to access the WMV recording. The file can also be downloaded to your own computer for offline viewing.

5-Minute Excel Webcast
Run time: 00:06:29

Excel Side By Side: What's New & Different
Run time: 00:05:22

Quick Tips for Getting the Most Out of Microsoft Office Excel 2007
Run time: 00:05:26

 Top of Page