Courses & Languages 語言
Bundle Course - Excel Analytics OS+Tips+Dashboard 課程套裝 - Excel Analytics OS (繁體中文) 课程套装- Excel Analytics OS (简体中文)
 

Master Excel For Business & Data Analysis In One System

Tailored For Non-Technical Business Professionals.

Go From Any Level To Excel Master.

Cut The Fluff. Learn What Works. 

Grab The 20-Year Excel Logic System - Enroll Now
THE FIRST THING YOU SHOULD KNOW

You’re Learning Excel the Wrong Way—And It’s Costing You Productivity

  1. Inefficient Data Handling

    You spend 3–5x longer than others on the same data.

  2. Inaccurate result

    You waste 4x more time fixing errors than you should.

  3. Tedious Tasks

    You repeat mindless work that functions and tools could automate in seconds.

  4. Limited Career Growth

    You get promoted 2–3 years later than your peers.

  5. Poor Collaboration

    Excel is used by 1.2 billion people in 100+ countries. It’s the global language of business.

  6. Weak Problem‑Solving

    One smart tool beats 100 extra hours of manual work.

  7. High‑Risk Mistakes

    A tiny error can lead to bad decisions and damage your professional reputation.

  8. Over‑reliance On Others

    Waiting for help delays your work — this was my biggest motivation to improve.

Invest just 7.5 hours to master data analysis and reclaim massive time and value.

Grab The 20-Year Excel Logic System - Enroll Now
LET'S BREAK THROUGH IT

The Real Struggles You're Probably Facing Right Now

  • You memorize XLOOKUP & Pivot Table steps, but never understand why or when to use them
  • You can click tools randomly, yet cannot turn raw data into clear business decisions
  • You waste hours on repetitive manual work, falling behind colleagues in efficiency
  • You learn random tips from blogs & old videos, no systematic logic to follow
  • You freeze up when data scenarios change — your copied tricks stop working instantly
  • You feel stuck at work, slower in reporting, overlooked for promotions because of weak data skills
I understand—because I was once in your position. That’s exactly why I built this course.

And yes, you can completely turn things around after completing it.

Grab The 20-Year Excel Logic System - Enroll Now

WHY EXCEL ANALYTICS OS

Hi, I'm Sun.

 

I help you to master Excel for business data analysis. Simpler, smarter, and easier.

 
20 years ago, I thought Excel was easy. I took typical courses, clicked buttons, copied formulas, and followed step‑by‑step guides.

It felt simple… at first.

Then I got stuck — badly.

I realized using Excel for real business data was a completely different skill.

I struggled to consolidate data, hated repetitive manual work, couldn’t build analytic models, and barely created clear charts for management.

I underestimated how to apply Excel properly for business.

I wanted a systematic way to learn — but no one could teach me.

So I spent decades building my own proven blueprint for Excel mastery.

I don’t want you to waste years on the wrong path like I did.

That’s why I built this course.

If you want to know more on Excel Analytics OS Course, keep reading👇

----------------

Education:  MSc in Business Analytics, MSc in Management (Operation Management), BA in Marketing and Management, ADip in Marketing and Retail Management

Qualification:  Registered Lean Leader, RLL

Followers on Social Media:  260k (LinkedIn, FB, IG, Threads, TikTok, XHS, YouTube,) 

Favikon Creator's Ranking: #1 - Excel and Office Productivity (Hong Kong) 2025

Grab The 20-Year Excel Logic System - Enroll Now
Grab The 20-Year Excel Logic System - Enroll Now
WHY THIS COURSE

How Is This Course Different?

  1. 100% Focus On Business Data Analysis

    Excel isn’t just for data storage or basic math. My 20 years of experience helps you unlock real business value.

  2. Proven 6‑Step “PrACTice” Framework

    Everything fits into a clear, memorable system you can apply immediately.

  3. Understand the "WHY" and "WHEN" to use functions

    Master the logic — not just the steps — so you never forget.

  4. 80/20 Rule - Simplicity 

    I teach the top 20% of functions that solve 80% of real‑world problems.

  5. "0" Fluff and Focus on What Matters

    No filler, no gimmicks, no distractions — only what actually moves the needle.

