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]