August - Sibu and Bintulu : Microsoft Excel 2 days Training RM1550 (excluding sst) - Mahagamy Consultancy And Advisory Sdn Bhd

August - Sibu and Bintulu : Microsoft Excel 2 days Training RM1550 (excluding sst)

Training Programme	Training Details
SIBU - Microsoft Excel Basic and Intermediate	Date: 6 – 7 August 2026 Time: 9:00 AM – 5:00 PM Venue: Starlink Hotel, Sibu Price: RM1,550 per pax, SST excluded Trainer: Chin Chee Chong Trainer Profile: Chin Chee Chong is a highly experienced IT professional and corporate trainer with 23 years of industry experience. He started his career in PC hardware troubleshooting and assembly before moving into IT software applications. He has specialised in Microsoft Office training and development for the past 19 years and has delivered training for both corporate and public sector participants. Brief Course Introduction: This training is designed to help participants build strong Microsoft Excel skills from basic to intermediate level. Participants will learn how to manage data, apply formulas, format worksheets, prepare spreadsheets for printing, use conditional formatting, and create charts for workplace reporting. Learning Objectives: By the end of this training, participants will be able to: • Navigate the Excel Ribbon toolbar and customize the Quick Access Toolbar. • Enter, edit, move, copy, and auto-fill data efficiently. • Apply professional cell formatting, alignment, borders, and number or currency formats. • Use basic formulas and functions such as SUM, AVERAGE, MAX, MIN, COUNT, and COUNTA. • Set print areas, page breaks, margins, headers, and footers. • Insert and manage text boxes, WordArt, diagrams, and visual objects. • Manage multiple worksheets and workbooks. • Apply SUMIF, COUNTIF, conditional formatting, and create charts. Detailed Course Outline: Day 1 – Basic Module 1: Introduction to Excel • The Ribbon Toolbar • Customizing the Quick Access Toolbar • Other new features • Understanding workbooks and selecting cells Module 2: Entering and Editing Data in Excel • Entering data • Editing data • Moving cell contents • Copying contents of cells • Auto Fill and Custom Lists • Using the Fill Command Module 3: Introduction to Functions and Formulas • Operators • Using cell references in formulas • AutoSum • AVERAGE function • MAX function • MIN function • COUNT and COUNTA Module 4: Formatting a Worksheet • Modifying column width • Inserting and deleting columns • Modifying row height • Inserting and deleting rows • Changing font type Module 5: Printing • Page breaks • Page orientation • Margins • Headers and footers • Print area settings Module 6: Drawings and Picture Objects • Changing diagram type • Adding, selecting, manipulating, and formatting text boxes • Adding WordArt • Changing font colour Day 2 – Intermediate Module 7: Managing Worksheets and Workbooks • Adjusting zoom • Using multiple windows • Opening multiple windows of several workbooks • Using Freeze Panes • Using Split Windows Module 8: Functions and Formulas • Relative, absolute, and mixed cell references • Static and dynamic dates and times • Mathematical functions with operators • SUM, AVERAGE, MAX, MIN, COUNT, COUNTA • SUMIF and COUNTIF functions Module 9: Conditional Formatting • Cell highlighting • Top, bottom, and average rules • Data bars • Colour scales and icon sets • Customized rules with formula conditions • Editing, prioritizing, and deleting rules Module 10: Creating Charts • What is a chart? • Inserting a chart • Chart elements • Activating and formatting charts • 3-D charts • Adjusting chart data • Saving chart templates • Working with charts 𝗜𝗺𝗽𝗼𝗿𝘁𝗮𝗻𝘁 𝗡𝗼𝘁𝗲: 𝗣𝗮𝗿𝘁𝗶𝗰𝗶𝗽𝗮𝗻𝘁𝘀 𝗮𝗿𝗲 𝗿𝗲𝗾𝘂𝗶𝗿𝗲𝗱 𝘁𝗼 𝗯𝗿𝗶𝗻𝗴 𝘁𝗵𝗲𝗶𝗿 𝗼𝘄𝗻 𝗹𝗮𝗽𝘁𝗼𝗽 𝗳𝗼𝗿 𝘁𝗵𝗲 𝘁𝗿𝗮𝗶𝗻𝗶𝗻𝗴.
BINTULU - Microsoft Excel Intermediate Plus Advance	Bintulu Session Date: 10 – 11 August 2026 Time: 9:00 AM – 5:00 PM Venue: Goldenbay Hotel, Bintulu Price: RM1,680 per pax, SST included Trainer: Nasruddin Sultan Trainer Profile: Nasruddin Sultan is an extensively knowledgeable IT trainer with expert-level information technology knowledge. He has strong interpersonal and presentation skills and is able to explain highly technical information in a way that is easy for participants to understand. He holds a Master’s degree in Information Technology and has more than 20 years of experience as an IT trainer. Brief Course Introduction: This course is designed for participants who already have basic Excel knowledge and want to progress to intermediate and advanced Excel skills. Participants will learn how to use functions, advanced formulas, PivotTables, charts, multiple worksheets, workbook protection, data validation, lookup functions, and automation tools to improve productivity and workplace data reporting. Learning Objectives: By the end of this training, participants will be able to: • Work with functions, lists, and structured data. • Create advanced formulas and apply conditional logic. • Analyse data using PivotTables and PivotCharts. • Visualise data using charts and reports. • Manage multiple worksheets and workbooks efficiently. • Share, protect, and collaborate on workbooks. • Use lookup functions and combined formulas for data analysis. Detailed Course Outline: Day 1 – Intermediate Level Module 1: Using Functions • Creating and using functions • Commonly used functions • Defining relative, mixed, and absolute references Module 2: Charting • Using charts • Working with charts • Changes to chart source data Module 3: Using Multiple Worksheets and Workbooks • Managing multiple worksheets and workbooks • Creating a 3-D formula Module 4: Advanced Formatting • Creating custom number formats • Conditional formats • Clearing conditional formats Day 2 – Advance Level Module 5: Working with Multiple Worksheets and Workbooks Simultaneously • Use 3-D references • Use links and external references • Consolidate data • INDIRECT function Module 6: Sharing and Protecting Workbooks • Collaborate on a workbook • Protect worksheets and workbooks Module 7: Automating Workbook Functionality • Apply data validation • Work with forms and controls Module 8: Applying Conditional Logic • Use lookup functions • Combine functions • Use formulas and functions to apply conditional formatting • LOOKUP, VLOOKUP, HLOOKUP, INDEX, MATCH, IF, and Nested IF 𝗜𝗺𝗽𝗼𝗿𝘁𝗮𝗻𝘁 𝗡𝗼𝘁𝗲: 𝗣𝗮𝗿𝘁𝗶𝗰𝗶𝗽𝗮𝗻𝘁𝘀 𝗮𝗿𝗲 𝗿𝗲𝗾𝘂𝗶𝗿𝗲𝗱 𝘁𝗼 𝗯𝗿𝗶𝗻𝗴 𝘁𝗵𝗲𝗶𝗿 𝗼𝘄𝗻 𝗹𝗮𝗽𝘁𝗼𝗽 𝗳𝗼𝗿 𝘁𝗵𝗲 𝘁𝗿𝗮𝗶𝗻𝗶𝗻𝗴.

