New SolidWorks weekend intake starts 18 Aug — limited seats available.

03-8063 0414
CAD Training Centre — Knowledge Tree

Excel & Data Analytics

Microsoft Excel Intermediate

Improve spreadsheet skills with our 1-day, HRD Corp claimable Microsoft Excel Intermediate Training Course at CAD Training Centre, Malaysia. Designed for existing users, it covers formulas, text functions, data consolidation, validation, advanced filtering, and conditional formatting to reduce errors and improve workplace reporting. Physical, online, and in-house classes available.

Book Seat Enquire for Team
  • Duration 1 Days
  • Level Intermediate
  • Format Face-to-face
  • CCD Points 10

About this course

Take your Excel skills to the next level with our Microsoft Excel Intermediate Training Course at CAD Training Centre in Malaysia. Designed for participants who already have basic Excel knowledge, this 1-day, HRD Corp claimable course focuses on improving spreadsheet management, data accuracy and reporting efficiency. Learn how to handle information across multiple worksheets, create formulas, apply data validation and organise large amounts of business data more effectively.

The course  covers five essential modules, beginning with text functions and date calculations before progressing to data consolidation across multiple workbooks. Participants will then learn how to apply data validation rules, create drop-down lists, sort and filter database tables, and use conditional formatting with data bars, icons and custom formulas.

Sessions run from 9am to 5pm at our Puchong training centre, with 70% practical hands-on exercises and 30% theory. Live online training is also available via Zoom. Public classes are conducted in simple English and Bahasa Melayu.

Related Articles on Excel Training and Excel Courses

https://www.insightsoftware.com/blog/why-do-we-use-excel/

https://www.highspeedtraining.co.uk/hub/what-excel-skills-are-employers-looking-for/

https://www.youtube.com/shorts/2TxUIDRAXWM

https://medium.com/@mygreatlearning/career-opportunities-that-require-excel-skills-in-2026-6097d67af517

Learning Outcomes

  • Apply Excel text functions and date calculations to manage spreadsheet information more effectively.
  • Consolidate data from multiple worksheets and workbooks into organised reports
  • Create and apply data validation rules to improve data entry accuracy.
  • Set up custom drop-down lists, input messages and error alerts to prevent incorrect data entry.
  • Organise and manage database tables using sorting, Text to Columns and advanced filters.
  • Use conditional formatting with data bars, icons and custom formulas to highlight important information.
  • Create more complex formulas to handle challenging workplace tasks.
  • Improve spreadsheet efficiency through practical data management and reporting techniques.

Who is it for

  • Anyone who already has basic Excel knowledge and needs to go further — this course is not for beginners
  • Accounts, Sales and Marketing, Administration, and Procurement staff maintaining spreadsheet data
  • Human Resources, Business Development, and Engineering professionals managing data within spreadsheets
  • Anyone wanting to reduce manual, repetitive formatting and validation work in Excel

Course outline

Module 1

Formulas and Functions
  • Working with Excel text functions Performing date calculations
Module 2

Data Consolidation
  • Consolidating data within the same workbook Consolidating data from multiple workbooks
Module 3

Data Validation
  • Applying data validation
  • Understanding different types of validation criteria
  • Setting meaningful error alert messages
  • Providing user-friendly input messages
  • Using formulas in data validation
  • Creating custom drop-down lists
  • Removing data validation rules
Module 4

Database (Table)
  • Sorting database lists
  • Using the Text to Columns feature
  • Applying advanced filters to manage data
Module 5

Conditional Formatting
  • Highlighting the top 10 numbers
  • Using data bars to display values visually
  • Using icons instead of numbers
  • Adding conditional formatting rules
  • Changing existing conditional formatting rules
  • Creating custom formats
  • Applying conditional formatting using formulas
  • Deleting conditional formatting rules
Module 6

Practical Exercises
  • Hands-on exercises covering the course modules
  • Applying the techniques learned during training

Course format

Choose the delivery mode that fits your team and timeline.

  • 01

    Classroom

    Instructor-led sessions in our Bandar Puteri labs with guided exercises, live demos, and peer discussion.

  • 02

    Online

    Live virtual delivery with the same syllabus, shared files, and instructor checkpoints — ideal for distributed teams.

  • 03

    In-house

    Private cohorts for your organisation, scheduled around project deadlines with content tailored to your standards.

