English 中文
AEX 
搜索課程簡介

Advanced Excel training course outline by Computer Academy
 
 
1. Naming cells and ranges
  • Creating a name
  • Making a name list
  • using the name for calculation
 
 

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

 
 
2. Database
  • The database components
  • Data form
  • Inputing date
  • Deleting date
  • Finding records
  • Using menu commands to find records
  • Combining search criteria
  • Extracting records
3. Data sorting
Excel
4. Datebase functions
  • DSum()
  • DMax()
  • DMin()
5. Creating and using an array formula
6. Managing documents with workbooks
7. Consolidation with several worksheets
8. Data table
  • One-Input table
  • Two-Input table
9. Lookup table
  • Lookup()
  • Vlookup()
  • Hlookup()
10. Document protection
  • File protection
  • Protect cells/document
  • Unprotected document
11. File linking
  • Paste link
12. Filter and advanced filter
 
 

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

 

“… I must say that I have benefited greatly. Each course is well designed, interesting and easy to follow as well as practical. The result is instant… I have no hesitation in recommending these Photoshop computer courses … to those interested in pursuing the satisfaction of image management. “

Dr. Francis Siu (FPSA, FRPS, EFIAP, Hon FPSHK)

"Very enjoyable. Useful material that can be applied for job & normal uasge."

Mr Oliver So

 more ... 

 
 
13. Pivot table
  • Steps to create a simple pivot table
  • Creating pivot table from Excel
  • Consolidating data from multiple ranges into a pivot table
14. Conditional format
  • Define single and multiple criteria
  • Delete criteria
15. Data validation
  • Define the data type
  • Define the warning message
  • Define the error message
16. Sharing and tracking worksheets
  • Turning on and let the other users can edit the worksheet
  • Cancel changes made by the others
17. Using Scenario Manager
  • How to define a scenario
  • Preview the result of scenario
  • Modify scenario
18. What-If Analysis
  • How to apply What-If Analysis
19. Inserting a Hyperlink to a workbook
  • Creating a Hyperlink
  • Editing a Hyperlink
20. Import data from Internet
  • Getting Stock Quotes
  • Using a Hyperlink
21. Creating a Pick-Up List
22. Creating and using Macros
     
  頂點  
     
本課程共2節晚間或1天
持續進修基金課程
Diploma Course in Computer Graphic Design
Diploma course in 3d Modelling and Animation
Diploma in Multimedia Web Design and Development
 
  Relating Courses  
 
  Access
  Excel Automation using Macros and VBA
  Excel I
  Excel-Advanced
  Excel-formulas & functions
  Filemaker Pro
  Financial Accounting with Excel
  Mastering Excel PivotTables and PivotCharts
  Powerpoint
  Powerpoint-Advanced
  Professional Reports Writing using Microsoft Word
  Word I
  Word-Advanced
 
 
 
  Schedules
 
 
AEX2022 17 Feb view schedule enrol
 
AEX2023 17 Feb view schedule enrol
 
AEX2024 21 Feb view schedule enrol
 
AEX2025 21 Feb view schedule enrol
 
AEX2026 24 Feb view schedule enrol
 
AEX2027 29 Feb view schedule enrol
 
AEX2031 04 Mar view schedule enrol
 
AEX2032 15 Mar view schedule enrol
 
AEX2033 22 Mar view schedule enrol
 
AEX2034 29 Mar view schedule enrol
 
AEX2041 01 Apr view schedule enrol
 
AEX2044 10 Apr view schedule enrol
 
AEX2043 12 Apr view schedule enrol
 
AEX2042 13 Apr view schedule enrol
 
AEX2046 19 Apr view schedule enrol
 
AEX2045 21 Apr view schedule enrol