| COURSE
DESCRIPTION
Excel,
one of the most widely used business applications, facilitates the
management of enormous amounts of numbers and data. Excel skills
are desired by employees, businesses and home owners alike. In this
course you will learn to calculate advanced formulas, build complex
calculations, work with graphic objects, and sort and filter data
using forms and templates.
PREREQUISITES
Microsoft Excel
2003 - Level 2
| CORE
TOPICS |
| Streamlining
Workflow |
|
Analyzing
Data |
| Create
a macro
Edit
a macro
Customize
Access to Excel commands
Apply
conditional formatting
Add
data validation criteria
Update
a workbook's properties
Modify
Excel's default settings |
|
Create
a trendline
Create
scenarios
Perform
What-If analysis
Develop
a PivotTable © report
Develop
a PivotChart© report
Perform
statistical analysis with the Analysis ToolPak |
| Collaborating
with Others |
|
Working
with Multiple Workbooks |
| Protect
files
Share
a workbook
Set
revision tracking
Review
tracked revisions
Merge
workbooks
Adjust
macro settings
Administer
digital signatures |
|
Create
a workspace
Consolidate
data
Link
cells in different workbooks
Edit
links |
| Auditing
Worksheets |
|
Importing
and Exporting Data |
| Trace
cell precedents
Trace
cell dependents
Locate
errors in formulas
Locate
invalid data and formulas
Watch
and evaluate formulas
Group and
outline data |
|
Export
to Microsoft Word
Import
a Word Table
Import
text files |
|
|
Structuring
XML Workbooks |
| |
|
Develop
XML Maps
Import,
add and export XML data
Manage
XML workbooks
Apply XML
view options |
|