Upcoming schedule

Public intakes coming up.

  • 2 Dec 2026 - 2 Dec 2026 9:00 AM – 5:00 PM · Face-to-face
    Book seat
  • 7 Jan 2027 - 7 Jan 2027 9:00 AM – 5:00 PM · Face-to-face
    Book seat

Certification & policies

Certificate of attendance

Receive a certificate of attendance upon completing the programme, suitable for HR records and continuous learning portfolios.

Free Repeat Class

Free Repeat Class: if you need another pass at the same public syllabus within 6 months, you may re-attend subject to seat availability.

Materials provided

  • Course workbook / digital notes
  • Exercise files and sample templates
  • Certificate of attendance
  • Post-class support window for clarification questions

Frequently asked questions

01 Is Microsoft Excel Intermediate suitable for beginners?

Microsoft Excel Intermediate is designed for participants who already have basic knowledge of Excel. You should be familiar with entering data, using simple formulas, formatting worksheets and navigating spreadsheets. If you have little or no experience with Excel, we recommend starting with our Microsoft Excel Basics course

02 What will I learn in the Microsoft Excel Intermediate course?

You will learn how to use text functions and date calculations, consolidate data from multiple workbooks, apply data validation rules, create drop-down lists and manage database tables. The course also covers advanced filtering and conditional formatting using data bars, icons and formulas.

03 How long does the Microsoft Excel Intermediate course take?

Microsoft Excel Intermediate is a 1-day hands-on training programme. Classes run from 9:00 AM to 5:00 PM. Participants attending classroom training also receive an RM15 cash voucher for lunch.

04 What is the difference between Microsoft Excel Basics, Intermediate and Advanced?

Microsoft Excel Basics introduces essential spreadsheet skills, simple formulas and formatting. Microsoft Excel Intermediate builds on these foundations with data consolidation, data validation, text functions and advanced filtering. Microsoft Excel Advanced focuses on higher-level techniques such as What-If Analysis, PivotTables, INDEX and MATCH, and lookup functions. Each level takes one day.

05 Where is the Microsoft Excel Intermediate training conducted?

Our classroom training takes place at CAD Training Centre in Bandar Puteri, Puchong, Selangor, approximately a 4-minute walk from Bandar Puteri LRT station. Shaded parking is available nearby, with parking options starting from approximately RM5 per day.

06 Do I need to bring my own laptop or purchase Microsoft Excel software?

No. CAD Training Centre provides laptops with Microsoft Excel installed for participants attending physical classes. You may bring your own laptop if preferred. A training handbook is also provided for reference during the course.

07 Will I receive a certificate after completing the Microsoft Excel Intermediate course?

Yes. Participants receive a Certificate of Attendance after completing the Microsoft Excel Intermediate Training Course. Certificates are also provided upon completing the Basics and Advanced levels.

08 What language is the Microsoft Excel Intermediate course conducted in?

Our public Microsoft Excel training courses are conducted in a mix of simple English and Bahasa Melayu to make the lessons easy to understand. Mandarin-language training can also be arranged for corporate groups upon special request.

09 Is the Microsoft Excel Intermediate training HRD Corp claimable?

Yes. Our Microsoft Excel Intermediate Training Course is HRD Corp claimable under the SBL Khas scheme, subject to the applicable eligibility and approval requirements. This allows eligible Malaysian employers to apply for training grants for their employees.

10 Can I attend Microsoft Excel Intermediate training online instead of in a classroom?

Yes. Classroom training means physical attendance in Puchong with face-to-face guidance and co-learning with other participants. Online training runs live via Zoom with hands-on, screen-shared exercises, better if you're outside the Klang Valley or want to save on travel time.

11 Can I repeat the Microsoft Excel Intermediate course if I need more practice?

Yes, free repeat classes are offered every month, no questions asked, if you need a refresher.

12 Is there a surau (prayer room) available at CAD Training Centre?

Yes, we have a surau available at our training centre in Puchong. Muslim participants can use the prayer room during breaks throughout the training day.

Next step

Register your interest

Share a few details and we will confirm seats, HRD Corp claimability, and the best public or in-house option for this course.

Training type