English 中文
WEX 
搜索課程簡介

Microsoft Excel course outline by Computer Academy
 
 
1.Open Microsoft Excel application
  • Starting Excel
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
 
 

只需2個課程的費用，可報讀4個指定 MS Office課程，包括：
Excel I、Advanced Excel、Powerpoint I、 Advanced Powerpoint
報讀4個課程費用只需 HK$2,560
詳情請至電2838 6687 聯絡本中心查詢  

 
 

 

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
 
 

另備有不同程度之 Excel 課程以供選擇。
詳情請按此

 
 
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
 
 

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 ... 

 
 
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
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. Drawing tool bar
  • Line, rectangle, oval etc...
17. 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
18. 3D Chart
  • To construct a 3D chart
  • Formatting the 3D chart
  • 3D view
     
  頂點  
     
本課程共2節晚間或1天。學費$1,080
截止報讀於開課二星期
持續進修基金課程
Diploma Course in Computer Graphic Design
Diploma course in 3d Modelling and Animation
Diploma in Multimedia Web Design and Development
 
 
  Relating Courses  
 
  Access
  Excel-Advanced
  Filemaker Pro
  Financial Accounting with Excel
  Powerpoint
  Powerpoint-Advanced
  Professional Reports Writing using Microsoft Word
  Word I
  Word-Advanced
 
 
 
  Schedules
 
 
WEX0083 19 Aug view schedule enrol
 
WEX0081 23 Aug view schedule enrol
 
WEX0085 28 Aug view schedule enrol
 
WEX0091 13 Sep view schedule enrol
 
WEX0092 29 Sep view schedule enrol