Microsoft Excel - Advanced THABW

Program Overview

This advanced Microsoft Excel course empowers individuals with an established understanding of the software to enhance their efficiency and excel in data management roles. Delivered online, it covers advanced features, complex spreadsheet creation, formula and macro application, and data visualization techniques. Participants will gain the skills to plan, create, and manage complex spreadsheets, automate tasks, and generate insightful charts and tables.

Program Outline

Degree Overview:

• Overview: This short course is designed for individuals who have an established understanding of Microsoft Excel spreadsheets and are looking to become more efficient in its many functions.
It aims to help participants excel in their current positions or prepare for promotions into roles managing complex data. Delivered online, the course offers convenience and effectiveness, featuring video tutorials, online exercises, and group discussions.
• Objectives: The course aims to provide participants with an advanced-level understanding of Microsoft Excel, enabling them to plan and create complex spreadsheets, apply advanced formulas and macros, create time-saving data management processes, and generate useful charts and tables.

Outline:

• Program Content: The program covers topics such as workstation ergonomics while working with Excel, advanced Microsoft Excel features, planning and creating advanced/complex spreadsheets, entering, checking, and amending data in Excel, using and applying complex formulas, discussing IF Formula, V-Lookup & H-Lookup, and Nested IF statements, discussing the use of MACROS in Excel, moving and linking Excel spreadsheets, and using Pivot Tables and Charts.
• Structure: The program is delivered over a one-day workshop via an online platform, with scheduled webinar or Zoom sessions.
It includes short videos, electronic resources, and group discussions to support the learning of key principles related to managing workplace relationships.