|
|
|
Create, analyze, and share important data quickly with
Microsoft Excel version 2002, the Office XP spreadsheet
program. New features, like smart tags and task panes,
simplify common tasks. Collaborative enhancements streamline
your information-review process. New data-recovery features
protect your work. And refreshable queries allow you to
integrate live data from the Web or any other source. [Part 1]
[Part 2] [Part 3]
[Part 4]
|
Prerequisites
A knowledge of personal computer fundamentals,
experience in working within the Microsoft Windows
environment, a reasonable degree of keyboard
proficiency and experience in using a mouse.
Objectives
After completing this course, students will be able
to:
-
Start Excel
-
Use the Excel
menu system, toolbars and task panes
-
Display Help
information
-
Reset the
working folder
-
Open and close
a workbook
-
Enter labels
and values into a worksheet
-
Enter a formula
into a worksheet
-
Adjust column
width in a worksheet
-
Print a
worksheet
-
Open a new
workbook
-
Use the
Spelling Checker
-
Automatically
fill a range
-
Move and copy
cell entries
-
Automatically
compute a row/column total
-
Insert and
delete rows and columns
-
Adjust row
height in a worksheet
-
Realign cell
entries
-
Reset the font
and number format of cell entries
-
Add borders and
shading to a worksheet
-
Change the page
setup and preview a worksheet
-
Print selected
worksheet entries
-
Use Excel
functions (SUM, AVERAGE, MAX, MIN and COUNT)
Course Materials
The student kit includes a comprehensive workbook and
other necessary materials for this class.
[Part 1]
[Part 2] [Part
3] [Part 4]
Top of
Page
|
Prerequisites
Part 1 or equivalent
knowledge.
Objectives
After completing this course, students will be able
to:
-
Find and
replace a specific entry in a worksheet
-
Create and
apply a style
-
Enter an
absolute cell reference into a formula
-
Use the PMT and
FV functions
-
Use the IF
function
-
Use the DATE
and NOW functions
-
Plot a basic
chart
-
Modify and
enhance a basic chart
-
Add new data to
an existing chart
-
Filter a list
-
Specify a
criteria range in a filter operation
-
Set up related
worksheets within a workbook
-
Enter a formula
to link related worksheets in a workbook
-
Format multiple
worksheets in one operation
-
Split the
Workbook window into panes
-
Hide rows and
columns of a worksheet
-
Change the zoom
level for a worksheet
-
Create a
drawing on a worksheet
-
Insert a
picture into a worksheet
-
Use an Excel
template to create a workbook
-
Preview and
save Excel data as a Web page
-
Insert a
hyperlink into a worksheet
-
Insert comments
into a worksheet
Course Materials
The student kit includes a comprehensive workbook and
other necessary materials for this class.
[Part
1] [Part 2]
[Part 3] [Part
4]
Top of
Page
|
Prerequisites
Part 2 or equivalent
knowledge.
Objectives
After completing this course, students will be able
to:
-
Restrict cell
entries to specific numbers, dates or times
-
Restrict cell
entries to specific entries in a list
-
Create a custom
number format
-
Apply
conditional formatting to a worksheet
-
Define a range
name
-
Use a range
name in a formula
-
Use the VLOOKUP
and HLOOKUP functions
-
Create a new
workbook template
-
Modify the
default workbook template style
-
Trace
precedents and dependents in a worksheet
-
Trace errors in
a worksheet
-
Enter a formula
to link multiple workbooks
-
Create a
workspace
-
Sort the
records of a list
-
Add subtotals
to a list
-
Outline a
worksheet
-
Create a
PivotTable report and a PivotChart report
-
Create and
display a scenario
-
Import external
data into Excel
-
Export Excel
data to other applications
-
Track changes
in a workbook
-
Respond to
proposed changes and comments in a workbook
-
Protect a
shared workbook and an unshared workbook
-
Add a trendline
to a chart
-
Save an Excel
workbook as an XML spreadsheet
Course Materials
The student kit includes a comprehensive workbook and
other necessary materials for this class.
[Part 1] [Part
2] [Part 3]
[Part 4]
Top of
Page
|
Prerequisites
Part 3 or equivalent
knowledge.
Objectives
After completing this course, students will be able
to:
-
Record and run
a personal macro
-
Record and run
a workbook macro
-
Edit a macro
-
Add a macro
button to a worksheet
-
Open a new
module in the Visual Basic Editor
-
Display a data
prompt during macro execution
-
Use a
conditional statement in a macro
-
Use a control
loop in a macro
-
Place a combo
box on a worksheet
-
Place a check
box on a worksheet
-
Link a control
to worksheet data
-
Create a new
toolbar
-
Add a button to
a toolbar
-
Assign a macro
to a toolbar button
-
Create a new
menu
-
Add an item to
a menu
-
Assign a macro
to a menu item
-
Display Visual
Basic Help information
Course Materials
The student kit includes a comprehensive workbook and
other necessary materials for this class.
[Part 1] [Part
2] [Part 3]
[Part 4]
Top of
Page |
|
|
