Meet Our Faculty Events & Seminars Contact Us
Excel Data Analytics

Financial Training

Excel Data Analytics

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 Highlight

  • 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 & Fee

Module 1 - Mastering Management Reports with New Excel Functions

Date: 16 May 2021 (Sun)

Time: 9:30am - 12:30pm ; 1:30pm - 5:30pm

 

Module 2 - Excel Training on Huge Data Consolidation

Date: 23 & 30 May 2021 (Sun)

Time: 9:30am - 12:30pm ; 2:00pm - 5:00pm

 

Language: Cantonese, supplemented with English materials

Teaching Mode: Live Online

 

Fees: 

  • Early Bird Price (Enroll by 25 Apr) : Module 1: $900, Module 2: $2,200
  • Regular Price: Module 1: $1,300, Module 2: $2,600

FAQ

What do I need?


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