 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
Students will learn advanced techniques for analysing and manipulating data, work with multiple data sources, collaborate with other users, and enhance their spreadsheets using graphic objects.
Students will learn how to add graphics to a worksheet or chart, perform advanced operations on data, create advanced formulas, link files, and record macros.
Prerequisites:
Excel 2002 Intermediate, or equivalent knowledge.
Unit 1 : Using Graphic Objects to Enhance Your Worksheet
Create Graphic Objects
Resize, Move and Copy Graphic Objects
Change the Order of Graphic Objects.
Group Graphic Objects
Format Graphic Objects
Insert clip art
Modify clipart
Unit 2 : Importing and Exporting Data
Import Data from the Web
Import Data from an External Source
Export Data
Save a Worksheet as a Web Page
Publish a Worksheet to the Web
Unit 3 : Working with multiple Data Sources
Create a Workspace
Consolidate Data
Link Cells in Different Work books
Edit Links
Export Excel Data as XML
Import XML Data into Excel
Create a Web Query
Unit 4 : Working with Advanced Formulas
Create Advanced Formulas
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Unit 5 : Analysing Data
Create Scenarios
Use Solver
Use Goal Seek
Report Manager
Unit 6 : Protecting and Sharing your Data
Protect Worksheets
Protect Workbook
Share Your Workbook
Set Revision Tracking
Merge Workbooks
Track Changes
Unit 7 : Introduction to macros
Running a macro
Editing a Macro