Get 50+ Must-Know Excel Analytics Tips — FREE!
Grab this if you want a fast track to using Excel in real business settings. (Handpicked from my most-loved social posts)
If you're looking for structured learning to build real Excel confidence — read more 👇
Excel Analytics OS
Become an Excel Pro for Business Analysis—Fast. Just 7.5 Hours
Simpler, Clearer, No Fluff.
GET INSTANT ACCESS $149 (Limited-Time Offer)
THE FIRST THING YOU SHOULD KNOW
People Who Don’t Learn Excel Struggle In Business. It’s That Simple.
-
Inefficient Data Handling
You have to spend 3-5 times more than others to handle the same data set.
-
Inaccurate result
Do you know? You should probably spend 4 times as much time on the correction.
-
Tedious Tasks
You should repeat X times tedious tasks that can be quickly fixed by functions and features.
-
Limited Career Growth
Do you always get promoted 2–3 years later than your colleagues?
-
Difficulty in Collaboration
Excel is a language spoken by 1.2 billion users in over 100 countries. Isn't it one of the most important languages today?
-
Lack of Problem-Solving Abilities
One smart tool is worth more than a hundred helping hands. Agree?
-
Risk of Mistakes in Financial Planning
One minor mistake can lead to deadly decisions and can also harm your reputation.
-
Dependency on Others
It's okay if you can tolerate delays supported by others. <--- This is the key factor that pushes me to grow.
Devote just 7.5 hours to mastering data analysis, and you'll reclaim incredible value and time.
GET INSTANT ACCESS $149 (Limited-Time Offer)
Hi, I'm Sun.
I help you to become an Excel Pro for business analysis—Fast. Just 7.5 Hours. Simpler. Clearer. No Fluff.
20 years ago, I though learning Excel was easy. Joined a typical Excel course, navigated the ribbon, followed the steps, copied the formulas.
That's really simple. I mean, at the beginning.
But then, I got stuck again.
I realized that application was a different story, especially when it came to analyzing business data.
I found it hard to consolidate data from various sources, repeat boring manual tasks, had no idea how to build analytic models, and could barely create charts for management.
I underestimated the importance of mastering Excel applications.
I wanted to learn in a systematic way.
But the problem was that no one could tell me how to do it.
I spent decades figuring out my secret blueprint for learning Excel, and I hope you don’t have to go down the wrong path like I did.
That’s why I’m here to help.
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) 2024
GET INSTANT ACCESS $149 (Limited-Time Offer)
6-Step 'PrACTice' Framework Guides You to Success. 16 Language Captions.
Arabic, বাংলা, 简体中文, 繁体中文, English, Français, Deutsch, हिन्दी, Bahasa Indonesia, Italiano, 日本語, 한국어, Português, Русский, Español, اردو
WHAT'S INSIDE THE COURSE BUNDLE
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 hour
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 $149 (Limited-Time Offer)THE FIRST THING YOU SHOULD KNOW
How Is This Course Different?
-
100% Focus On Business Analysis
Excel isn’t just for storage or simple calculations—you’ll unlock invaluable value for your business.
-
Learning Through a Solid 6-Step 'PrACTice' Framework.
I put everything together in a solid "PrACTice" framework—making it easy to remember and apply.
-
Understand the "WHY" and "WHEN" to use functions
The key is understanding the logic behind it — that way, you’ll never forget.
-
80/20 Rule - Simplicity
I’ve carefully selected the most important 20% of functions that cover 80% of real-world scenarios—delivered concisely.
-
"0" Fluff and Focus on What Matters
Effective learning comes from to-the-point training — no fluff, no gimmicks, no distractions. Every word counts
Just 7.5 Hours for Big Rewards
Spend 7.5 hours on the Excel Analytics OS course, and unlock skills that save you time and open up new opportunities.
GET INSTANT ACCESS $149 (Limited-Time Offer)
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
EXCEL ANALYTICS OS COURSE
After Completing The Course, You Will
Become Excel Pro For Business Analysis.
100% Understanding of Proper Data Structure
Knowing the proper data structure ensures you won't start your project at a dead end.
Apply 6-Step to Analyze Business Data
You’ll learn how to structure your analytics project using my 6-step 'PrACTice' system.
Master 70+ Functions for Business Analysis
You'll master the most important 20% of functions, about 70 of them, for business analysis, which will give you 80% of the results.
Confidence — 80% of your audience will clearly grasp what you're presenting
You'll be able to present your data professionally. Impress your stakeholders and management with amazing Excel skills.
Connect 100% of what you know
After finishing the course, you'll be able to connect your knowledge and truly understand business analytics in the real world.
Yes, you'll master Excel in one simplifed course.
I don't overpromise, but I'm fully confident in helping you reach the next level.
GET INSTANT ACCESS $149 (Limited-Time Offer)WHO IS THE COURSE DEISGN FOR?
90% Of My Students Are Non-Technical Business Professionals
You Are The Right Person.
Finance and Accounting
AI is getting better. Learn to be a good business partner to stay ahead. Unlike just making financial reports neat and tidy, doing business analysis needs new skills with data to put together, look at, and share what you find and understand.
Business Development and Sales Management
Data always tells the truth. Learning Excel well helps you find problems and chances quickly in a changing business world by looking at the newest data.
Business Consulting
You'll learn to look at business data step by step, starting from 'Purpose,' 'Getting the Right Data,' 'Looking at it,' 'Finding out why things happen,' 'Figuring out what to do,' and 'Checking if it works.' This will make you better at giving advice to businesses.
Project Management
You're like the 'bridge' between different parts of a company. You need to be able to deal with and look at special, not-normal data from them to make sure the project is going well.
HR Business Partners
Knowing what the business wants and being able to talk to and persuade bosses using data from different places is really important. Get better at HR by getting really good at Excel.
This Simplifed Excel Analytics OS Is Your Transformer.
This course is tailored for non-technical business professionals, helping you reach the next level.
GET INSTANT ACCESS $149 (Limited-Time Offer)
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
EMBARK ON A THEME-BASED LEARNING ADVENTURE
Learn 40% Faster with 6-Step "PrACTice" Framework
Follow my special 6-step way of doing things. Clear Explanation, No Fluff, Bite-Sized.
WHAT'S INSIDE?
Master 70+ Excel Functions With My
"6-Step PrACTice" Framework
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 opporunities
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 / TRANSOSE / 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
Bonus 1: Business Dashboard Masterclass
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
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 $149 (Limited-Time Offer)
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
This Course Is For You If...
-
You don’t want to waste 3+ hours every day struggling with business analysis.
-
You don’t want to be ignored by 90% of data users in your industry.
-
You don’t want to stay stuck and unchanged for 2+ years in your career.
-
You don’t want to miss your next promotion by 6 months or more.
-
You don’t want to depend on others for 80% of your data tasks.
This course is your pivot point.
IN CONCLUSION
Invest Early. Compound Results in 10x Less Time.
Breakthrough your bottleneck and differentiate yourself with advanced applications.
Your Shortcut Awaits You!
I’ve figured out the 20% of Excel skills that get you 80% of the results — so you can skip all the extra fluff. Now you’ve got a shortcut to show off your Excel skills and level up your career faster!
See you in the course!
GET INSTANT ACCESS $149 (Limited-Time Offer)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 $149 (Limited-Time Offer)
LIFETIME BUNDLE (One-Time Payment)
USD $149 (Normally $250)
One-Time payment. ZERO risk. 30-day money back guarantee. Lifetime access and ongoing updates.
GET INSTANT ACCESS $149 (Limited-Time Offer)Students Are Loving The Course:
Students from 56 countries have enrolled! You're next!
Argentina, Australia, Austria, Azerbaijan, Brazil, Belgium, Cambodia, Canada, Cayman Islands, Chad, China, Egypt, Estonia, Fiji, France, Germany, Greece, Hong Kong, India, Indonesia, Ireland, Isle of Man, Italy, Jordan, Kuwait, 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 $149 (Limited-Time Offer)
More LinkedIn Followers Are Saying:
Learn XLOOKUP in 3 mins
XLOOKUP is the "Blood Vessels" connecting whole analytics system, you can't affort to lose it.
GET INSTANT ACCESS $149 (Limited-Time Offer)