Utilizing Conditional Logic in Power Query!

  Рет қаралды 2,575

EXCEL 4 UR PARENTS

EXCEL 4 UR PARENTS

2 ай бұрын

In this tutorial, we dive into data transformations using conditional logic in Power Query! Join me in exploring IF - THEN - ELSE IF - ELSE statements. Learn how to categorize, filter, and enhance your data effortlessly, and streamline your workflow like never before. Watch now and take your Power Query skills to the next level! Don't forget to like, share, and subscribe for more Excel tutorials and tips! #Excel #PowerQuery #DataAnalysis #DataTransformation #DataManipulation #ExcelTips #ExcelTutorial #ExcelSkills #ConditionalLogic #DataCleaning #DataInsights #ExcelTricks #SpreadsheetSkills #Excel4URParents

Пікірлер: 8
@patrickschardt7724
@patrickschardt7724 Ай бұрын
One of the best if then else Power Query tutorials I have watched. Great job
@mattschoular8844
@mattschoular8844 Ай бұрын
Thanks for sharing your knowledge. Quick question, why do you press CRTL A when you can simply press CRTL T to create a table from the raw data set?
@teekayjunior2517
@teekayjunior2517 Ай бұрын
Love your channel and teaching style. I’m not a technical wiz when it comes to producing content, but I’m sure there’s a way to tune your mic so there is no echo and improve your listeners’ experience.
@excel4urparents242
@excel4urparents242 Ай бұрын
Great suggestion; I will see what I can do about that!
@kebincui
@kebincui 2 ай бұрын
Excellent tutorial 👍❤🌹
@algr665
@algr665 2 ай бұрын
Very clear and concise tutorial. Keep them coming, please. This is helping me a lot in my new job doing data analysis. Thank you!
@excel4urparents242
@excel4urparents242 2 ай бұрын
I am so glad!! is there anything specific you would like a video focusing on?
@algr665
@algr665 2 ай бұрын
I think any "data analysis" tools have become the core of many functions in most medium and large sized companies. The typical Excel even with advanced formulas techniques (which are still usable) is no longer the only valuable skills for many professions. I've been using Excel with complex formulas in my work for years, but learning Power Query, Power Pivot, Power BI, and Data Analysis in ChatGPT 4.0, just to cite some examples, have become a priority. if it wasn't for tutorials like yours and others in KZbin I wouldn't be able to achieve my renewed professional goals. The least I can express in this reply is my most sincere gratitude. You have a natural talent for teaching and coaching. It shows in your videos. Thank you!!@@excel4urparents242
All About Dates - Mastering Data Parsing & Dynamic Filtering in Power Query
13:42
Power Query - Faster & Easier Parameters
13:38
BCTI
Рет қаралды 30 М.
Как быстро замутить ЭлектроСамокат
00:59
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 12 МЛН
Китайка и Пчелка 4 серия😂😆
00:19
KITAYKA
Рет қаралды 1,5 МЛН
CAN YOU HELP ME? (ROAD TO 100 MLN!) #shorts
00:26
PANDA BOI
Рет қаралды 36 МЛН
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 48 М.
Clean That Data - Fast Data Cleaning Techniques in Power Query
13:57
EXCEL 4 UR PARENTS
Рет қаралды 1,1 М.
NEW! Top 5 Excel Features Microsoft Just Released
8:23
Excel Dictionary
Рет қаралды 57 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 422 М.
EASILY Combine Multiple Excel Sheets Into One With This Trick
8:48
Kenji Explains
Рет қаралды 213 М.
If ISBLANK, NULL or EMPTY in power query
2:58
Curbal
Рет қаралды 136 М.
Как быстро замутить ЭлектроСамокат
00:59
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 12 МЛН