Upcoming Dates
- 21 April 2025, Monday (Online)
This hands-on course focuses on data cleaning, validation, analysis, visualization, and automation. Learn essential functions, pivot tables, and charts to enhance data accuracy and efficiency in your daily tasks. With step-by-step guidance and real-world exercises, this program empowers you to make data-driven decisions with confidence.
Learning Objectives:
Upon successful completion of this course, participant will be able to:
- Remove unwanted spaces and characters, find and replace characters, split text into columns, and eliminate duplicates
- Ensure valid data entry, identify invalid data, and create alert and error messages
- Utilize statistical, text, and date functions to analyze and manipulate data
- Create basic chart types, change chart styles and types, and modify chart elements for better data visualization
- Use conditional formatting rules and sparklines to highlight and visualize data trends
- Create and modify pivot tables, sort and filter pivot data, and utilize pivot charts and slicers for advanced data analysis
🔹 14 years Proven Expertise: Trusted by professionals across industries.
🔹 Expert Trainers: Real-world industry experts bring practical insights to every session.
🔹 HRDC Claimable: Maximize your training budget with fully claimable courses.
🔹 Interactive Learning: Hands-on practice, live demos, and real-life case studies.
🔹 Flexible Options: Choose between classroom or virtual sessions to fit your schedule.
🔹 Results That Matter: Equipping you with practical skills for measurable professional growth.
Course Agenda
MODULE 1: DATA CLEANING AND PREPARATION
- Removing Unwanted Spaces and Characters (e.g. TRIM, CLEAN)
- Finding and Replacing Characters (e.g. FIND, LEN, SUBSTITUTE)
- Splitting Text with Text to Columns
- Removing Duplicates
MODULE 2: DATA VALIDATION
- Ensuring Valid Data Entry
- Identify Invalid Data
- Creating Alert Message and Error Messages
MODULE 3: APPLYING FUNCTIONS
- Statistical Functions (e.g. COUNT, SUM, AVERAGE, MAX, MIN)
- Text Functions (e.g. UPPER, LOWER, PROPER, LEFT, RIGHT, MID)
- Date Functions (e.g. TODAY, DAY, MONTH, YEAR, DATE)
MODULE 4: CHARTS FUNDAMENTALS
- Basic Chart Types (Pie, Column and Line Charts)
- Changing Chart Style and Type
- Modifying Chart Elements
MODULE 5: CONDITIONAL FORMATTING AND SPARKLINES
- Creating Highlight Cells and Top/Bottom Rules
- Using Data Bars, Color Scales, and Icon Sets
- Visualising Trend with Sparklines
MODULE 6: PIVOT TABLES AND PIVOT CHARTS
- Creating and Modifying a Pivot Table
- Sorting and Filtering a Pivot Table
- Pivoting Charts and Slicers
Program Methodology:
Interactive lectures. hands-on exercises, case studies and group discussions. Participant will be given sample datasets for step-by-step guides exercises.
Value
- Efficiency: Save time and boost productivity by mastering intermediate Excel features.
- Confidence: Tackle complex data analysis tasks with ease.
- Insightful Decisions: Leverage data visualization and analysis tools to make informed decisions.
- Professional Growth: Enhance your resume with valuable Excel skills.
Target Audience
This course is designed for:
- Professionals who work with data need to improve their data management and analysis skills.
- Team Leads or Managers who rely on data for decision-making and reporting.
- Small Business Owners looking to optimize their operational efficiency.
- Anyone Familiar with Excel Basics ready to take their skills to the next level.
Course Pre-requisites
To ensure participants get the most from this course, the following prerequisites are recommended:
- Basic Understanding of Microsoft Excel
a. Familiarity with Excel’s interface and navigation.
b. Ability to create, edit, and save workbooks. - Foundational Skills
a. Basic knowledge of formulas and functions (e.g., SUM, AVERAGE).
b. Experience with simple formatting (e.g., font size, bold, cell borders).
c. Understanding of basic data sorting and filtering. - Prior Course Attendance (Optional)
a. Completion of a beginner-level Excel course or equivalent experience. - Requirement
a. LAPTOP and MS Excel 365 is required during the training.
Special Offers
🎁 Early Bird Offer: RM750.00
(Normal Price: RM1,000.00)