This isn’t just another Excel course full of random functions.

It’s a structured system that gives you the exact skills you need for real business data.

Grab The 20-Year Excel Logic System - Enroll Now
WHAT'S INSIDE?

Course Curriculum
(The 6-STEP System)

 

STEP 1: Purpose
4 mins

Goal: Build a strong mindset to identify problems and opportunities.

First, we'll build a strong foundation by recognizing how crucial clarity is in your Excel projects. This ensures you're on the right track.

  • Where the project begins
  • Identify problems and opportunities
STEP 2: Right Data
1 hr 20 mins

Goal: Build strong foundation on data structure and business data cleansing.

Next, we'll learn about 40+ logical, lookup and text functions for business data structuring and cleansing, including:

  • Lookup functions: XLOOKUP / VLOOKUP / HLOOKUP / INDEX + MATCH
  • Logical functions: IF / IFS / IFERROR / AND / OR
  • Text split functions: TEXTSPLIT / TEXTBEFORE / TEXTAFTER / LEFT / MID / RIGHT
  • Text format functions: TEXTJOIN / CONCATENATE / TRIM / UPPER / LOWER / PROPER / TRANSPOSE / TEXT / VALUE
  • Find and replace functions: FIND / SEARCH / SUBSTITUTE
STEP 3A: Analyze numbers with formula
1 hr 15 mins

Goal: Spotlight findings and insights with formula.

Then, we'll learn 30+ date, math and statistic functions for business data analysis, helping us identify insights for informed actions, including:

  • Calculation functions: SUM / SUMIF / SUMIFS / SUBTOTAL / AGGREGATE / COUNT / COUNTA / COUNTIF / COUNTIFS / MIN / MINIFS / MAX / MAXIFS / TRIMMEAN / MODE / MEDIAN / RANK
  • Date functions: DATE / TODAY / YEAR / MONTH / DAY / WEEKDAY / WEEKNUM / EDATE / EOMONTH
  • Lookup functions: FILTER / SORT / SORTBY / UNIQUE
STEP 3B: Conditional Formatting
50 mins

Goal: Spotlight findings and insights with conditional formatting.

Besides functions, we'll also explore conditional formatting. This will help us learn how to highlight, format, and visualize findings effectively using conditional formatting.

  • Highlight cells rules
  • Top / Bottom rules
  • Data bars
  • Color Scales
  • Icon sets
  • New rules
  • Custom number format
STEP 3C: Trends and Charts
1 hr 15 mins

Goal: Spotlight findings and insights with charts.

But there's more to it. We'll also get into creating dynamic charts, to uncover trends and insights.

  • Line chart / Bar chart / Combo chart
  • Auto-updated and dynamic charts
  • Conditional alerts and highlights
  • Sparklines
STEP 4: Identify Root-Cause (PivotTable)
60 mins

Goal: Able to drill down root cause by using PivotTable and MGT tools. 

Once we complete Step 3 on analyzing numbers, we'll dive into the world of PivotTables and management tools. We'll use these tools to drill down into the data and uncover the root causes that drive our actions.

  • Symptom vs Root-Cause
  • Dragging rows / columns / values / filters
  • Useful features in PivotTable
  • Slicers and timeline
  • Technique for drill-down analysis
STEP 5: Create Solutions
18 mins

Goal: Well prepare and communicate the findings and insights to stakeholders.

Now, based on the root cause, it's time to create solutions. In this step, you'll learn how to craft actionable solutions by setting goals, organizing your projects, and communicating effectively.

STEP 6: Evaluation (Measure, Review, and Adjust)
1 hr 15 mins

Goal: Monitoring on-going performance through effective business dashboard.

Finally, we'll wrap it up by diving into creating a Pivot Dashboard to monitor the performance of your solutions. In this step, we'll cover the foundation and concepts of dashboards and delve into Pivot Charts.

  • Dashboard design and layout
  • Build business dashboard using PivotCharts
  • Charts and shapes controls
  • Comprehensive practice
Grab The 20-Year Excel Logic System - Enroll Now

Two Exclusive Bonuses (Value $398) 🎁

Bonus 1: Business Dashboard Masterclass (Value $199)
1 hr 30 mins

