Skip to Main Content

Training/Webinars/Workshops: An Introduction to Microsoft Excel 2016 (Intermediate)



An Introduction to Microsoft Excel 2016 (Intermediate)

  • Date: 25th January 2021 (Monday)
  • Time: 9:30 am - 5:00 pm (12:30 pm - 2:00 pm Lunch)
  • Participant: THEi staff and students
  • Venue: Online Platform MS Teams
  • Speaker: Ms. Kiki Cheung
  • Medium of Instruction: English
  • Deadline: 23rd December 2020 (Wednesday)


  • Webinar Outline:
  • Overview of formulas in Excel
  • Overview of Excel tables
  • Flash Fill
  • Text Function
  • Summarize Functions
  • Lookup Function
  • Logical Function
  • Apply conditional formatting
  • Formula Auditing
  • PivotTable
  • Create Chart
  • Protecting Worksheets and Workbooks


  • Recording:
    • This online webinar will NOT be video recorded.
  • How to register:
    • All application should be via VTC email.
    • Successful participants will receive confirmation email one week prior the webinar commence by VTC email.
    • The webinar have a limited quota.
    • If the webinar is overenrolled, applicants will be placed on standby list. If you do not receive our confirmation email, you may consider your enrollment unsuccessful.
  • Not able to attend:
    • If you have successfully registered but you cannot attend the webinar, you need to send email to three days before the webinar to inform us so that we can reallocate the place to standby applicants.
  • Penalty applied for this webinar:
    • If you did not attend webinar and you did not inform us 3 days in advance, you will be suspended from joining other webinars in the coming three months.