|
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 Expert 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:
It covers expert-level Excel topics such as importing
and exporting data, working with templates, linking
workbooks, and using the Report Manager. It also covers
advanced worksheet formatting, including page setup
and printing, and sorting and filtering data. More advanced
topics covered include ranges, macros and customization,
validating and auditing data, and creating and using
charts, graphs, and pivot tables. Data analysis, file
sharing, and security issues are also discussed.
These advance topics can also be used in Excel XP -
2002, and Excel 2003
Certification:
This series is also designed to help you prepare for
the Microsoft Office Specialist (MOS) Excel 2000 Expert
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: |
|
 |
| Importing
and Exporting Data |
 |
| •
Import data from a text file |
|
| •
Import data from an application |
|
| •
Import a table from an HTML file |
|
| •
Query a database |
|
| •
Export data to an application |
|
|
 |
|
|
|
| Validating
and Auditing Data |
|
| •
Validate data |
|
| •
Use the Auditing toolbar |
|
| •
Trace cells referenced in a formula
(precedents) |
|
| •
Trace formulas that depend on contents
of a cell (dependents) |
|
|
|
|
|
|
| Working
with Templates, Links, and Report Manager
|
|
| •
Create - Edit a template |
|
| •
Apply a template to a workbook |
|
| •
Use a workspace |
|
| •
Preview worksheets |
|
| •
Print worksheets |
|
| •
Use the Report Manager |
|
|
|
|
|
|
| Analyzing
Data and Using PivotTables |
|
| •
Use Goal Seek to backsolve from a solution
to its values |
|
| •
Use Solver |
|
| •
Work with scenarios |
|
| •
Use PivotTables for data analysis |
|
| •
Use the PivotTable AutoFormat feature
|
|
| •
Create PivotChart reports |
|
| •
Create an interactive PivotTable for
the Web |
|
•
Add fields to a PivotTable using the
Web browser
|
|
|
|
|
|
|
| Formatting,
Sorting, and Filtering Data |
|
•
Apply accounting, currency, and number
formats to data
|
|
| •
Create a custom number format |
|
| •
Adjust rows and columns |
|
| •
Use and apply conditional formatting |
|
| •
Sort data |
|
| •
Generate subtotals |
|
| •
Group and outline data |
|
| •
Use a data form for data entry and retrieval
|
|
| •
Create a data filter |
|
| •
Extract data |
|
|
|
|
|
|
| Sharing
Work and Adding Security |
|
| •
Create, edit, and remove a cell comment
|
|
| •
Change workbook properties |
|
| •
Apply and remove worksheet and workbook
protection |
|
| •
Apply and remove file passwords |
|
| •
Track changes |
|
| •
Create a shared workbook |
|
| •
Merge workbooks |
|
|
|
|
|
|
| Naming
Ranges, Working with Macros, and Customizing
Toolbars |
|
| •
Add and delete a named range |
|
| •
Use a named range in a formula |
|
| •
Use lookup functions (HLOOKUP and VLOOKUP)
|
|
| •
Record - Edit a macro |
|
| •
Assign a macro to a toolbar button |
|
| •
Hide and display toolbars |
|
|
|
|
|
|
|
|
|
|
 |
|
| 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! |
|
|
|
