課程內容 
Excel部份 
1.Open Microsoft Excel application
2. Basic Technique
- Cells Selection
- Data Entry
- To insert a row
- To delete a row
- Undo
- To copy a range of cells
- To move a range of cells
- Clear cell information
3. Entering a formula
- Using formulas
- Using operators (+,-,x, ¸,etc...)
- Using reference
- Tips for entering a formula
4. Files Operation
- Saving a worksheet
- Save As...
- Save
- To close a worksheet
- Delete a worksheet
5. Printing a file
- Page Setup
- Header and Footer
- File Preview
- Turn the Grid Lines off
- Turn the Row/Column Heading off
- Auto Scaling
- Setting Manual Page Breaks
- Setting Row or Column Titles
- Setting print area
6. Useful functions
- SUM( )
- AVERAGE( )
- MAX( )
- MIN( )
- IF()
- Count()
7. Tips in editing a worksheet
- Paste insert row/column
- Drag and Drop
- Autofill
- Fill down
- Fill right
8. Address Notation
- Relative Address
- Absolute Address
9. Polishing the spreadsheet
- Changing default fonts
- Changing font size
- Changing Column Width
- Changing Row Height
- Setting Border Lines
- Setting Pattern to a Range of Cell
- Turning gridlines on/off
- Alignment(Vertical and Horizontal)
- Text Orientation
- Autoformat
10. Number Format
- Adding Currency Sign to the cells
11. Creating a master spreadsheet
- Creating a document template
- Using a document template
12. Exchange files with other applications
- Changing file format (Louts-123, or old version Excel etc)
13. Styles
- Creating Styles
- Using Styles
- Editing Styles
- Merge any Styles from other documents
 |
|
 |
| |
Client Testimonial
“… Their training programmes are well organised, practical and useful in our work. I am particularly impressed by their training materials and their highly professional trainers.”
Mr. Thomas Ng – Head of Graphic Unit
Hong Kong University of Science and Technology
“… It is our pleasure to write this letter for Computer Academy who started to be one of our PC courses provider since early 1996. Due to its satisfying service, we included it as our external PC vendor of Motorola University…we found that the service proviced by Computer Academy was responsive, reasonably priced and up to our standard…“
Ms. Beth Chiu –Human Resources Section Manager
Motorola Asia Pacific Limited
"Very well-constructed courses. The tutor taught patiently."
Ms Chan Kwun Ping
more ...
|
|
 |
|
 |
