Microsoft Excel (Basic Level)

Microsoft Excel is one of the most essential tools used in every organization for data management, reporting, and decision-making. The Microsoft Excel Basic program is designed to provide participants with a strong foundation in using Excel efficiently for everyday business tasks.

This 1-day training course introduces participants to the fundamentals of Excel — from understanding the interface, entering and editing data, to applying basic formulas, formatting worksheets, and creating simple charts. The course emphasizes practical, hands-on learning to ensure participants can apply these skills immediately in their work environment.

Through this program, participants will develop the confidence to manage and organize data accurately, present information clearly, and perform basic data analysis with greater productivity. The skills gained in this course serve as a stepping stone toward mastering more advanced Excel features and functions in future levels.

PM Advance’s training philosophy is to deliver not only theoretical understanding but also practical knowledge drawn from real-world applications. This approach ensures that participants can effectively translate what they learn into improved performance and measurable results in their workplace.

Training Benefits

• 1 Day of practical, hands-on classroom training conducted by an experienced trainer.
• HRDC Claimable Course under the HRD Corp Claimable Courses Scheme.
• Comprehensive training materials and step-by-step workbook provided.
• Interactive sessions with live demonstrations and guided exercises.
• Certificate of Completion issued by PM Advance Sdn. Bhd.
• Dedicated Q&A and post-training support to reinforce learning.
• Real-world examples and scenarios to help participants apply skills immediately at work.

Course Content

Lesson 1: OFFICE WORKSPACE BASICS

• Understanding the Basics of the Office Workspace
• Exploring the Office Backstage
• Mastering the Ribbon
• Customizing the Quick Access Toolbar
• Navigating Efficiently with Key Tips
• Utilizing the Status Bar for Productivity

Lesson 2: INTRODUCTION TO EXCEL 

• Unveiling the Power of Excel
• Defining the Scope of Excel and its Functions
• Exploring the Excel Window for Optimal Usage
• Mastering Cell Selection Techniques
• Working with Workbooks: Opening, Navigating, and Saving
• Understanding Efficient Workbook Management

Lesson 3: ENTERING AND EDITING DATA

• Efficient Data Entry and Management
• Techniques for Entering and Editing Text, Numbers, and Dates
• Leveraging AutoComplete and AutoFill for Speedy Input
• Copying, Moving, and Clearing
• Mastering the Art of Undo and Redo for Precise Data Handling
• Harnessing the Power of Data Search and Replacement

Lesson 4: FORMATTING DATA

• Precision Formatting Techniques
• Understanding the Basics of Formatting
• Applying Number and Font Formats
• Adjusting Cell Alignment and Styles
• Copying and Clearing Formats
• Mastering Effective Format Search and Replacement

Lesson 5: FORMATTING WORKSHEETS

• Optimizing Worksheet Layout and Design
• Managing Rows and Columns
• Optimizing Worksheet Elements
• Customizing Worksheet Display
• Streamlining Worksheet Organization