Training/Webinars/Workshops: MS Office (Microsoft Excel 2016) (Basic & Intermediate)

• Speaker:Mr Peter Chan
• Date: 16th January 2020 (Thursday)
• Time: 9:30 a.m. – 5:00 p.m. (12:30 p.m. – 2:00 p.m. Lunch)
• Venue: S306 (Computer Room 3) , THEi (Chai Wan)
• Workshop outline:

Basic

• Filling and Entering Series
• Overview of Formulas
• Entering a Function in a Cell
• Working with Function
• Working with Chart
• Printing Worksheets

Intermediate

• Using Conditional Formatting
• Creating a Formula by using a Function
• Data Management
• Connect External Data to your Workbook
• Working with PivotTables
• Protecting Workbooks and Worksheets