Excel Analytics OS Course Is Simple, But Impactful.
Master Excel for Business Analysis
Tailored for Beginners and Business Professionals
Seamless Business Data Integration into Clear Analytical Reports.
GET LIFETIME ACCESS for USD 160 (Limited-Time Offer)
Simple and powerful. Love it. Sun Lau does a terrific job illuminating the use of Excel and its practical, real-world application in business. As a “student” of his (with years of Excel experience myself)I highly recommend his Excel Analytics OS course. It’s an inexpensive way to brush up on basics while learning advanced modeling and techniques including cool new features in Excel 365.
_
Dean Tassone, Vice President, Market Access and Payer Strategy
Student from United States
Change Your Excel-Life in 7.5 Hrs
Now support 16 languages with captions!
Arabic, বাংলা, 简体中文, 繁体中文, English, Français, Deutsch, हिन्दी, Bahasa Indonesia, Italiano, 日本語, 한국어, Português, Русский, Español, اردو
GET LIFETIME ACCESS for USD 160 (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
WHY EXCEL ANALYTICS OS
Hi, I'm Sun.
I help you to master Excel for business analysis. Simpler, smarter, and easier.
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: 200k (LinkedIn, FB, IG, Threads, TikTok, XHS, YouTube)
Favikon Creator's Ranking: #1 - Excel and Office Productivity (Hong Kong) 2024
GET LIFETIME ACCESS for USD 160 (Limited-Time Offer)THE FIRST THING YOU SHOULD KNOW
What Happens When You Master Excel?
-
Save Time
You’ll get things done faster, leaving more time for what matters.
-
Get Accurate Results
Learn to avoid mistakes and do it right the first time.
-
Automate Tasks
Let Excel do the boring work for you, so you can focus on the fun stuff.
-
Grow Your Career
Excel skills can help you get ahead and open new doors.
-
Work Better with Others
Excel is like a language—when you know it well, it’s easier to share and work together.
-
Solve Problems Faster
With the right tools, you’ll fix issues quicker and easier.
-
Avoid Money Mistakes
Good planning with Excel helps you avoid costly mistakes.
-
Be Independent
With Excel skills, you won’t have to wait on others—you’ll get things done on your own.
Just 7.5 Hours for Big Rewards
Spend 7.5 hours on my Excel Analytics OS course, and unlock skills that save you time and open up new opportunities.
GET LIFETIME ACCESS for USD 160 (Limited-Time Offer)INSIGHTS FROM 20+ YEARS OF EXPERIENCE
Why Do People Struggle In Learning Excel?
Excel is Incredibly powerful tool, but difficult to master.
1. Lack of Context
If you don't really get how Excel works in real life, how long can you remember what you've been taught?
2. Lack of Interconnection
With more than 500 functions and lots of other stuff, how do you connect them to handle changing business situations?
3. Lack of Practical Applications
The main reason to learn Excel is to solve business problems. How sure are you that you can use Excel well for that?
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, it's Really possible.
I don't overpromise, but I'm fully confident in helping you reach the next level.
GET LIFETIME ACCESS for USD 160 (Limited-Time Offer)WHO IS THE COURSE DEISGN FOR?
You Are The Right Person
90% Of My Students Are Non-Technical 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.
Transform your future with Excel Analytcis OS.
This course is tailored for non-technical business professionals, helping you reach the next level.
GET LIFETIME ACCESS for USD 160 (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
SIMPLIFY YOUR LEARNING JOURNEY
This Teaches You, Learn Faster.
Clear Explanation, No Fluff, Bite-Sized.
1. Complexity → Simplicity
Easy to follow. I put together things that work the same way, so learning is easy and fast. I'll show you each step slowly, so you can get good at Excel at your own speed. And don't worry, my short videos are here to help you feel calm, not stressed.
2. Scattered → Organized
Easy to digest. Just like I said, you'll learn Excel while doing business stuff. I'll guide you through a real example that changes as you get better. This way, you can stay focused and understand everything easily. You won't have to worry about trying to remember lots of little things.
3. Long Hours Training → Short 7.5 Hours
Avoid Overwhelming Content. Let's think about what's really important, not what's a lot. I picked out the most useful 20% of things that help you with business stuff, which gives you 80% of what you need. You'll learn everything you need in just 7.5 hours, without feeling like it's too much.
GET LIFETIME ACCESS for USD 160 (Limited-Time Offer)EMBARK ON A THEME-BASED LEARNING ADVENTURE
Learn My Secret Blueprint
Follow my special 6-step way of doing things. This way, you'll learn all the important stuff and see how it fits into business stuff, which is really interesting.
WHAT'S INSIDE?
A "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.
4 mins
STEP 1: Purpose
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
1 hr 20 mins
STEP 2: Right Data
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
1 hr 15 mins
STEP 3A: Analyze numbers with formula
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
50 mins
STEP 3B: Conditional Formatting
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
1 hr 15 mins
STEP 3C: Trends and Charts
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
60 mins
STEP 4: Identify Root-Cause (PivotTable)
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
18 mins
STEP 5: Create Solutions
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.
1 hr 15 mins
STEP 6: Evaluation (Measure, Review, and Adjust)
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
Click here for full curriculum
This course is divided into 8 modules, with 121 short sessions, and it will take you 7.5 hours to finish. Once you're through, you'll have a strong grasp of the functions and features necessary for tackling business challenges.
I can't go into every detail right now, you can find all the specifics in the full curriculum.
GET LIFETIME ACCESS for USD 160 (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
LIMITED-TIME OFFER
Bonus 1 - Excel Analytics Excelerator (Value: $199)
170+ 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 first BONUS product: 170+ Tips and Tricks Pack.
Continuous Growth and Updates
This Tips and Tricks 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 LIFETIME ACCESS for USD 160 (Limited-Time Offer)
LIMITED-TIME OFFER
Bonus 2 - 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 BONUS 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 LIFETIME ACCESS for USD 160 (Limited-Time Offer)
This Course Is For You If...
If any of these things sound like you, then this course is perfect for you:
-
You have a hard time looking at business data.
-
You want to get really good at using Excel for business in just one course.
-
You want to really get what business analysis means when you use Excel
-
You want to get better at Excel by theme-based Excel learning
-
You want to move up in your job by getting good at using Excel for analysis.
This course will help you become really good at Excel Analytics. Come join me and get even better at it!
IN CONCLUSION
Start 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 LIFETIME ACCESS for USD 160 (Limited-Time Offer)
Limited-Time Offer with Bonus
USD $160 (Original $897)
One-Time payment. ZERO risk. 30-day money back guarantee. Lifetime access and ongoing updates.
GET LIFETIME ACCESS for USD 160 (Limited-Time Offer)Students Are Loving The Course:
Students from 48 countries have enrolled! You're next!
Australia, Austria, Azerbaijan, Brazil, Cambodia, Canada, Cayman Islands, Chad, China, Egypt, Fiji, France, Germany, Greece, Hong Kong, India, Indonesia, Ireland, Isle of Man, Italy, Jordan, Kuwait, Malaysia, Mozambique, Netherlands, New Zealand, Nigeria, Oatar, Pakistan, Panama, Philippines, Poland, Portugal, Romania, Saudi Arabia, Senegal, Singapore, Slovakia, South Africa, Spain, Sweden, Switzerland, Taiwan, Thailand, United Arab Emirates, United Kingdom, United States, Venezuela.
GET LIFETIME ACCESS for USD 160 (Limited-Time Offer)
More LinkedIn Followers Are Saying:
Peeking My Learning Platform
After checking out, you will be directed to my learning platform.
Watch this video to learn more.
GET LIFETIME ACCESS for USD 160 (Limited-Time Offer)Learn XLOOKUP now
XLOOKUP is the "Blood Vessels" connecting whole analytics system, you can't affort to lose it.
GET LIFETIME ACCESS for USD 160 (Limited-Time Offer)