Microsoft Excel for Beginners

This 1-day hands-on training introduces the core features of Microsoft Excel and is designed for new users. It provides a strong foundation in workbook management, data entry, basic calculations, formatting, and data organization. Through guided exercises and practical activities, participants will gain confidence in using Excel for everyday office and business tasks.

The objectives of the programme are to:

1. Understand the Excel interface and basic navigation.
2. Enter, edit, and manage data in worksheets.
3. Use basic formulas and functions for calculations.
4. Format cells, rows, and columns to improve readability.
5. Apply data organization tools such as sorting and filtering.

Module 1: Getting to Know Excel

1. Starting Excel and understanding the workbook layout
2. Using the Ribbon, Formula Bar, and Status Bar
3. Opening, saving, and closing workbooks
4. Navigation techniques (keyboard and mouse)

Module 2: Data Entry and Editing

1. Typing and editing text, numbers, and dates
2. Using Undo, Redo, and AutoCorrect
3. Autofill, series fill, and Flash Fill basics

Module 3: Working with Ranges, Rows and Columns

1. Selecting cells, ranges, rows, and columns
2. Inserting and deleting rows and columns
3. Hiding and unhiding worksheet parts

Module 4: Basic Formulas and Functions

1. Understanding Excel formulas
2. Using SUM, AVERAGE, MIN, MAX
3. Introduction to cell referencing (relative and absolute)

Module 5: Formatting Worksheets and Conditional Formatting

1. Font styles, alignment, borders, and fill colours
2. Number formatting: currency, date, percentage
3. Using Format Painter
4. Highlight duplicates, top/bottom values
5. Apply colour scales and data bars
6. Practice: Visualize performance and highlight outliers

Module 6: Sorting and Filtering

1. Sorting single and multiple columns
2. Using basic filters to display specific data
3. Creating and formatting tables

Module 7: Worksheet Management

1. Renaming, moving, copying, inserting, and deleting sheets
2. Grouping worksheets
3. Freezing panes and splitting windows

Module 8: Final Activity and Recap

1. Create a simple workbook for sales or attendance
2. Apply formatting, formulas, sorting, and filtering
3. Recap key learning points with a guided quiz

We’d happy to help.
Feel free to talk to us today, however most suitable for you.

Mobile call: +603 – 7493 6868

WhatsApp: +6018 – 380 5878

Email: enquiry@apexitraining.com.my

Website: www.apexitraining.com.my