|
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!
--------------------------------
|
|
"By the way, I am very pleased
with the on-line courses you offer. I also gave a gift
subscription to a nephew, so that he could take some
courses on-line."
- Kris A.
|
| |
|
 |
|
 |
| Home
> Online Courses >
Microsoft Excel 2000 |
 |
|
Estimated time to Complete:
22 hours
Continuing Education Units:
Yes
Self Assessment Tests:
Yes
24 / 7 Mentoring Service:
Optional
Training Method:
Online, Self-Paced
Subscription Term:
8 Weeks
Cost: $49 >>
Enroll Now
Summary:
The series begins with basic Excel tasks, such as entering
and editing data, using Find, Replace, and AutoFill,
and creating hyperlinks. It also covers locating, opening,
and saving files, and using the help function, Office
Assistant. Formatting worksheets is covered in detail,
including cell and number formatting, adjusting rows
and columns, and the use of AutoFormat, styles, and
Format Painter. More advanced topics covered include
page setup, managing worksheets and data, and creating
formulas and functions. An overview of charts and objects,
including the Chart Wizard, is also provided.
Certification:
This series is also designed to help users prepare
for the Microsoft Office Specialist (MOS) Excel Core
examination.
Audience:
This series is for anyone who wants to get the most
out of using Excel 2000.
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 |
|
| •
Hide and unhide rows and columns |
|
| •
Freeze and unfreeze rows and columns
|
|
| •
Move between worksheets in a workbook
|
|
| •
Rename, insert, delete, move, and copy
worksheets |
|
•
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 |
|
| •
Enter and revise formulas |
|
| •
Use absolute and relative references
|
|
| •
Use the AutoSum feature |
|
| •
Enter and use basic functions |
|
•
Enter and use date functions, financial
functions, and logical functions
|
|
|
|
|
|
|
| Formatting
Worksheets |
|
| •
Format cells |
|
| •
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! |
|
|
|
