Versions

Initial release

Jan 17, 2009

Average rating for the current version

United States    Display more Countries

Average rating for all versions

United States    Display more Countries

Screenshots

Discover Excel 2007 is interactive multimedia training for users of Microsoft Office Excel 2007. The Discover products combine audio, animation, and software simulation to make the “discovery” of computer programs both effective and entertaining.

Discover Excel 2007 - Part II covers the following topics:

Work With Charts
• Adding Charts
• Create A Chart
• Modify A Chart
• Chart Templates
• Analyzing Chart Data

Work With Graphics
• Graphics In Excel 2007
• Inserting Pictures
• Insert Clip Art
• Adding Shapes & Text Effects
• Insert SmartArt

Share Excel Data
• Overview

Distribute Workbooks
• Proofing Your Workbook
• Add Comments To A Worksheet
• E-mailing Or Faxing A Workbook

Share Workbooks
• Create A Shared Workbook
• Resolve Conflicts
• Track Changes

Workbook Protection
• Protecting Your Workbook
• Allowing Users To Edit Ranges

Publish A Workbook
• Excel Services
• Document Manager Server
• Create A Document Workspace

Work With Tables
• Tables In Excel 2007
• Create & Modify A Table
• Apply Table Styles

Filter & Sort Table Data
• Filter Data
• Advanced Filtering

PivotTable & PivotChart Reports
• Using PivotTable & PivotChart Reports
• Create A PivotTable
• Modifying A PivotTable
• Apply PivotTable Styles
• Create A PivotChart Report
• Modify A PivotChart Report

Outline A Worksheet
• Using Outlines
• Add & Remove An Outline
• Outline A Worksheet Manually

Data Validation
• Use Data Validation
• Circle Invalid Data

What-If Analysis
• Scenarios, Create & View Scenarios
• Use Goal Seek
• Use Data Tables
• Solver
• Use Solver

Link & Consolidate Data
• Data Consolidation
• Consolidate Data
• Link Consolidated Data
• Consolidate Data From Multiple Workbooks

Import Data
• The Office Clipboard
• Import Data From Access With Clipboard
• Get External Data
• Import Data From The Web
• Import Data From Text Files
• Import Data Using Microsoft Query

Use Macros
• What Is A Macro?
• The Developer Tab
• Macro Security
• Record A Macro
• Absolute Vs. Relative Recording
• Edit A Macro
• Stepping Into A Macro

Create Web Pages
• Publish A Worksheet
• Insert A Hyperlink