Excel Data Analytics

Medium of Instruction:

English/ Cantonese, supplemented with English materials

Overview

Overview

Excel remains the heart of business operations, yet many professionals spend 80% of their time on manual data entry and only 20% on analysis. This Excel Data Analytics course is designed to flip that ratio.
Learn to organize, automate, and analyze massive datasets without writing a single line of VBA code or complex programming. Whether you are in finance, marketing, or operations, this live online program takes your existing skills to a professional level, enabling you to deliver actionable business insights with a single click.
 

Course Curriculum & Modules

Module 1: Mastering Management Reports with Excel

  • Advanced Lookups: Move beyond VLOOKUP with XLOOKUP and AI-powered Smart Fill.
  • Dynamic Data Validation: Create interactive lists and advanced sorting filters to keep data clean.
  • Visual Storytelling: Enhance data visualization using conditional formatting and pivot charts.
     

Module 2: Power Query & Power Pivot for Huge Data Consolidation

  • Automated Data Cleansing with Power Query: Automate data cleansing— Transpose, Pivot, and Unpivot Data, Merge and Append Queries, Extract data with a parameter, Add a New Calculated Column, and auto-detect data types, etc.
  • Data Modelling with Power Pivot: Learn to build relationships between different data sources to create a sophisticated data model.
  • Introduction to DAX: Apply your DAX formulas to create fully automated, interactive dashboards that refresh with a single click

Why Choose Kaplan’s Excel Data Analytics Programme?

Why Choose Kaplan’s Excel Data Analytics Programme?

  • Zero Programming Required: Automate your workflow without VBA coding or Macro recording.

  • Handle "Big Data" in Excel: Learn to consolidate multiple files and worksheets that would normally crash standard spreadsheets.

  • Industry-Seasoned Trainers: Learn from data scientists who apply these "tricks" in real-world corporate environments.

  • Immediate ROI: Gain tools you can use on the job the very next day to increase productivity.

     

Who Should Attend?

  • Professionals who rely on Excel, including finance and accounting professionals, business leaders, sales, marketing, HR and operations who make sense of data and communicate its meaning to others
  • All levels looking for refresher

Flexible Delivery Options

At Kaplan, we understand the busy schedule of a professional. We offer:

  • In-house customized trainings
  • Face-to-face classroom delivery (large group, small group or one-on-one) at your premises or Kaplan campus 
  • Virtual classroom delivery (Live-online)
  • Private classes

Contact Us

Talk to our team and learn how Kaplan can help you meet your business objectives - 

 

Name: Ms Rowena Li

Title: Director, Business Development

Tel. : 2116 3183

Email: [email protected]

Salutation
Financial Markets
Accounting
Leadership and Professional Development
Language
IT and Technology
High Education
How did you know about Kaplan?

Clear All

Anytime, anywhere

Contact Us