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
Master Excel For Business Analysis in Just ONE Course.
This CourseĀ Is For You If...
-
You donāt want to struggle with business analysis
-
You donāt want to be ignored in the data world
-
You donāt want to stay stuck and unchanged
-
Ā You donāt want to miss your next promotion
-
Ā You donāt want to depend on others
This course is your pivot point.
6-Step 'PrACTice' Framework Guides You to Success
Now support 16 languages with captions!
Arabic, ą¦¬ą¦¾ą¦ą¦²ą¦¾, ē®ä½äøę, ē¹ä½äøę, English, FranƧais, Deutsch, ą¤¹ą¤æą¤Øą„ą¤¦ą„, Bahasa Indonesia, Italiano, ę„ę¬čŖ, ķźµģ“, PortuguĆŖs, Š ŃŃŃŠŗŠøŠ¹, EspaƱol, Ų§Ų±ŲÆŁ
WHY EXCEL ANALYTICS OS
Built for professionals who need clarity, not clutter.
Ā
Hi, I'm Sun.
I help professionals master Excel for business analysisā
with one clear, simplified course.
But let me be honestā¦
20 years ago, I thought I had Excel figured out.
I took the usual course.
Clicked around the ribbon.
Followed steps. Copied formulas.
It felt easyāuntil it wasnāt.
Then the real problems showed up.
When it came to applying Excel in real business analysis, I hit a wall.
And Iāve seen thousands struggle with the same five things:
1. Scattered Data Mess
Youāve got files everywhereāsales reports, CRM exports, raw data from suppliers.
But putting them all together? Takes hours. Still full of errors.
You feel frustrated, thinking: āThis should be simple... Why isnāt it?ā
2. Repeating Boring Work
Every week, you do the same tasks: copy-paste, clean up, reformat.
No automation. Just fatigue.
Your brainās tired before you even start real analysis.
3. Building Without a Blueprint
You want to build dashboards or reports that make sense to your boss.
But you donāt know where to begināthereās no structure.
Just random tutorials that donāt fit your workflow.
4. Weak Storytelling with Charts
You make a chart, but it doesnāt say much.
Management looks at it, nodsā¦ then asks for something āclearer.ā
You feel deflated. Youāre trying hardābut itās not landing.
5. Learning That Doesnāt Stick
You watch a YouTube video, read a blog, take a courseā
but none of it connects the dots.
Nothing feels repeatable.
Youāre learning, but not growing.
I get it. I lived it.
Thatās why I built Excel Analytics OSā
to give you what I never had:
A clear, structured system for mastering Excel specifically for business analysis.
No fluff. No wasted time.
Just the right skills, in the right order, with real business context.
Iāve spent decades turning confusion into clarityā
So you donāt have to waste years like I did.
If you want to see how it works, 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 $ 149INSIGHTS FROM 20+ YEARS OF EXPERIENCE
A Fast Way To Master Excel
Excel is Incredibly powerful tool, but difficult to master.
1.Ā Learning With A Solid Framework
Once you have a framework, you'll never forget it.
2. Learning With Purpose
Learn with a clear goalābusiness analysis. Not just saving time, but creating real business value.
3.Ā Learning With ExpertiseĀ Guidance
No more going in circles. Leverage my 20 years of experience to boost your Excel skills fast.
THE FIRST THING YOU SHOULD KNOW
How Is This Course Different?
-
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 '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
You can truly master Excel for real-world use.
-
Embrace simplicity of Excel
Iāve carefully selected the most important 20% of concepts that cover 80% of real-world scenariosādelivered concisely.
-
Remove Fluff and Focus on What Matters
Effective learning comes from to-the-point trainingāno fluff, no gimmicks, no distractions.
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
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 a Data-Driven Professional.
Build a Strong Understanding of Proper Data Structure
Knowing the proper data structure ensures you won't start your project at a dead end.
Effectively Consolidate Business Data
You'll learn how to easily combine and clean data from different sources in a simple and effective way.
Master the 20% Crucial 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.
Effectively present your findings and insights
You'll be able to present your data professionally. Impress your stakeholders and management with amazing Excel skills.
Interconnect your knowledge and context
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 $ 149WHO IS THE SIMPLIFED COURSE DEISGN FOR?
You Are The Right Person
90% Of My Students Are Business Professionals
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 LIFTTIME ACCESS FOR $ 149 TODAY
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
This Teaches You, Learn Faster.
Follow my special 6-step way of doing things. Clear Explanation, No Fluff, Bite-Sized.
WHAT'S INSIDE?
A Simplifed "PrACTice"Ā Framework
PerfectedĀ Over 20 Years
This 7-Day course consists of 8 modules and 121 short lessons, spanning 7.5 hours, broken down into six essential steps.
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
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
Ā
LIFETIME MEMBERSHIPĀ OFFER
ProductĀ 2 - 200 Excel Analytics TipsĀ (Value: $199)
200+ Impactful Tips and TricksĀ to boost your Execl skills in 150 mins.
I understand that learning Excel is a lifelong journey, and that's why I'm always looking for ways to support your learning. That's why I'm excited to offer you the first bundle product:Ā 200 Excel Analytics Tips Power Pack.
Continuous Growth and Updates
ThisĀ 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 $ 149LIFETIME MEMBERSHIP OFFER
Product 3 - Business Dashboard Masterclass (Value: $199)
You'll learn how to create an insighful business dashboard with just using 3 functions!
I'm excited to offer you the second BUNDLE product:Ā Creating Insighful Business Dashboard.
You'll learn how to select proper datasets and use only 'three functions' to create an insightful business dashboard in a simple way. I carefully design it in just 1.5 hour.
GET INSTANT ACCESS $ 149
IN CONCLUSION
InvestĀ Earlier, You'll Benefit Sooner!
Breakthrough your bottleneck and differentiate yourself with advanced applications.
Your Shortcut Awaits You!
I've figured out what's really important and left out the extra stuff. Now you have this shortcut to show off your Excel skills and make your career better!
See you in the course!
GET INSTANT ACCESS $ 149
LIFETIME MEMBERSHIP (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 $ 149Students 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
MoreĀ LinkedIn Followers Are Saying:
Learn XLOOKUP now
XLOOKUP is the "Blood Vessels" connecting whole analytics system, you can't affort to lose it.
GET LIFTTIME ACCESS FOR $ 149 TODAY