Advanced Excel training course outline by Computer Academy

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