INTRODUCTION

This comprehensive 2 day training program is designed to build upon your existing Excel knowledge and take your skills to the next level. Throughout the day, we will dive into intermediate-level concepts and techniques that will empower you to manipulate data, perform advanced calculations, and create visually appealing reports and analyses.

This training is specifically tailored for individuals who are familiar with the basics of Excel and are eager to expand their proficiency in this powerful spreadsheet software. Whether you’re a business professional, analyst, student, or anyone who works with data, this training will equip you with the necessary tools and techniques to work more efficiently and effectively in Excel.

We have carefully structured the training agenda to cover a wide range of topics, including data manipulation and analysis, formulas and functions, advanced formatting techniques, data analysis tools, data validation, and collaboration features. By the end of the day, you will have gained valuable skills and knowledge that can be immediately applied to your everyday work tasks.

Throughout the training, we encourage active participation, as you will have opportunities to practice the concepts

through hands-on exercises and engage in discussions. Additionally, we will provide you with valuable resources and references to support your continued learning beyond this training.

 

 

LEARNING OUTCOMES

Apply advanced data manipulation techniques:

• Sort and filter data efficiently.
• Utilize advanced filtering options for complex data
• Work effectively with tables and structured references.
• Implement conditional formatting to highlight data patterns.

Demonstrate proficiency in using formulas and functions:

• Utilize intermediate-level functions such as IF, VLOOKUP, and
• Apply logical functions (AND, OR, NOT) for complex
• Nest functions to perform advanced calculations.

Implement advanced formatting techniques:

• Customize cell formatting to enhance visual
• Apply styles and themes for consistent formatting.
• Create and modify templates for efficient document creation.
• Utilize conditional formatting to visually represent data

Utilize data analysis tools effectively:

• Create and modify PivotTables and PivotCharts for data
• Use slicers and timelines to interactively analyze data.
• Apply What-If Analysis tools (Goal Seek, Scenario Manager) for decision-making.

 

COURSE CONTENT

MODULE 1 : INTRODUCTION TO EXCEL AND BASIC FUNCTIONS

• Overview of Excel interface and navigation
• Entering data and formatting cells
• Basic mathematical operations and formulas
• Introduction to functions (e.g., SUM, AVERAGE, MAX, MIN)

MODULE 2 : WORKING WITH DATA

• Sorting and filtering data
• Using conditional formatting
• Working with tables and ranges
• Introduction to data validation

MODULE 3 : MANAGING WORKSHEETS AND WORKBOOKS

·         Creating, renaming, and deleting worksheets

• Moving and copying worksheets
• Linking data between worksheets
• Protecting worksheets and workbooks

MODULE 4 : VISUALIZING DATA

• Creating basic charts (e.g., column, bar, line, pie
• Customizing charts (titles, legends, axes)
• Adding data labels and trendlines
• Introduction to sparklines

MODULE 5 : ADVANCED FORMULAS AND FUNCTIONS

• Using logical functions (e.g., IF, AND, OR)
• Working with text functions (e.g., CONCATENATE, LEFT, RIGHT)
• Date and time functions
• Lookup and reference functions (e.g.,VLOOKUP,HLOOKUP,INDEX,MATCH)

MODULE 6 : DATA ANALYSIS TOOLS

•  Using filters and advanced filtering
• PivotTables and PivotCharts
• Data analysis with scenarios
• Goal Seek and Solver

MODULE 7 : ADVANCED DATA MANAGEMENT

• Consolidating data from multiple sources
• Data validation techniques
• Text-to-columns and splitting data
• Removing duplicates and cleaning data

MODULE 8 : ADVANCED CHARTING AND GRAPHICAL ELEMENTS

• Advanced chart types (e.g., radar, doughnut, waterfall)
• Formatting and customizing charts
• Adding secondary axes and combination charts
• Working with sparklines and slicer

MODULE 9 : ADVANCED DATA ANALYSIS

•  What-If Analysis (e.g., data tables, scenarios)
• Statistical analysis using Excel functions
• Regression analysis and trendlines
• Introduction to Power Query

MODULE 10 : AUTOMATING TASKS WITH  MICROS

• Recording and running macros
• Editing and debugging macros
• Assigning macros to buttons and shortcuts
• Introduction to VBA (Visual Basic for Applications)

MODULE 11 : COLLABORATION AND DATA SHARING

• Protecting and sharing workbooks
• Tracking changes and comments
• Sharing workbooks via email and cloud storage
• Introduction to Excel Online and co-authoring

MODULE 12 : ADVANCED TIPS & TRICKS

• Using keyboard shortcuts for productivity
• Customizing the Excel environment
• Tips for optimizing large datasets
• Troubleshooting common Excel issues

 

METHODOLOGY

An adult learning approach using a combination of lectures and simulation, exercises, hands-on with close supervision by the trainers, presentation, management games & group discussions

 

WHO SHOULD ATTEND?

Open to all

 

TRAINER (either one of them)

Fakhrul Syahmi (either one of them)

Hazry Hidzir

Shamsiyah Abd Kadir

Suhaily Georga Abdullah

Adila Diyana Erwan

Kamil Rohman

 

FEES (WITHOUT ACCOMODATION)

RM1,100.00 per pax

Early Bird RM1,000.00 per pax

(20 days before program)

2 pax RM 1,050.00 per pax

3 pax > RM1,000.00 per pax

(This fees is inclusive of 2 morning tea breaks, 2 lunch , 2 afternoon tea breaks, notes and certificate of attendance for the participants)