Training Programme

Training Details

SIBU -
Microsoft Excel Basic and Intermediate

Date: 6 – 7 August 2026
Time: 9:00 AM – 5:00 PM
Venue: Starlink Hotel, Sibu
Price: RM1,550 per pax, SST excluded
Trainer: Chin Chee Chong
Trainer Profile: Chin Chee Chong is a highly experienced IT professional and corporate trainer with 23 years of industry experience. He started his career in PC hardware troubleshooting and assembly before moving into IT software applications. He has specialised in Microsoft Office training and development for the past 19 years and has delivered training for both corporate and public sector participants.

Brief Course Introduction:
This training is designed to help participants build strong Microsoft Excel skills from basic to intermediate level. Participants will learn how to manage data, apply formulas, format worksheets, prepare spreadsheets for printing, use conditional formatting, and create charts for workplace reporting.

Learning Objectives: By the end of this training, participants will be able to:
• Navigate the Excel Ribbon toolbar and customize the Quick Access Toolbar.
• Enter, edit, move, copy, and auto-fill data efficiently. • Apply professional cell formatting, alignment, borders, and number or currency formats.
• Use basic formulas and functions such as SUM, AVERAGE, MAX, MIN, COUNT, and COUNTA.
• Set print areas, page breaks, margins, headers, and footers. • Insert and manage text boxes, WordArt, diagrams, and visual objects. • Manage multiple worksheets and workbooks.
• Apply SUMIF, COUNTIF, conditional formatting, and create charts.

Detailed Course Outline:
Day 1 – Basic Module 1:
Introduction to Excel
• The Ribbon Toolbar • Customizing the Quick Access Toolbar • Other new features • Understanding workbooks and selecting cells
Module 2: Entering and Editing Data in Excel
• Entering data • Editing data • Moving cell contents • Copying contents of cells • Auto Fill and Custom Lists • Using the Fill Command
Module 3: Introduction to Functions and Formulas
• Operators • Using cell references in formulas • AutoSum • AVERAGE function • MAX function • MIN function • COUNT and COUNTA
Module 4: Formatting a Worksheet
• Modifying column width • Inserting and deleting columns • Modifying row height • Inserting and deleting rows • Changing font type
Module 5: Printing
• Page breaks • Page orientation • Margins • Headers and footers • Print area settings
Module 6: Drawings and Picture Objects
• Changing diagram type • Adding, selecting, manipulating, and formatting text boxes • Adding WordArt • Changing font colour

