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

03-8063 0414
CAD Training Centre — Knowledge Tree

Excel & Data Analytics

Microsoft Excel Basics

Start your Excel learning journey with our Microsoft Excel Basics Training Course at CAD Training Centre in Malaysia. Designed for beginners, this 1-day, HRD Corp claimable course covers essential Excel formulas, functions, data entry, formatting and spreadsheet management. 1 Day Course, HRDCorp Claimable, Physical and Online class available. In-house training available.

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

About this course

Start your Excel learning journey with our Microsoft Excel Basics Training Course at CAD Training Centre in Malaysia. Designed for beginners, this 1-day, HRD Corp claimable course covers essential Excel formulas, functions, data entry, formatting and spreadsheet management. Gain practical skills to work faster, organise data and improve daily productivity. Attend hands-on training in Puchong or live online via Zoom, with free repeat classes.

This course covers seven essential modules, beginning with the Excel environment and worksheet navigation. Participants will then practise entering and editing data, moving and copying formulas, understanding cell references, using common functions, formatting worksheets, preparing documents for printing and working with graphics and screenshots.Sessions run from 9am to 5pm at our Puchong training centre, with practical, hands-on exercises. 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
https://edge.denison.edu/blog/why-every-entry-level-job-in-2026-requires-excel-skills-and-how-to-build-them-fast

Learning Outcomes

  • Navigate worksheets and understand core spreadsheet terminology and the Excel environment
  • Enter and edit text, values, formulas, and pictures
  • Move and copy data and formulas, and work confidently with absolute and relative references
  • Insert and delete ranges, rows, and columns, and use simple functions including AutoSum
  • Apply basic formatting techniques, including conditional formatting
  • Prepare and print worksheets correctly, and manage large workbooks
  • Use basic graphics tools conditional formatting with graphics, SmartArt, and screenshots

Who is it for

  • Absolute beginners in Microsoft Excel
  • Engineers and administrators who need to be more proficient in Excel to get their job done
  • Anyone with at least one year of general Windows experience but little to no Excel background
  • Staff preparing to move on to Excel Intermediate and Advanced

Course outline

Module 1

Getting Started with Microsoft Excel
  • Introduction to spreadsheet terminology
  • Understanding the Microsoft Excel environment
  • Getting help in Excel
  • Navigating a worksheet
Module 2

Entering and Editing Data
  • Entering and editing text and values
  • Entering and editing formulas
  • Working with pictures
  • Saving and updating workbooks
Module 3

Modifying a Worksheet
  • Moving and copying data
  • Moving and copying formulas
  • Understanding absolute and relative cell references
  • Inserting and deleting ranges, rows and columns
Module 4

Using Functions
  • Entering functions
  • Using AutoSum
  • Working with other common Excel functions
Module 5

Formatting
  • Applying text formatting
  • Formatting rows and columns
  • Applying number formatting
  • Using conditional formatting
  • Exploring additional formatting options
Module 6

Printing
  • Preparing worksheets for printing
  • Understanding Page Setup options
  • Printing worksheets
Module 7

Module 7: Graphics and Screenshots
  • Using conditional formatting with graphics
  • Working with SmartArt graphic
  • sInserting screenshots

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.

  • 1 Dec 2026 - 1 Dec 2026 9:00 AM – 5:00 PM · Face-to-face
    Book seat
  • 6 Jan 2027 - 6 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

Tools stack

Software & tools used in this course
  • 01
    Laptops Fully equipped laptops with genuine Microsoft licenses are provided for use throughout the training.

Frequently asked questions

01 Is Microsoft Excel Basics suitable for complete beginners?

Yes. Our Microsoft Excel Basics Training Course is designed for beginners with little or no prior Excel experience. The course introduces essential spreadsheet skills, including data entry, basic formulas, functions, formatting and worksheet management. Basic familiarity with using a Windows computer is recommended.

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

You will learn how to navigate Excel worksheets, enter and edit data, create basic formulas, use AutoSum and common functions, format spreadsheets, manage rows and columns, and prepare worksheets for printing. The course also introduces conditional formatting, SmartArt graphics and screenshots.

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

Microsoft Excel Basics introduces essential spreadsheet skills, formulas and formatting. Microsoft Excel Intermediate builds on these foundations with more complex spreadsheet techniques, while Microsoft Excel Advanced focuses on higher-level Excel capabilities. Each level takes one day, allowing participants to progress according to their existing skills.

04 Where is the Microsoft Excel 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.

05 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.

06 Will I receive a certificate after completing the Microsoft Excel Basics course?

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

07 What language is the Microsoft Excel Basics course conducted in?

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

08 Is the Microsoft Excel Basics training HRD Corp claimable?

Yes. Our Microsoft Excel Basics 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.

09 Can I attend Microsoft Excel Basics 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.

10 Can I repeat the Microsoft Excel Basics course if I need more practice?

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

11 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