Uploaded April 2023 | Updated November 2026, 3 hours ago
For the last 15 years, I have been using my Excel + data skills to make a living. In this video, let me share 6 of the most effective and proven tactics to make money using your Excel or data skills with clear examples and action items. I have been using these exact tactics to make over $100k+ for the last 15 years.
These 6 tactics are:
1) Freelancing
2) Consulting
3) Excel products
4) Teaching Excel
5) Writing about Excel
6) Website or Blog
π§° Resources & Links for you
========================
For FREELANCING:
Upwork - upwork.pxf.io/chandoo
Fiverr - go.fiverr.com/visit/?bta=419794&brand=fiverrhybrid
For BUSINESS CONSULTING:
Upwork - upwork.pxf.io/chandoo
LinkedIn - linkedin.com
Set up YOUR WEBSITE:
I recommend using SquareSpace as the process is easy and straightforward.
Visit squarespace.syuh.net/chandoo to create your website with them.
Alternatively, you can also use Bluehost - bluehost.sjv.io/chandoo
Set up your ONLINE STORE:
You can use your own website for this. I recommend using SquareSpace or Bluehost to make the website and adding a shopping cart module for best results.
Visit squarespace.syuh.net/chandoo or bluehost.sjv.io/chandoo
Alternatively, you can also use services like Shopify - shopify.pxf.io/chandoo
Teach EXCEL CLASSES:
I suggest creating your class thru teachable. This takes away the hassle of classroom LMS and let's you focus on the course.
Visit teachable.sjv.io/chandoo to create your first course with them.
Alternatively, you can also create courses thru udemy, skillshare or on your website.
How to CREATE VIDEOS:
I use Camtasia from Techsmith to make and edit all my videos. It is the best and most powerful software for doing this sort of thing.
Visit techsmith.z6rjha.net/chandoo to purchase Camtasia.
Other TECHNOLOGY GEAR:
My recommendations for camera, mic, hardware and other stuff can be found on my Amazon page here - amazon.com/shop/chandoo/list/13T7P87OWEB7I
Note: I use affiliate links for some of the resources mentioned here. I receive a small commission if you purchase the service or product.
More on Freelancing with Excel
=========================
Watch my "how I made $100k freelancing with Excel" for some tips & ideas: youtu.be/FHEPx4KjlG8
~
In the video β±
============
0:00 - Introduction to the 6 ways
0:45 - One: Freelancing
4:39 - Two: Business Consulting
6:57 - Three: Excel Products
10:08 - Four: Teaching Excel
13:43 - Five: Writing about Excel
15:10 - Six: Websites & Blogs
16:56 - How to get the clients?
~
I wish you all the best in your journey. ππΌπ
For the last 15 years, I have been using my Excel + data skills to make a living. In this video, let me share 6 of the most effective and proven tactics to make money using your Excel or data skills with clear examples and action items. I have been using these exact tactics to make over $100k+ for the last 15 years.
These 6 tactics are:
1) Freelancing
2) Consulting
3) Excel products
4) Teaching Excel
5) Writing about Excel
6) Website or Blog
π§° Resources & Links for you
========================
For FREELANCING:
Upwork - upwork.pxf.io/chandoo
Fiverr - go.fiverr.com/visit/?bta=419794&brand=fiverrhybrid
For BUSINESS CONSULTING:
Upwork - upwork.pxf.io/chandoo
LinkedIn - linkedin.com
Set up YOUR WEBSITE:
I recommend using SquareSpace as the process is easy and straightforward.
Visit squarespace.syuh.net/chandoo to create your website with them.
Alternatively, you can also use Bluehost - bluehost.sjv.io/chandoo
Set up your ONLINE STORE:
You can use your own website for this. I recommend using SquareSpace or Bluehost to make the website and adding a shopping cart module for best results.
Visit squarespace.syuh.net/chandoo or bluehost.sjv.io/chandoo
Alternatively, you can also use services like Shopify - shopify.pxf.io/chandoo
Teach EXCEL CLASSES:
I suggest creating your class thru teachable. This takes away the hassle of classroom LMS and let's you focus on the course.
Visit teachable.sjv.io/chandoo to create your first course with them.
Alternatively, you can also create courses thru udemy, skillshare or on your website.
How to CREATE VIDEOS:
I use Camtasia from Techsmith to make and edit all my videos. It is the best and most powerful software for doing this sort of thing.
Visit techsmith.z6rjha.net/chandoo to purchase Camtasia.
Other TECHNOLOGY GEAR:
My recommendations for camera, mic, hardware and other stuff can be found on my Amazon page here - amazon.com/shop/chandoo/list/13T7P87OWEB7I
Note: I use affiliate links for some of the resources mentioned here. I receive a small commission if you purchase the service or product.
More on Freelancing with Excel
=========================
Watch my "how I made $100k freelancing with Excel" for some tips & ideas: youtu.be/FHEPx4KjlG8
~
In the video β±
============
0:00 - Introduction to the 6 ways
0:45 - One: Freelancing
4:39 - Two: Business Consulting
6:57 - Three: Excel Products
10:08 - Four: Teaching Excel
13:43 - Five: Writing about Excel
15:10 - Six: Websites & Blogs
16:56 - How to get the clients?
~
I wish you all the best in your journey. ππΌπ
![End to End Power Query Data Cleaning Masterclass [FREE Workbook]
In this beginner to PRO session, learn Power Query to automate data cleaning, transformation tasks. We will be using a real-life dataset to perform data cleaning with Power Query (for Power BI).
Sample workbook: https://chandoo.org/wp/wp-content/uploads/2026/04/pq-data-cleanup.xlsx
What do I learn?
βοΈ Introduction to Power Query in Power BI
βοΈ How to understand Power Query UI
βοΈ Data cleaning basics (removing columns, renaming)
βοΈText transformation examples
βοΈ Working with Date columns
βοΈ Conditional (IF THEN ELSE) columns in Power Query
βοΈ Business operations on data
βοΈ Reference queries (one data source, multiple outputs)
βοΈ Dependency view and how to use it
βοΈ Automation with Power Query - Parameters
βοΈ Fixing errors
βοΈ Basic analysis of data in Power BI after Load
βοΈ Refresh process
β
Who is this for?
πΆ Power Query beginners
π©βπ»People who work with lots of data (in Excel or Power BI)
βοΈ Looking to automate / simplify data management / cleaning processes
π«NOT for people who already know & use Power Query a lot
π Video Chapters
0:00 - Introduction
5:30 - Brief Intro Power Query and how it fits in
11:40 - Sample Data & how to load it into PQ in Power BI
19:00 - Power Query UI Explained
24:00 - Data Cleaning basics with Power Query - Removing columns
28:00 - Date cleanup
32:30 - Text transformations in Power Query
37:30 - Arithmetic operations
41:00 - How to think about Power Query
44:30 - Salary bucket (conditional columns)
52:00 - Reference queries, multiple outputs from one source
56:30 - Using dependency view to understand various queries in your data
58:30 - Introduction to parameters and automation with PQ
1:02:00 - Closing & loading the data, testing everything in Power BI
1:05:30 - Adding new data, changing file names (parameter testing)
1:07:40 - Fixing refresh errors
1:11:00 - Using other sources (demo with SQL Server)
1:13:30 - Q&A
1:26:30 - Doing the same in Excel (demo with Blank Query, Copy pasting M Code)
#POWERQUERY #POWERBI End to End Power Query Data Cleaning Masterclass [FREE Workbook]](https://i.ytimg.com/vi/UhD3LbbimZ0/mqdefault.jpg)


![Excel SCAN Function is Shockingly Powerful! [Step-by-Step]
Every heard of SCAN function in Excel? Today, let me show you why you need this function and how it changes the way you solve your data problems. I think SCAN is Magic β¨
You are going learn:
What is SCAN function in Excel
SCAN syntax and application
How to use SCAN to calculate running total quickly
Using SCAN to get Maximum values
SCAN with LAMBDA
Advanced SCAN usage when your data is dynamic
~WHAT IS SCAN FUNCTION~
Scan function in Excel lets us run an operation on a range and returns all the intermediate results.
For example, you can use SCAN function to calculate running total of a range.
~WHAT IS THE SYNTAX OF SCAN~
SCAN(initial_value, range or array, operation)
For example:
=SCAN(0, A1:A10, SUM)
is going to return the running to of the range A1:A10
You can also use LAMBDA functions with SCAN to create more complex calculations.
=SCAN(0, A1:A10, LAMBDA(a, b, SUM(a,b)))
will return the same values as the first SCAN example above.
β± Video timestamps:
0:00 - What is SCAN function & Why it is important?
1:46 - Understanding how SCAN works
3:46 - Using SCAN to calculate running MAX
4:57 - Using LAMBDA functions with SCAN
6:38 - How I use SCAN to solve tricky problems
πΊ Watch next
How to use LAMBDA function in Excel - https://youtu.be/YrMCkE59ef4
How to use FILTER function in Excel - https://youtu.be/JuTdj2j-9Kg
Top 10 Essential Excel functions - https://youtu.be/HgNCvd8IbSc
π Sample Workbook:
If you need a file with SCAN examples, download the scandoo.xlsx here:
https://chandoo.org/wp/wp-content/uploads/2024/03/scandoo.xlsx
~
What is the favourite Excel function of a German Shepard πΆ?
LAMBda... π
#Excel #functions Excel SCAN Function is Shockingly Powerful! [Step-by-Step]](https://i.ytimg.com/vi/VrQSgI596IQ/mqdefault.jpg)