Day 2 – Intermediate Module 7:
Managing Worksheets and Workbooks
• Adjusting zoom • Using multiple windows • Opening multiple windows of several workbooks • Using Freeze Panes • Using Split Windows
Module 8: Functions and Formulas
• Relative, absolute, and mixed cell references • Static and dynamic dates and times • Mathematical functions with operators • SUM, AVERAGE, MAX, MIN, COUNT, COUNTA • SUMIF and COUNTIF functions
Module 9: Conditional Formatting
• Cell highlighting • Top, bottom, and average rules • Data bars • Colour scales and icon sets • Customized rules with formula conditions • Editing, prioritizing, and deleting rules
Module 10: Creating Charts
• What is a chart? • Inserting a chart • Chart elements • Activating and formatting charts • 3-D charts • Adjusting chart data • Saving chart templates • Working with charts

𝗜𝗺𝗽𝗼𝗿𝘁𝗮𝗻𝘁 𝗡𝗼𝘁𝗲: 𝗣𝗮𝗿𝘁𝗶𝗰𝗶𝗽𝗮𝗻𝘁𝘀 𝗮𝗿𝗲 𝗿𝗲𝗾𝘂𝗶𝗿𝗲𝗱 𝘁𝗼 𝗯𝗿𝗶𝗻𝗴 𝘁𝗵𝗲𝗶𝗿 𝗼𝘄𝗻 𝗹𝗮𝗽𝘁𝗼𝗽 𝗳𝗼𝗿 𝘁𝗵𝗲 𝘁𝗿𝗮𝗶𝗻𝗶𝗻𝗴.

BINTULU
-
Microsoft Excel Intermediate Plus Advance

Bintulu Session
Date: 10 – 11 August 2026
Time: 9:00 AM – 5:00 PM
Venue: Goldenbay Hotel, Bintulu
Price: RM1,680 per pax, SST included

Trainer: Nasruddin Sultan
Trainer Profile: Nasruddin Sultan is an extensively knowledgeable IT trainer with expert-level information technology knowledge. He has strong interpersonal and presentation skills and is able to explain highly technical information in a way that is easy for participants to understand. He holds a Master’s degree in Information Technology and has more than 20 years of experience as an IT trainer.

Brief Course Introduction:
This course is designed for participants who already have basic Excel knowledge and want to progress to intermediate and advanced Excel skills. Participants will learn how to use functions, advanced formulas, PivotTables, charts, multiple worksheets, workbook protection, data validation, lookup functions, and automation tools to improve productivity and workplace data reporting.

Learning Objectives: By the end of this training, participants will be able to:
• Work with functions, lists, and structured data.
• Create advanced formulas and apply conditional logic.
• Analyse data using PivotTables and PivotCharts.
• Visualise data using charts and reports.
• Manage multiple worksheets and workbooks efficiently.
• Share, protect, and collaborate on workbooks.
• Use lookup functions and combined formulas for data analysis.

Detailed Course Outline:
Day 1 – Intermediate Level
Module 1: Using Functions • Creating and using functions • Commonly used functions • Defining relative, mixed, and absolute references
Module 2: Charting • Using charts • Working with charts • Changes to chart source data
Module 3: Using Multiple Worksheets and Workbooks • Managing multiple worksheets and workbooks • Creating a 3-D formula Module 4: Advanced Formatting • Creating custom number formats • Conditional formats • Clearing conditional formats

Day 2 – Advance Level
Module 5: Working with Multiple Worksheets and Workbooks Simultaneously
• Use 3-D references • Use links and external references • Consolidate data • INDIRECT function
Module 6: Sharing and Protecting Workbooks
• Collaborate on a workbook • Protect worksheets and workbooks
Module 7: Automating Workbook Functionality
• Apply data validation • Work with forms and controls
Module 8: Applying Conditional Logic
• Use lookup functions • Combine functions • Use formulas and functions to apply conditional formatting • LOOKUP, VLOOKUP, HLOOKUP, INDEX, MATCH, IF, and Nested IF

𝗜𝗺𝗽𝗼𝗿𝘁𝗮𝗻𝘁 𝗡𝗼𝘁𝗲: 𝗣𝗮𝗿𝘁𝗶𝗰𝗶𝗽𝗮𝗻𝘁𝘀 𝗮𝗿𝗲 𝗿𝗲𝗾𝘂𝗶𝗿𝗲𝗱 𝘁𝗼 𝗯𝗿𝗶𝗻𝗴 𝘁𝗵𝗲𝗶𝗿 𝗼𝘄𝗻 𝗹𝗮𝗽𝘁𝗼𝗽 𝗳𝗼𝗿 𝘁𝗵𝗲 𝘁𝗿𝗮𝗶𝗻𝗶𝗻𝗴.

Jul 07,2026