Microsoft Excel – Basic To Intermediate (Remote Online Training)

OVERVIEW

Microsoft Excel is one of the most powerful and widely used tools for data analysis, visualisation, and business management. It enables users to efficiently organise, calculate, and evaluate quantitative data, making it an essential tool for businesses across industries. From tracking financial records and managing employee work hours to conducting complex data analysis and generating reports, Excel provides a robust platform that enhances productivity and streamlines workflows. Employees who develop proficiency in Excel can significantly improve their efficiency,  allowing them to work smarter, reduce manual effort, and increase accuracy in their daily tasks.

This two-day training programme is designed to take participants from a basic to an intermediate level of proficiency in Microsoft Excel. It is tailored for individuals who have little to no prior experience with Excel, as well as those looking to strengthen their foundational skills and advance to more complex functionalities. The course provides a structured learning approach through hands-on exercises and guided instruction, ensuring participants gain a strong command of Excel’s core features and develop the ability to work with spreadsheets more effectively. Throughout the training, participants will explore key concepts such as spreadsheet navigation, data entry, formatting, and basic formulae to automate calculations and improve efficiency. They will also learn techniques for managing data more effectively, including sorting, filtering, and organising datasets for better analysis. Additionally, the course will introduce methods for visualising data through charts and graphs, as well as intermediate functions such as conditional formatting, lookup functions, and data validation to enhance productivity.

By the end of this training, participants will have a solid understanding of Excel’s capabilities and be able to create professional, well-structured spreadsheets that support various business applications. They will gain confidence in applying formulae, generating reports, and using visualisation tools to present data in a meaningful way. As businesses increasingly rely on data-driven decision-making, proficiency in Excel provides a competitive edge, ensuring employees can contribute more effectively to organisational success.

LEARNING OUTCOMES

By the end of this workshop, participants will be able to:

√ Navigate and manage worksheets efficiently using Excel’s interface and shortcuts.
√ Understand & apply different types of cell referencing.
√ Enter, edit, and organise data within a worksheet.
√ Adjust row heights and column widths for improved data presentation.
√ Format text, align content, and apply indentation for better readability.
√ Insert and customise shapes, add text within shapes, and apply fill and font colours.
√ Add, resize, and edit images to enhance spreadsheet visuals.
√ Create and manage Excel formatted tables to structure data effectively.
√ Apply various formatting techniques, eg. date, time, currency, & text formatting.
√ Use conditional formatting to highlight important data points.
√ Create different types bar, column, line, & pie to visualise data effectively.
√ Customise charts by adding titles, labels, and formatting elements.
√ Understand and use Excel operators in formulas for basic calculations.
√ Apply fundamental functions such as SUM, COUNT, and AVERAGE to analyse data.
√ Write and troubleshoot basic formulas for accurate calculations.
√ Use AutoFill and Flash Fill to automate data entry.
√ Summarise and interpret data insights using formulas and visual representations.
√ Identify and correct common formula errors to ensure data accuracy.
√ Apply all learned skills in a practical mini-project, demonstrating competency in spreadsheet creation, formatting, formula application, and data analysis.

WHO SHOULD ATTEND?

This course is ideal for office workers, administrators, executives, and beginners seeking to build a strong foundation in Microsoft Excel to manage and analyse data effectively.

COURSE BENEFIT

Organisations benefit greatly from a workforce skilled in Excel, as it enables better communication of data-driven insights to senior management and key stakeholders. Whether used for financial modelling, reporting, or decision-making, Excel plays a critical role in helping businesses make informed choices based on real-time data.

TRAINING METHODOLOGY

This course adopts a hands-on, practical approach, combining interactive lectures, guided exercises, and live demonstrations. Participants will engage in step-by-step tutorials, and structured practice sessions to reinforce learning. A modular approach ensures progressive skill-building, while Q&A sessions and practical applications help translate knowledge into workplace efficiency.

PRE-REQUISITES 

Participants should have basic computer literacy, including file management and navigation skills. No prior Excel experience is required, making this course ideal for beginners. Those with some exposure to Excel can strengthen their skills. Access to Microsoft Excel (latest version or Microsoft 365) is recommended for hands-on practice.

TRAINING PREPARATION

Participants must have a laptop or computer with pre-installed Microsoft Excel, a stable internet connection, a functional camera, microphone, and speakers for this online session conducted via Zoom.

TRAINING DURATION

Full 2 days training  (9:00 am-5:00 pm)

HRD CORP REGISTERED PROGRAM ID NOS

10001246469

PUBLIC PROGRAM COURSE FEE
Single Registration  – RM 1,150.00 nett per participant

Group Registration – RM 850.00 nett per participant

(For 4 participants or more from the same organisation)

(The fee covers training materials, supplementary notes, a detailed training report with assessment and a Certificate of Completion)

IN-HOUSE TRAINING ENQUIRY

For more information regarding our In-House/ Public Program courses, please email us your inquiry at sales@progresslink.com.my
or to speak to our Sales Consultant at + 604- 297 6881 or 011-1289 6881.

For public program schedules, please visit our website: www.progresslink.com.my

Register with us today! Training fees are eligible for  HRD Corp Claimable Courses scheme.

DOWNLOAD NOW!

Please CLICK HERE to download this course details & registration form in PDF format

or

REGISTER ONLINE