Ā
Master Excel & 20 Years of Business Analytics Logic in Just 7.5 Hours
The "PrACTice" Framework: A systematic, 6-step blueprint designed for non-technical professionals to turn messy data into executive-level insights.
GET INSTANT ACCESS $297IT'S TIME TO STOP STRUGGLING WITH EXCEL
Do You Recognize These?
-
Spending 4 hours on a report that should take 15 minutes?
-
The 'Fear of the Broken Formula' when presenting to your boss?
-
Feeling like you know the functions, but don't know how to build the system?
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.
GET INSTANT ACCESS $297WHY 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
GET INSTANT ACCESS $297
WHY THIS COURSE
How Is This Course Different?
-
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.
-
Proven 6āStep āPrACTiceā Framework
Everything fits into a clear, memorable system you can apply immediately.
-
Understand the "WHY" and "WHEN" to use functions
Master the logic ā not just the steps ā so you never forget.
-
80/20 Rule - SimplicityĀ
I teach the top 20% of functions that solve 80% of realāworld problems.
-
"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.
GET INSTANT ACCESS $297WHAT'S INSIDE?
Course Curriculum
(The 6-STEP System)
Ā
STEP 1: Purpose
4 mins
Purpose: The Strategic Mindset (Stop wasting time on the wrong data).
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
Right Data: Clean & Structured (The 40 functions that do 90% of the work).
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
Analyze & Spotlight: Finding the "Why" (XLOOKUP & Dynamic Arrays).
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
Analyze & Spotlight:Ā Finding the "Why" (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
Analyze & Spotlight:Ā Finding the "Why" (Trends and 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
Drill-down mastery (Pivot Table power-user secrets).
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
Solutions: The Executive Summary (How to communicate findings).
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
Evaluation: The Performance Dashboard (Build it once, use it forever).
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
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.
GET INSTANT ACCESS $297WHAT'S INSIDE ?
Try The OS For 30 Days.
If you haven't built a better model or saved at least 5 hours of work, Iāll give you a 100% refund. No questions asked.
-
Excel Analytics OSĀ MasterclassĀ ($599 Value)
-
Bonus 1: 3-Function Dashboard Masterclass ($199 Value)
-
Bonus 2: 200+ Power Tips Library ($199 Value)
-
Bonus 3:Ā Lifetime AccessĀ ($99 Value)
-
Bonus 4: 85+ Practice Worksheets & Templates (Priceless)
Total Real World Value: $1096+
Exclusive Enrollment :Ā $297
GET INSTANT ACCESS $297
Guaranteed Results With Zero Risk
USD $297
One-Time payment. ZERO risk. 30-day money back guarantee. Lifetime access and ongoing updates.
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.
GET INSTANT ACCESS $297
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
Ā
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
Ā
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
Ā