EMPOWERUS

Talk To Our Course Advisor

EMPOWERUS

Excel Training Program: Data Management and Analysis (Intermediate)

Learn to organize, analyze, and visualize data with intermediate Excel tools including functions, conditional formatting, and pivot tables.

★ 4.5 average course rating
6 practice exercises
123 hours of content
Empowerus Excel Training Intermediate

Objectives

1

Apply advanced formulas and functions for in-depth data analysis.

Course content ›
2

Create dynamic reports with PivotTables, PivotCharts, and slicers.

Course content ›
3

Automate repetitive tasks and build professional dashboards.

Course content ›

Course Content

  • Logical functions: IF, AND, OR, nested IFs

  • Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH

  • Text functions: LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN

  • Date functions: TODAY, EOMONTH, DATEDIF

  • Data validation for clean datasets

  • Conditional formatting for insights at a glance

  • Removing duplicates and handling missing values

  • Using Flash Fill to streamline data entry

  • Grouping, filtering, and calculated fields in PivotTables

  • Using slicers and timelines for interactive reporting

  • Creating PivotCharts for visual analysis

  • Best practices for structuring PivotTable source data

  • Introduction to recording and running macros

  • Assigning macros to buttons for easy access

  • Automating repetitive processes

  • Understanding macro security

  • Combining charts, PivotTables, and slicers

  • Designing interactive dashboards

  • Applying design principles for readability and impact

  • Publishing and sharing reports securely

Learning Outcomes

  • • Confidently use advanced formulas and functions for data analysis.
  • • Manage and clean large datasets effectively.
  • • Create interactive PivotTables, PivotCharts, and slicers.
  • • Automate tasks with macros for improved efficiency.
  • • Build professional dashboards for decision-making and reporting.

Inspiring growth and success through engaging learning experiences.

Company

Quick Links

Contact

+6016-6658527

empowerus@syncovis.world

160-4B, Batu 3 1/2,
Jalan Klang Lama,
58100 Kuala Lumpur
Wilayah Persekutuan Kuala Lumpur

Copyright © 2025 All Right Reserved