MODULES
MICROSOFT POWERPOINT
POWERPOINT PRACTICAL: CREATING ENGAGING SLIDES
Date: 5th August 2023 (Saturday)
Time: 0830am - 1230pm
Platform: Zoom
Focus: Engaging PowerPoint Slides; Practicals for Content Flow & Chunking Overwhelming Slides
Fee: RM 100 (early bird); RM 250 (normal price)
ONLINE WEBINAR: CREATING WOW POWERPOINT SLIDES
Date: 16th September 2023 (Saturday)
Time: 9pm - 10pm
Platform: Zoom
Focus: Clean vs creative, sparking excitement with images, animated GIFs, videos, animations
Fee: Free
POWERPOINT PRACTICAL: CREATING WOW POWERPOINT SLIDES
Date: 30th September 2023 (Saturday)
Time: 0830 am - 1230 pm
Platform: Zoom
Focus: Clean vs creative, sparking excitement with images, animated GIFs, videos, animations
*Recording available for those unable to attend
*Email will be sent 3 days prior event. Practical files will be emailed 1 day prior event.
Fee: RM 150
MICROSOFT EXCEL
MODULE 1: FOUNDATION
Courses are held online unless stated otherwise. Participants will need to download a workbook which will be emailed before the course. Each teaching will be followed by practice, so please do standby your laptop!
It is recommended that module 1.1 and module 1.2 are paired.
Module 1.1
Dates:
Announced on Homepage
Time:
9pm - 1030pm week nights
Duration:
1.5 hours
Platform:
Online
Learn:
Excel Interface
Formatting such as cell color, wrapping text, format type
Filter, Sort & Search
Hide & Unhide, Freeze & Unfreeze
Basic Formulas
Sharing, Exporting, Printing, Password Protecting
Module 1.2
Dates:
Announced on Homepage
Time:
9pm - 1030pm week nights
Duration:
1.5 hours
Platform:
Online
Learn:
Dropdown Menu (data validation)
Automatically Highlight Cells (Conditional Formatting)
Using Common Functions (Text Functions, Mathematical Functions)
Creating Tables
Creating Charts
Combo 1.1 & 1.2
PRICE COMBO PROMOTION
Dates:
Announced on Homepage
Time:
9pm - 1030pm week nights
Duration:
1.5 hours
Platform:
Online
Learn
Topics Module 1.1
Topics Module 1.2
MODULE 2: FOCUSED
Courses are held online unless stated otherwise. Participants will need to download a workbook. Each teaching will be followed by practice, so please do standby your laptop!
The modules are customized. It is highly recommended that you attend ExcelForHealthcare1 before attending this level.
Module 2.1
Patient Database
Patient Database
Dates:
Announced on Homepage
Time:
9pm - 1100pm week nights
Duration:
2 hours
Platform:
Online
Learn:
Formatting Patient's Names (Using Text Function)
Formatting Patient's Addresses (Using Text Wrap, Common Text Function)
Formatting Patient's IC (Cell Formatting) and checking for duplicates
Creating Dropdown menus for patients (Data Validation)
Calculating Dates For Length of Stay (Date Functions)
Automatically Highlighting Certain Criterias (Conditional Formatting)
Counting patients with certain criteria (Analysis Functions)
Module 2.2
Health Management
Health Management
Dates:
Announced on Homepage
Time:
9pm - 1100pm week nights
Duration:
2 hours
Platform:
Online
Learn:
Creating Dropdown Menu for staff (data validation)
Automatically Highlighting Certain Criteria Using Bars (Conditional Formatting)
Create a Form Which Can Get All of Staff's Details (Functions)
Calculating Total with specific criteria (Function)
Counting with specific criteria (Functions)
Decision-Making based on specific criteria (Functions)
Module 2.3:
Project-Based
Project-Based
Dates:
Announced on Homepage
Time:
9pm - 1100pm week nights
Duration:
2 hours
Platform:
Online
Learn:
Planning a file to be distributed (data validation, conditional formatting)
Automating calculation such as age from IC, length of stay, age group, discharge status (Functions)
Creating dynamic dashboard (Functions, Slicers, Timelines and Pivot Charts)
MODULE 3: FORWARD
Under Construction