AppShopper

Discover Excel 2007 HD - Part II

       iOS iPad

Discover Excel 2007 HD 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.

This course 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
• Insert A Hyperlink

Screenshots

	Screenshot 1 of 1

Share with Others

Last changed:

Aug 29, 2010

Category:

Business

Developer:

Last Syllable Systems Inc.

Version:

1.0.0

Average Rating:

1.00 (1)

Size:

220 MB

Other Apps By This Developer

• Discover Access 2007 - Part I
• Discover Access 2007 - Part II
• Discover Access 2007 HD - Part I
• Discover Access 2007 HD - Part II
• Discover Excel 2007 - Part I
• Discover Excel 2007 - Part I (Lite)
• Discover Excel 2007 - Part II
• Discover Excel 2007 - Part II (Lite)
• Discover Excel 2007 HD - Part I
• Discover Outlook 2007 - Part I
• Discover Outlook 2007 - Part I (Lite)
• Discover Outlook 2007 - Part II
• Discover Outlook 2007 - Part II (Lite)
• Discover Outlook 2007 HD - Part I
• Discover Outlook 2007 HD - Part II
• Discover PowerPoint 2007
• Discover PowerPoint 2007 HD
• Discover Word 2007 - Part I
• Discover Word 2007 - Part II
• Discover Word 2007 HD - Part I
• Discover Word 2007 HD - Part II
• Learn Vista & PC Basics Part I