Uploaded February 2024 | Updated November 2026, 3 hours ago
π₯Get all the details in one email - chandoo.org/wp/xl4free
Do you want Microsoft Excel, Power BI and SQL for free? Watch this video to figure out how to get all the essential software for data analysis work for free.
π Get Excel / Power BI / SQL for free - all links here:
===========================================
~ ONE EMAIL WITH ALL INFO ~
Let me send you one email with all this info. Sign up here:
chandoo.org/wp/xl4free
~ EXCEL ~
To get Excel for free:
https://excel.new
To get Excel Home & Family plan:
amzn.to/3IbBpDR
To get Excel 2021 home & student perpetual license:
amzn.to/3IbBpDR
To get laptops with Office Pre-installed:
amzn.to/3wynfu8
~ POWER BI ~
To get Power BI Desktop for FREE:
microsoft.com/store/productId/9NTXR16HNW1T?ocid=pdpshare
To join the M365 Developer Program (and set up workspaces):
developer.microsoft.com/en-us/microsoft-365/dev-program
~ SQL ~
To get MySQL Community Edition:
mysql.com/products/community
To get SQL Server Express:
microsoft.com/en-nz/sql-server/sql-server-downloads
To practice SQL Online:
https://data.world
β± IN THIS VIDEO:
===============
0:00 - How to get Excel for FREE
1:28 - Limitations of FREE Excel
1:54 - Tricks to get Excel really cheap π€
6:12 - Getting Power BI for FREE
7:41 - Getting SQL for FREE
8:57 - Using data.world to practice SQL with your datasets!
10:06 - One Email with all the free info π§
π MORE FREE STUFF
===================
FREE beginner Excel course - youtu.be/F7aPazuS8QY
FREE beginner Power BI course - youtu.be/uwe8C7K8fXY
FREE beginner Power Query course - youtu.be/PiFAa_jjaEI
FREE beginner SQL course - youtu.be/l8DCPaHc5TQ
FREE beginner DAX course - youtu.be/PQ5lALdFHCU
FREE beginner Python course - youtu.be/uoC48wrJ-yM
FREE beginner Tableau course - youtu.be/tNLp_JVipoQ
FREE beginner VBA course - youtube.com/live/7hd1Nn4cNyI
FREE 100 Excel formulas - chandoo.org/wp/excel-formula-list
~
Happy learning π
What Excel feature costs nothing...?
FREEze panes π
~
#free #excel #powerbi
π₯Get all the details in one email - chandoo.org/wp/xl4free
Do you want Microsoft Excel, Power BI and SQL for free? Watch this video to figure out how to get all the essential software for data analysis work for free.
π Get Excel / Power BI / SQL for free - all links here:
===========================================
~ ONE EMAIL WITH ALL INFO ~
Let me send you one email with all this info. Sign up here:
chandoo.org/wp/xl4free
~ EXCEL ~
To get Excel for free:
https://excel.new
To get Excel Home & Family plan:
amzn.to/3IbBpDR
To get Excel 2021 home & student perpetual license:
amzn.to/3IbBpDR
To get laptops with Office Pre-installed:
amzn.to/3wynfu8
~ POWER BI ~
To get Power BI Desktop for FREE:
microsoft.com/store/productId/9NTXR16HNW1T?ocid=pdpshare
To join the M365 Developer Program (and set up workspaces):
developer.microsoft.com/en-us/microsoft-365/dev-program
~ SQL ~
To get MySQL Community Edition:
mysql.com/products/community
To get SQL Server Express:
microsoft.com/en-nz/sql-server/sql-server-downloads
To practice SQL Online:
https://data.world
β± IN THIS VIDEO:
===============
0:00 - How to get Excel for FREE
1:28 - Limitations of FREE Excel
1:54 - Tricks to get Excel really cheap π€
6:12 - Getting Power BI for FREE
7:41 - Getting SQL for FREE
8:57 - Using data.world to practice SQL with your datasets!
10:06 - One Email with all the free info π§
π MORE FREE STUFF
===================
FREE beginner Excel course - youtu.be/F7aPazuS8QY
FREE beginner Power BI course - youtu.be/uwe8C7K8fXY
FREE beginner Power Query course - youtu.be/PiFAa_jjaEI
FREE beginner SQL course - youtu.be/l8DCPaHc5TQ
FREE beginner DAX course - youtu.be/PQ5lALdFHCU
FREE beginner Python course - youtu.be/uoC48wrJ-yM
FREE beginner Tableau course - youtu.be/tNLp_JVipoQ
FREE beginner VBA course - youtube.com/live/7hd1Nn4cNyI
FREE 100 Excel formulas - chandoo.org/wp/excel-formula-list
~
Happy learning π
What Excel feature costs nothing...?
FREEze panes π
~
#free #excel #powerbi










![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)