Uploaded March 2023 | Updated November 2026, 3 days ago
Have you tried the new TEXTSPLIT function in Excel? It is crazy I tell you.
We can use it to split text to multiple value. For example,
π Got a full name in a cell and need to split first name & last name? TEXTSPLIT() it
π Have some email addresses in a cell and need to separate them? TEXTSPLIT to the rescue
π Working late because you don't know how to use Excel and your partner hates you for that? You can either split or try some of that juicy TEXTSPLIT... π€£
Let me show you how to use TEXTSPLIT with one simple and two advanced examples.
~
Learn more about some of the most useful & time-saving features of Excel.
My top 10 - I Saw my boss do this in Excel (Almost 2 mn views) - youtu.be/HgfC3etOgsU
How to use IF formula in Excel - youtu.be/15NtFld9mVM
10 Advanced tips on IF formula - youtu.be/-yFpzIRifK4
How to use FILTER in Excel - youtu.be/JuTdj2j-9Kg
How to use XLOOKUP in Excel - youtu.be/DDlZXXEI1bU
More videos on Excel Formulas - youtube.com/watch?v=-yFpzIRifK4&list=PLmejDGrsgFyDbGPi_5idB0RSWgTX3HPtM
~
#excel #textsplit
Have you tried the new TEXTSPLIT function in Excel? It is crazy I tell you.
We can use it to split text to multiple value. For example,
π Got a full name in a cell and need to split first name & last name? TEXTSPLIT() it
π Have some email addresses in a cell and need to separate them? TEXTSPLIT to the rescue
π Working late because you don't know how to use Excel and your partner hates you for that? You can either split or try some of that juicy TEXTSPLIT... π€£
Let me show you how to use TEXTSPLIT with one simple and two advanced examples.
~
Learn more about some of the most useful & time-saving features of Excel.
My top 10 - I Saw my boss do this in Excel (Almost 2 mn views) - youtu.be/HgfC3etOgsU
How to use IF formula in Excel - youtu.be/15NtFld9mVM
10 Advanced tips on IF formula - youtu.be/-yFpzIRifK4
How to use FILTER in Excel - youtu.be/JuTdj2j-9Kg
How to use XLOOKUP in Excel - youtu.be/DDlZXXEI1bU
More videos on Excel Formulas - youtube.com/watch?v=-yFpzIRifK4&list=PLmejDGrsgFyDbGPi_5idB0RSWgTX3HPtM
~
#excel #textsplit









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