|
|
|
Discover better ways to analyze data and find solutions
using Microsoft Excel 2000 and its streamlined spreadsheet
creation tools, enhanced analysis tools, and powerful Web
integration. Whether you are an expert or a novice, Excel
will help you work more efficiently, turning your data into
answers you can count on. [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 and toolbars
-
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 a border
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:
-
Replace a
specific entry in a worksheet
-
Create and
apply a new style
-
Use a workbook
template
-
Enter absolute
cell references 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
-
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
-
Freeze window
panes
-
Change the zoom
level of a worksheet
-
Access the
World Wide Web from Excel
-
Link an Excel
workbook to a Web page
-
Create a
drawing on a worksheet
-
Insert a
picture into a worksheet
-
Send Excel data
via electronic mail
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 and use the name in a formula
-
Use the VLOOKUP
and HLOOKUP functions
-
Create a
template
-
Modify the
default 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 and filter
database records
-
Total database
entries
-
Create a
PivotTable and a PivotChart report
-
Reset the
summary function in a PivotTable report
-
Use the Solver
-
Outline a
worksheet
-
Import data
from other applications into Excel
-
Export Excel
data into other applications
-
Track changes
in a workbook
-
Insert comments
into a worksheet
-
Accept and
reject proposed changes in a workbook
-
Protect both a
shared and an unshared workbook
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 |
|
|
