Master Microsoft Excel Course and Excel Training in 3 days

Microsoft Excel is the most recognised spreadsheet program with many functions and diverse applications. But to maximise its use, skills and experience are required. For example, if you want to turn raw data into insights, present your data in compelling ways or create trend predicting forecasts, then you need to master Microsoft Excel.

The mastery of Microsoft Excel will also help you cut down on workload and be efficient in the workplace. The majority of employers expect you to be proficient in Excel before they hire you.

At the CAD Training Centre, our number one goal is to enable our students to implement the skills immediately at the workplace or business.

Excel class by cadtraining

Find the Right Excel Course for You

We offer three levels of Excel training, and you can take them one at a time or all together to build your skills step by step. Perfect for anyone looking to get better at Excel!

Explore Our Three Levels of Excel Courses!

Microsoft Excel Basics
Microsoft Excel Intermediate
Microsoft Excel Advanced

We  offer short courses that cover everything to know about Excel and provide practical skills for staying competitive at the workplace or business.

Excel Dashboard, Power Query & Power Pivot – 2 days

Excel VBA & Macro – 2 days

         Excel Power Business Intelligence (Power BI) – 2 days

Microsoft Excel Price List

CoursesNormal PriceCurrent Physical PromotionCurrent Online Promotion
CCD Points
Microsoft Excel Basics (1 day)RM 950RM 570 RM 52510 CCD Points
Microsoft Excel Intermediate (1 day)RM 1050 RM 670 RM 595
10 CCD Points
Microsoft Excel Advanced (1 day)RM 1150 RM 770 RM 64510 CCD Points
MS Excel Power Pivot, Power Query and Dashboards (2 days)RM 2450RM 1890
RM 1890-
MS Excel Visual Basics for Application (Macro) (2days)RM 2450RM 1890RM 1890-
Power BI Desktop Essentials RM 2800RM 1890RM 1890-

** Free Repeats for Physical Class **

Microsoft Excel Basic

Learn the basics of Excel, from data entry and simple formulas to creating charts. Perfect for beginners who want to get start with Excel!

Who is it for: The course is for a complete beginner and has little or no working knowledge of Microsoft Excel.

Duration: 1 Day (10 CCD Points)


Microsoft Excel Basic Course Outline

Module 1 Getting started with Microsoft Excel

•Spreadsheet terminology
•The Excel environment
•Getting help
• Navigating a worksheet
Module 2Entering and editing data

•Entering and editing text and values
•Entering and editing formulas
•Working with pictures
• Saving and updating workbooks
Module 3Modifying a worksheet

•Moving and copying data
•Moving and copying formulas
•Absolute and relative references
•Inserting and deleting ranges, rows, and columns
Module 4Using functions

•Entering functions
•Auto Sum
•Other common functions
Module 5Formatting

•Text formatting
•Row and column formatting
•Number formatting
•Conditional formatting
•Additional formatting options
Module 6Printing

•Preparing to print
•Page Setup options
•Printing worksheets
Module 7 Graphics and screenshots

