|
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 Unit
Credits) 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!
--------------------------------
|
|
"I've really enjoyed taking
these courses and have found them really
valuable. Thanks for providing great computer courses."
-Allison W.
|
| |
|
 |
|
 |
| Home
> Online Courses >
Business
Skills Package >
Microsoft Excel 2003 |
 |
|
Estimated time to Complete:
21 hours
Continuing Education Units:
Yes
Self Assessment Tests:
Yes
Certification Prepartion:
Yes
24 / 7 Mentoring Service:
Optional
Training Method:
Online, Self-Paced
Subscription Term:
3/6 Months
This course is included
in the Business Office Skills Package
Cost: $99 for 3 Months Access or $149 for 6 Months Access
Summary:
This series is designed for beginning and intermediate
Excel users. This series teaches learners about creating
and editing spreadsheets, what's new in the 2003 version,
the Excel interface, navigating, editing, and working
with text, values, and formulas, printing, formatting,
creating charts and databases, and using images and
hypertext in a spreadsheet.
Audience:
This series is for anyone who wants to get the most
out of using Excel 2003.
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: |
|
 |
| Getting
Started |
 |
| •
Identify the parts of the Excel interface
|
|
| •
Start and exit Excel |
|
| •
Use menus to execute commands |
|
| •
Move around the workbook window |
|
| •
Search for help topics |
|
|
 |
|
|
|
| Managing
Worksheets |
|
| •
View information in a worksheet |
|
| •
Insert comments |
|
| •
Use Find and Replace |
|
| •
Protect a worksheet |
|
| •
Manage multiple worksheets |
|
•
Create a summary worksheet
|
|
|
|
|
|
|
| Creating
a Spreadsheet |
|
| •
Input text, values, and formulas |
|
| •
Edit data |
|
•
Use the speech and handwriting recognition
features
|
|
| •
Use AutoCorrect, AutoFill, and AutoSum |
|
| •
Retrieve backup files following a system
crash |
|
|
|
|
|
|
| Charts
and Databases |
|
| •
Create charts using Chart Wizard |
|
| •
Insert clip art into a worksheet |
|
| •
Create your own graphics |
|
| •
Create a database |
|
•
Manage a database
|
|
|
|
|
|
|
| Formatting
Data |
|
| •
Use AutoFormat |
|
| •
Apply different number formats |
|
| •
Change the size of rows and columns |
|
| •
Change fonts and font sizes |
|
| •
Modify the alignment of cell entries
|
|
| •
Add borders, shading, and colors to
cells |
|
|
|
|
|
|
| Hypertext
and Tips |
|
| •
Adding hyperlinks to a workbook |
|
| •
Follow and edit hyperlinks |
|
| •
Save static and interactive Web pages
in Excel |
|
| •
Edit Web pages |
|
| •
Send Excel workbooks in e-mail
|
|
|
|
|
|
|
| Editing
and Printing Worksheets |
|
| •
Find and open a workbook |
|
| •
Edit a workbook |
|
| •
Find and correct errors |
|
| •
Prepare a workbook for printing |
|
•
Print a workbook
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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! |
|
|
|
