English 中文
AEX 
Search course content

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
 
 

For more Excel courses, please click here. 

 
 
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
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
     
  top  
     
Duration: 2 evening sessions or 1 day Fee: $1,280
Continuing Education course
Diploma Course in Computer Graphic Design
Diploma course in 3d Modelling and Animation
Diploma in Multimedia Web Design and Development
 
 
  Relating Courses  
 
  Access
  Excel I
  Filemaker Pro
  Financial Accounting with Excel
  Powerpoint
  Powerpoint-Advanced
  Professional Reports Writing using Microsoft Word
  Word I
  Word-Advanced