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]