Microsoft Excel: Introduction to Formulas & Functions
"In Excel, every formula is a step towards clarity. Embrace the journey of learning, and watch your data come to life"
Join Online training Within Half day
From Your Home (Zoom Application)
DATE: 4 May 2025 (Sunday)
Duration
Half Day
time
- 9AM - 1PM
Seats Availability
- 50
Zoom Meeting
Individual Fee
RM 90
HRDCorp: RM200
- VENUE / PLATFORM
- Meals Provided?
- NO
- PC/Laptop Provided?
- NO
- oUR Instructor
Coach Asyraf
(Microsoft Office Specialist: Expert)
Lead Trainer, Data & Business Intelligence Consultant
Microsoft Office Specialist: Expert (Office 2019 & 365 Apps)
Microsoft Certified: Power BI Data Analyst Associate
Microsoft Certified Trainer (2020-2025)
PREREQUISITES
Basic familiarity with using computers.
Familiarity with fundamental spreadsheet concepts.
Language
50% English & 50% Bahasa Melayu
Certification
Certificate of Participation by Training Provider
Training Overview
In today’s data-driven environment, mastering formulas and functions in Microsoft Excel is essential for efficient data analysis and reporting. This one-day training provides a structured approach to understanding and applying Excel formulas and functions, ensuring participants gain practical skills to enhance their productivity. Through hands-on exercises, learners will develop confidence in creating, editing, and managing formulas, improving their ability to analyze and manipulate data effectively.
This course covers fundamental concepts such as arithmetic operations, cell references, and summary functions like SUM and AVERAGE. Participants will also learn to work with named ranges, Excel tables, text functions, and data validation rules. Additionally, they will explore formula auditing techniques to troubleshoot errors and improve accuracy in their spreadsheets. By the end of the training, learners will be equipped with essential skills to streamline their Excel workflow and enhance data management capabilities.
Course Objectives
At the end of the Course, participants will be able to:
- Understand the difference between formulas and functions in Excel.
- Create and edit formulas using arithmetic operators and cell references.
- Apply absolute and relative references to enhance formula flexibility.
- Use fundamental summary functions such as SUM, AVERAGE, and COUNT.
- Audit worksheet formulas by tracing precedents, dependents, and error indicators.
- Utilize AutoSum and conditional summary functions for efficient data analysis.
- Manage and reference named ranges and Excel tables in formulas.
- Work with text functions to manipulate and clean data effectively.
- Apply data validation rules to restrict and control data entry.
- Troubleshoot and resolve common Excel formula errors using built-in tools.
Course Tentative
TIME | MODULES |
|---|---|
8:30 AM – 9:00 AM | REGISTRATION |
9:00 AM – 9:30 AM | Module 1: Introducing Excel Formulas and Functions |
9:30 AM -10:00 AM | Module 2: Creating Basic Summary Functions |
10:00 AM – 11:00 AM | Module 3: Managing Named Ranges and Excel Tables |
11:00 AM – 12:00 PM | Module 4: Managing Data in Excel |
12:00 PM – 1:00 PM | Module 5: Auditing Worksheet Formulas |
Note: The course duration is a guideline. Course topics and duration may be modified by the instructor based on the knowledge and skill level of the course participant.
Who Should Attend?
This course is ideal for:
Students |
Educators
Office Administrators
Entrepreneurs and Business Owners
Government / Business Professionals
View Course Outline
1.1 Familiarize yourself with functions and formulas
1.2 Create a formula
1.3 Introduce arithmetic operators
1.4 Use cell references in formulas
1.5 Use absolute and relative references in formulas
1.6 Copy and paste formulas and values
1.7 Edit a formula
2.1 Create a SUM or AVERAGE formula
2.2 Create an AutoSum formula
2.3 Create formulas to count cells
2.4 Create formulas to summarize cells conditionally
2.5 Summarize data on the status bar
3.1 Summarize data using named ranges
3.2 Edit and delete named ranges
3.3 Summarize data using an Excel table
3.4 Refer to Excel table cells in formulas
4.1 Manage data using text functions
4.2 Separate data using Flash Fill
4.3 Create data validation rules
4.4 Restrict data entry using lists
5.1 Trace formula precedents and dependents
5.2 Evaluate Excel formulas step by step
5.3 Identify and trace errors
5.4 Manage Excel formula error indicators
Training Packages
e-Books
Exercise Files
Tutorial Videos
Lifetime Group Support
Training Video Recording
How to Register
*** Note: Course content and schedule are subject to minor adjustments based on the needs and skill levels of participants.
