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
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. Publisher and Subscriber options(Macintosh Only)
  • Create a publisher
  • Subscriber a publisher
13. 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

“… 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

 more ... 

 
 
14. Pivot Table
  • Steps to create a simple pivot table
  • Creating pivot table from Excel
  • Consolidating Data from Multiple Ranges into a Pivot Table
15. Conditional Format
  • Define single and multiple criterial
  • Delete criterial
16. Data Validation
  • Define the data type
  • Define the warning message
  • Define the error message
17. Sharing and tracking worksheets
  • Turning on and let the other users can edit the worksheet.
  • Cancel changes made by the others.
18. Drawing Tool Bar
  • Line, Rectangle, oval etc...
19. 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
20. 3D Chart
  • To construct a 3D chart
  • Formatting the 3D chart
  • 3D View
     
  頂點  
     
本課程共2節晚間或1天。學費$1,280
持續進修基金課程
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
 
 
 
  Schedules
 
 
AEX9011 13 Jan view schedule enrol
 
AEX9022 07 Feb view schedule enrol
 
AEX9023 17 Feb view schedule enrol
 
AEX9021 17 Feb view schedule enrol
 
AEX9031 20 Mar view schedule enrol