Excel Data Analytics

Medium of Instruction:

Cantonese, supplemented with English materials

Overview

Overview

Excel is at the heart of many businesses ’ data operations and many people’s daily life. While it’s a widely used tool, many people spend an enormous amount of time on tedious and conventional spreadsheets. If you know the right tricks, you could organize, automate and analyze large datasets much more quickly, without writing complex formulas and programming. This live online program will take the Excel functions you already know to the next level so that you can immediately use them on the job, and be more productive and efficient.

Course Highlights

  • Transform lots of data to reports on Excel quickly
  • Save time in consolidating and reconciling data in reporting
  • Consolidate multiple files with multiple worksheets under multiple folders with small file size
  • Automate processes and refresh with a single click
  • Fast spreadsheet processing even with lots of data
  • Absolutely no programming experience is needed
  • No VBA coding or Macro recording

Learning Experience

  • Learn from industry-seasoned data scientist 
  • Real-world examples
  • Live online learning – follow along and ask questions as we present
  • Hands-on exercises – learn through individual work and feedback

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

Course Details

Module 1 - Mastering Management Reports with New Excel Functions

Duration: 1 day

Language: Cantonese, supplemented with English materials

Teaching Mode: Live Online

 

Module 2 - Excel Training on Huge Data Consolidation

Duration: 2 days

Language: Cantonese, supplemented with English materials

Teaching Mode: Live Online

What You Need for the Course

Please come prepared with laptop equipped with Microsoft 365 Excel (English Ver)

Module 2 only: Activate Power Pivot on the Excel Data ribbon before class

Delivery Options (Blended Solutions)

  • 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