|
Your Satisfaction
is Guaranteed! If
you are not completely satisfied after your first
week (7 days) of training, we will refund your money
- No questions asked!
-------------------------------------
|
All of our computer training courses
are approved for CEU's (Continuing Education Units Credit)
through Otterbein College.
--------------------------------
|
|
Expert
Mentoring -
Live Chat 24 hours a day, 7 days a week |
|
Instant Mentoring provides 24/7 support while you are
enrolled in our online courses.
Our experts can clarify concepts, fine-tune solutions,
confirm a process, or simply provide assurance that
you are on the right track.
Instant Mentoring helps to ensure understanding and
synthesis of any of our online courses.
--------------------------------
|
 |
Certificate of
Completion |
When you have scored 80% or better
on the actual course, you will have the opportunity
to print out a certificate of completion.
If you would like to become a Microsoft Office Specialist
(MOS), our courses will help you prepare for the MOS
exams.
--------------------------------
|
 |
Smart-Tips
Weekly
e-Newsletter |
When you enroll,
you will also receive our weekly "Smart Tips"
E-Newsletter, which is designed
to update your skills even faster!
It's jam-packed with quick tips, short-cuts,
and timesaving guide-lines so you'll become more efficient
and more productive faster than you would have imagined!
--------------------------------
|
|
"The training is excellent.
I have more to learn. Thanks!"
- Sharon P. .
|
| |
|
 |
|
 |
| Home
> Online Courses >
Microsoft Excel 2002 |
 |
|
Estimated time to Complete:
22 hours
Continuing Education Units:
Yes
Self Assessment Tests:
Yes
Certification Preparation:
Yes
24 / 7 Mentoring Service:
Optional
Training Method:
Online, Self-Paced
Subscription Term:
8 Weeks
Cost: $49 >>
Enroll Now
Summary:
It introduces Excel's newest enhancements such as task
panes for New Documents, Clipboard, Search, and Insert
Clip Art; the Ask a Question box; enhancements to Find
and Replace; and additional options for pasting and
for inserting columns and rows. These new features,
along with the productivity tools of previous versions,
are taught within the context of working with cells
and files, page setup and printing, worksheets and workbooks,
formulas and functions, and charts and objects.
Certification:
This series is also intended as preparation for the
Excel 2002 Microsoft Office User Specialist (MOUS) Core
Proficiency exam.
Audience:
This series is for anyone who wants to get the most
out of using Excel 2002 or wants to prepare for the
Excel 2002 Microsoft Office User Specialist (MOUS) Core
Proficiency exam.
Features:
- Exercises that allow users to practice the application
- Files containing the text of the exercises
- Simulations that allow you to practice course skills,
even if you don't have access to the application
- Glossary
- Skill Assessment Tests
Course Outline and Objectives: |
|
 |
| Working
with Cells |
 |
| •
Enter data |
|
| •
Edit one or more cells |
|
| •
Find and replace values |
|
| •
Use the AutoFill feature to create series
|
|
| •
Create and edit hyperlinks |
|
|
 |
|
|
|
| Worksheets
and Workbooks |
|
| •
Insert and delete rows and columns |
|
| •
Modify worksheet names and positions |
|
| •
Insert and delete worksheets |
|
| •
Use 3-D references |
|
| •
Work with a subset of data by filtering
lists |
|
•
Link worksheets, consolidate data, and
check spelling
|
|
|
|
|
|
|
| Working
with Files |
|
| •
Open files |
|
| •
Save files |
|
| •
Send a workbook via e-mail |
|
| •
Save a worksheet or workbook as a Web
page |
|
|
|
|
|
|
| Formulas
and Functions |
|
| •
Work with formulas |
|
| •
Use references and AutoSum |
|
| •
Enter Functions |
|
| •
Use basic and date functions |
|
•
Use financial and logical functions
|
|
|
|
|
|
|
| Formatting
Worksheets |
|
| •
Apply and modify cell formats |
|
| •
Adjust alignment and indentation of
text in cells |
|
| •
Adjust rows and columns |
|
| •
Format numbers |
|
| •
Use the AutoFormatting feature |
|
| •
Define, apply, and remove a style |
|
|
|
|
|
|
| Charts
and Objects |
|
| •
Use the Chart Wizard to create a chart
|
|
| •
Modify charts |
|
| •
Preview and print charts |
|
| •
Insert, move, and delete an object (picture)
|
|
| •
Create and modify lines and objects
|
|
|
|
|
|
|
| Page
Setup and Printing |
|
| •
Preview worksheets, workbooks and Web
pages |
|
| •
Change page setup |
|
| •
Set up headers and footers |
|
| •
Set print options |
|
•
Print worksheets, workbooks, and selections
|
|
|
|
|
|
|
|
|
|
|
 |
|
| And, with all our online courses, your Satisfaction
is Guaranteed! If you are not completely satisfied after
your first week (7 days) of training, we will refund your
money - No questions asked! |
|
|
|