|
14. Tool Bar
- Utility Tool Bar
- Promote and demote buttons
- Show outline symbols button(utility Tool Bar)
- Select visible cells button(utility Tool Bar
15. Data sorting
16. Naming Cells and Ranges
- Creating a Name
- Making a name list
- using the name for calculation
17. Database
- The database components
- Data Form
- Inputing Date
- Deleting Date
- Finding Records
- Using menu commands to find records
- Combining search criteria
- Extracting records
18. Data sorting
19. Datebase Functions
20. Creating and Using an Array Formula
21. Managing Documents with Workbooks
22. Consolidation with several Worksheets
23. Data Table
- One-Input Table
- Two-Input Table
24. Lookup Table
- Lookup()
- Vlookup()
- Hlookup()
25. Document protection
- File protection
- Protect cells/document
- Unprotected document
26. File Linking
27. Publisher and Subscriber options(Macintosh Only)
- Create a publisher
- Subscriber a publisher
28. Filter and Advanced Filter
29. Pivot Table
- Steps to create a simple pivot table
- Creating pivot table from Excel
- Consolidating Data from Multiple Ranges into a Pivot Table
30. Conditional Format
- Define single and multiple criterial
- Delete criterial
31. Data Validation
- Define the data type
- Define the warning message
- Define the error message
32. Sharing and tracking worksheets
- Turning on and let the other users can edit the worksheet.
- Cancel changes made by the others.
33. Drawing Tool Bar
- Line, Rectangle, oval etc...
34. Creating a Chart
- Polishing your chart
- Changing the text format and the pattern color in a chart
- Attach Text
- Adding Legend
- Adding Gridlines
- Adding Arrow
- Adding Unattached Text
- Adding Data Series to the Chart
- Creating an Overlay Chart
- Changing chart type
35. 3D Chart
- To construct a 3D chart
- Formatting the 3D chart
- 3D View
|
|
|
| |
Client Testimonial
"I recommend the Computer Training Center without reservation. The quality of the instruction is excellent. The instructors are very knowledgeable and flexible. They will work out the best course strategy for a busy executive with little time and a fast-changing schedule ...”
Ms. Michelle Comrie – Marketing Manager
"Very enjoyable. Useful material that can be applied for job & normal usage."
Mr Oliver So
"Covered all the basics I supposed. Lesson's easy to understand. Steps are clear. Instructions by teacher is super clear."
Ms Elizabeth Mak
more ...
|
|
|
|
|
|
Powerpoint部份
1.Beyond the basic
- Setting up a presentation
- Slide Setup
- Save the settings
2.Quick Browse of PowerPoint
- Switching views
- Outline view
- Slide view
- Note view
- Slide sorter
3.Outline view
- Moving up/down a level
- Importing text from other word processor
- Collapse and Expand points
- To delete a slide
- To create a new slide
- Toolbar in Outline View
4.Slide View
- Transition Effects
- Build Effects
- Setting your timing to playback the slides
8.Handling Text
- Font Attributes
- Aligning Text
- Adding or Deleting Bulet
9.Using Slide Master
- Control the slide title format
- Control the text format
- Inserting the company information (eg. company logo, name, etc)
10.Drawing fatures
- Static objects
- Adding shadow
- Shading the Background
- Changing the Fill Color
- Drawing Technique
- Selecting objects
- Resize an object
- Adding a shadow
- Filling objects
- Inserting Graphic
- Send to Back / Bring to Front
- Aligning objects
- Moving objects
- Deleting objects
11.Notes Pages
- Preparing notes pages
- Notes Master Format
- To format the notes
- Adding date, page number and time
12.Printing your slide
13. Slide show
- Setup slide show
- Loop continuously
- Rehearse timing
14. Using Microsoft Graph
- Creating a chart
- Changing chart type
- Formatting data
- Adding title text to a chart
- Adding data label
- Adding arrow
- Resize arrow
- Gridlines
- Changing the 3D views
15. Using Organisation Chart
- Creating Organisation chart on an existing slide
- Naming the Chart
- Adding subordinates to the organisation chart
- Fill the pattern and line color to the chart
16. Animation effects
- Using and applying the predefined effects
- Animating the bar or column chart
- Animating the bullet point text
- Animating the organization charts
17.Action Buttons
- Using action buttons
- Create navigation menu using action buttons
- Control and jump the presentation sequences
18. More text effect
- Using the Word Art to create 3D text, shadow text, banner, etc
- Using the Equations Editor to create any mathematics equation
19. Adding multimedia effects in your presentation
- Inserting a background music
- Inserting different multimedia files ( music files or movie files)
- Tips on using multimedia files
20. PowerPoint Viewer
21. Creating company standard presentation
- Using the template files
- Creating company template files
- Creating master templates, master title styles or text styles
- Template background creation ( inserting graphic or using pattern)
Word部份
1.Creating and Editing a Document
- Starting a New Document
- Opening an Existing Document
- Inserting Text
- Selecting and Deleting Text
- Undoing a Mistake
- Saving Your Work
2.Revising a Document
- Opening an Existing Document
- Scrolling Through a Document
- Moving Text Using the Cut and Paste Commnads
- Copying Text
- Editing Text
- Savings Changes
- Finding and Replacing Text
- Saving Your Changes
- Find File command
- Switching documents with Windows commands
- Tips
3.Formatting a Document-Character Formatting
- Method for Formatting Characters
- Changing Fonts and Point Sizes
4.Formatting a Document-Paragraph Formatting
- Method for Applying Paragraph Format
- Aligning and Indenting Paragraph Formats
- Tab setting
- Adjusting Spacing Between Lines and Paragraphs
- Border and Pattern
5.Document Formatting-Layout Formatting
- Margins
- Mirror Even/Odd Margins
- Even/Odd Header
- Even/Odd Footer
- File Series
- Widow Control
6.Page Setup
- Paper size setting
- Orientation setting
- Margin setting
7.Previewing Pages
8.Printing
9.Stationery: Setting up Document
- Template
- Creating Stationery
- Revising Stationery
10.Styles
- Applying Styles
- Define your Style
- Using the Standard Style
- Using the Next Style and Based On Option
- Tip in using the Style to create a long document
11.Spell Check
- Creating a New Dictionary
-
- Options... button
-
12.Spell Grammar
13.Table
- Inserting a Table
- Typing text in Table
- Selecting in a Table
- Column Width
- Format text inside a Table
- Setting a tab Stop inside a cell
- Inserting a Column
- Deleting a Column
- Border line setting
- Changing Text into a Table
- Calculating Amounts in columns
- Sorting Table Entries
14.Headers and Footers
- Creating Header/Footer
- Page Layout
- Odd/Even Headers or Footers
- Adding Page Numbers
15.Footnote
- Adding a Footnote
- Revising and Custom
16.Checking grammar
17.Thesaurus
|