Goal: Build a business dashboard with only 3 functions in 1.5 hours

The course doesn’t end here.

You’ll take it one step further—learning how to build a clean, powerful business dashboard using just 3 core functions. No PivotTables. No PivotCharts. Just smart Excel.

Bonus 2: 200+ Excel Analytics Power Tips (Value $199)
3 hrs

Goal: Mastering an advanced business dashboard using only 3 functions

The course doesn’t end here.

200+ Tips and Tricks Power Pack isn't a one-time thing. It evolves with you, providing lifelong updates filled with practical tips, advanced applications, and expert tricks to keep you ahead.

Grab The 20-Year Excel Logic System - Enroll Now
WHAT'S INSIDE THE COURSE PACKAGE

One-Time Payment. No Monthly Fee. Lifetime Access All.

1. Excel Analytics OS Course (Value $499)

Learn 70+ functions through my 6-Step System to master Excel for business analysis.

2. Business Dashboard Masterclass (Bonus: $199)

Learn how to use only 'three functions' to create an insightful business dashboard in a simple way. I carefully design it in just 1.5 hours.

3. 200+ Analytics Power Tips (Bonus: $199)

200+ Tips and Tricks Power Pack isn't a one-time thing. It evolves with you, providing lifelong updates filled with practical tips, advanced applications, and expert tricks to keep you ahead.

Total Value: $897

GET INSTANT ACCESS $197

Guaranteed Results With Zero Risk

USD $197 (Special Bundle)

One-Time payment. ZERO risk. 30-day money back guarantee. Lifetime access and ongoing updates.

  • Signature Course Excel Analytics OS x 1 (Value $499)
  • 8 modules, 121 short lessons, 7.5 hours
  • 196 pages lesson slides and 85 practice worksheets
  • Bonus 1: 200+ Excel Analytics Tips with practice files (Value: $199)
  • Bonus 2: Masterclass - Creating Dashboard using only 3 functions (Value: $199)
  • Now support 16 languages with captions
START NOW WITH ZERO RISK. 30-DAY MONEY BACK GUARANTEE. NO QUESTION ASKED.

Students from 58 countries have enrolled! You're next!

Argentina, Australia, Austria, Azerbaijan, Brazil, Belgium, Cambodia, Canada, Cayman Islands, Chad, China, Denmark, Egypt, Estonia, Fiji, France, Germany, Greece, Hong Kong, India, Indonesia, Ireland, Isle of Man, Italy, Jordan, Kuwait, Lesotho,Libya, Malaysia, Malta, Mexico, Mozambique, Netherlands, New Zealand, Nigeria, Oatar, Oman, Pakistan, Panama, Philippines, Poland, Portugal, Romania, Saudi Arabia, Senegal, Singapore, Slovakia, South Africa, Spain, Sweden, Switzerland, Taiwan, Thailand, Turkey, United Arab Emirates, United Kingdom, United States, Venezuela.

Grab The 20-Year Excel Logic System - Enroll Now

Very good course. It was extremely efficient how Sun was able to provide so much insight into Excel's powerful tools in a course of 7.5 hours. Congratulations! I really appreciate you putting this course together.

_


Julio Ortiz, Fractional CFO

Student from United States

 

Grab The 20-Year Excel Logic System - Enroll Now

This course has helped me with my Excel analytical skills which I was hoping to build for years but didnt know where to start from. I am really grateful to Sun Lau for putting these together for their students, your little tips and tricks along the way are super helpful too. I highly recommend this course to anyone willing to learn or improve excel regardless of what level they are on. A big Thank you to Sun Lau.

_


Farah Fahad

Student from United Kingdom

 

Grab The 20-Year Excel Logic System - Enroll Now

I've finished Sun Lau's Excel Analytics OS course, without a doubt this course has made my vision of data analysis stronger and clearer, and I should also mention that the Excel Analytics OS course should be attended by those who expect more from themselves. Congratulations Sun Lau, the content has been marvellous for my personal and professional growth.

_


Paula Nogueira, Manager, Customer Service

Student from Portugal

 

Grab The 20-Year Excel Logic System - Enroll Now

Students Are Loving The Course:

More LinkedIn Followers Are Saying:

FAQ