•Conditional formatting with graphics
•SmartArt graphics
•Screenshots

     


      2) Microsoft Excel Intermediate

      In this course, we will explore functions and uses, such as working with multiple worksheets, personalization, data control, complex functions, automation and more.

      Who is it for: This program is for anyone with Basic Excel knowledge who wants to learn more and improve their skills.

      Duration: 1 Day (10 CCD Points)

       

       


      Microsoft Excel Intermediate Course Outline

      Module 1 Formulas and Functions

      • Text Functions
      • Date Calculation
      Module 2Data Consolidate

      • Consolidate data within same workbook
      • Consolidate data from multiple workbooks
      Module 3Data Validation

      •Apply Data Validation
      • Types of validation criteria
      •Apply Data Validation
      • Setting meaningful Alert Message
      • Provide friendly Input Message
      • Using Formula in validation
      • Creating Own Drop Down
      • Removing Data Validation

      Module 4Database (table)

      •Sorting Database List
      • Using the Text to Columns Feature
      •Using Advanced Filters
      Module 5Conditional Formatting

      •Highlight Top 10 Numbers
      • Using Data Bar
      •Using Icons instead of numbers
      • Adding a Conditional Format
      • Changing a Conditional Format
      • Creating a Custom Format
      • Using Own Formula
      • Delete a Conditional Format

       


      Microsoft Excel Advanced

      This course focuses on mastering Microsoft Excel, covering advanced functions, macros, and integrated Office applications.

      Who is it for: This Excel training is ideal for those looking to advance their skills and become an expert or power user in Microsoft Excel.

      Duration: 1 Day (10 CCD Points)


      Microsoft Excel Advanced Course Outline

      Module 1 What if analysis

      • Using Scenario Manager
      • Creating and editing scenarios
      • Creating a scenario report
      Module 2Data Tables

      • The single variable data table
      • 2 variable data table
      • Adding additional formatting
      Module 3 Working with Outlines

      • Applying an outline
      • Automatic outlining
      • Displaying and collapsing levels
      • Modifying outline settings
      •Creating subtotals


      Module 4Analysing data with pivot table

      • Creating Pivot Table
      • Defining the source range
      • Inserting, moving and deleting fields
      • Showing and hiding fields
      • Grouping and ungrouping fields
      • Renaming fields
      •Defining field properties
      • Formatting a pivot table
      • Refreshing a pivot table
      Module 5Index and Match

      • Formatting a pivot table
      • Refreshing a pivot table

      REGISTER NOW

       

      FAQ

      1.What are you class timings?

      Our class timings are from 9:00 AM – 5:00 PM, with regular breaks in between.
      Our lunch periods start from 1:00 PM – 2:00 PM.

      Upon registrations our team will provided each student  RM15 cash voucher that can be used for lunch.

       

      2.Do You Offer Excel Classes on Weekends?


      We usually conduct the courses on weekdays. However, we also offer weekend classes for part-timers with office-hour jobs and those unable to attend the weekday sessions.

      For more info do contact us for more details on the weekend class.

      See our training schedule :

      View Schedule

      3. Who Should Join Our Excel Course??

       

       

            • Anyone looking to improve Excel skills for better data management.
            • Professionals needing Excel for productivity and data accuracy.
            • Job seekers wanting to boost their resumes with Excel knowledge.
            • Small business owners managing finances and sales data.
            • People in marketing, finance, sales, accounting, and data analysis.
            • Students and fresh graduates preparing for future careers.

      4.Is Excel easy to learn? 

      Absolutely. Furthermore, we design the courses for attendees who come with absolutely no prior knowledge or experience in Microsoft Excel or other spreadsheet programs. 

      5.How long does it take to learn Excel?

      We have three primary levels of Excel courses, and each takes up a day. The three levels are Basics, Intermediate and Advanced. 

      For students who wish to explore further, they can also choose the more advanced courses like Excel Data Analysis and Excel VBA & Macro which generally take two days each.

      6.Can I learn Excel in a day? 

      Yes, you can. Our Microsoft Excel Basics program only takes one day. 

      However, if the participants wish to master excel, it will take approximately 2-3 days to become an advanced user of Microsoft Excel.

      7.What are the trainings held?

      Our training center is in Bandar Puteri, Puchong, just a 4-minute walk from the Bandar Puteri LRT station. For  people who are driving, there are shaded parking areas  available nearby for only  RM5/day, and a multi story car park not to far away from our training center.

      8. Do I need to bring my laptop and what materials do you provided I ?

      Laptops aren’t required, but you can bring yours if you want to log in to your MyInvois portal.

      We also do provide a handbook for reference during the training.

      9. Do you do online training’s?

      Yes we do , Our online classes are held on platforms like Zoom. Lessons are designed for easy understanding, with hands-on exercises guided by our experienced trainers through screen sharing.

      10.Do you do In-house and Corporate Trainings?

      Yes ,We do offer in-house training for groups of 7 or more, either at your venue or online. Just give us a call at 03-80630414, and we’ll help with pricing and arrangements!

      We have conducted training for various companies such as TNB, Tesco, UTM, IGB Corporation Berhad, Boustead Naval Shipyard, Technip, FMC, MavCap, IOI Group, Talam, MKH Berhad, Omron Electronics, UCSI, Naza TTDI, Seremban Engineering Berhad, Gamuda Berhad, Yamaha, Sunway. Harbour Link Berhad, EA Holdings Berhad, LimKoKWing University, Taylors University, UPM, UTHM, Universiti Teknologi MARA, Nottingham University, Muhibbah Engineering.

      Why should you join CAD Training Centre?

      The Trainers

      Our trainers have around 7-15 years of coaching experience, and they are very versatile in teaching in the classroom, online or corporate environment. Our trainers conduct classes in an efficient and hands-on manner, so you’ll never find the course boring.

      MOF and CIDB Registered Provider

      We are a registered training provider with the Ministry of Finance, MOF and also CIDB

      HRDF Claimable

      We are accredited by the Human Resource Development Fund, HRDFAll our courses offered by us are  under the  HRDF claimable under the ‘SBL’ Khas Scheme.

      Conducive Learning Experience 

      Our classes are 70% practical and 30% theory for better learning. With small class sizes (12-15 students), trainers can give more personal attention

      What Participants Say

      We have trained many well-known companies and individuals who completed their course highly satisfied. We feel honoured to receive their encouraging feedback and positive reviews. Read our full excel training testimonials here.

      For our full list of trainings and to contact us, please click the button below.

      Contact Us  View Schedule

       

      WhatsApp chat