| |
|
|
| Course: |
Excel
2002 Getting familiar |
| Course No.: |
E303b |
Hours: |
6Hrs |
| Description: |
| Excel 2002 is right now one of
the most advanced tools in dealing with data and spreadsheets.
Its new feature makes the application friendlier and more powerful.
This course is mainly designed for all Excel users to get familiar
with Excel 2002¡¯s new layout and main functions. Its step-by-step
style provides trainee strong application sense and new experience
of Excel 2002. If you are not familiar with any old office version
operation but you are a Windows frequent user, you can also
take this course. Knowledge of Lotus or other spreadsheets tools
can help in this course. |
| Objectives: |
1. Get familiar with the new layout
of Excel 2002
2. File management with Excel 2002
3. Strengthen inputting and modifying various data with Excel
2002
4. Easy job with Task Pane and Smart Tags
5. Introduction of different kinds of data
6. Introduction of easy job with some functions
7. Formatting sheets with tools and printing layout technique
|
|
|
|
|
| Course: |
Excel
2002 Getting professional |
| Course No.: |
E303i |
Hours: |
6Hrs |
| Description: |
| Making charts according to
the data provided is a professional illustration skill
for an Excel user. And our ¡°Getting professional¡± course
is mainly designed for such users to strengthen their
skill in this field as well as some additional topics.
With the chart illustration function, Excel user can easily
find the visualized answers they need in their specific
job area. |
| Objectives: |
1. Creating, editing and
refreshing Charts
2. Advanced format functions
3. Referencing and tracking cells
4. Workbook operation
5. Advanced printing function |
|
|
|
|
|
| Course: |
Excel
2002 To be expert |
| Course No.: |
E303a |
Hours: |
12Hrs |
| Description: |
| When many people just think
that Excel is just an electronically table generator,
we are going to let you understand it is actually more
powerful than you expect it to be. In this course, we
will focus on the topic---data management and data analysis.
We hope that it will help you to be an expert in applying
Excel operation in all specific area processing, managing
data, and making analysis. |
| Objectives: |
1. Managing data through
tools such as sorter, filter, pivot table¡etc
2. Linking and consolidating Worksheets
3. Protecting Excel Documents
4. Working with Templates
5. Easy job with Excel function
6. Making projections and analyzing data
7. Excel and Web
8. Recording Macros to ease job |
|
|
|
|
|
|
