TechKeysX
banner
techkeysx.bsky.social
TechKeysX
@techkeysx.bsky.social
37 followers 1 following 650 posts
https://www.youtube.com/@TechKeysX
Posts Media Videos Starter Packs
How to create Conditional Custom column in Excel Part 105:
Create a Conditional Custom Column in Power Query by using “Add Column” → “Conditional Column” to set rules that generate new values based on conditions. #powerqueryeditor #exceltips #datacleaning #ConditionalColumn #powerbi
Create Unique ID By using M Language in Power Query Part 104 #excel #exceltips #powerqueryeditor
Add country code by using M language and Custom column Part 103 #excel #exceltips #powerqueryeditor
Calculate Bonus Using M language in Power Query Part 102 #excel #exceltips #powerqueryeditor
Calculate Employee service Years using M Language Formula Part 101 #excel #exceltips #dataextractor
Extract and Create new Columns using columns from Example Part 100:
Create New Column From Example in Excel automatically fills a new column based on patterns you type from existing data. #exceltips #powerqueryeditor #datamagic #exceltutorial #productivity
Great use of Column From Example Part 99 :
Create New Column From Example in Excel automatically fills a new column based on patterns you type from existing data. #exceltips #powerqueryeditor #datamagic #exceltutorial #productivity
Create New Column From Example Part 98:
Create New Column From Example in Excel automatically fills a new column based on patterns you type from existing data. #exceltips #powerqueryeditor #datamagic #exceltutorial #productivity
Quickly Fill Dates in Excel Part 97 :
Quickly fill dates in Excel by dragging the fill handle to auto-generate a date series! #exceltips #QuickFill #excelshortcuts #DateSeries #spreadsheethacks
Extract Day Month or Day only in Excel Part 96: Easily Extract Day/Month or Day only in Excel using Power Query amazing Features. #excel #dataextractor #powerqueryeditor
Extract Data From XML Text using Parse option in Power Query in Excel Part 95 :Use Parse → XML in Power Query to instantly convert XML text into a structured table format for easy data analysis. #excel #powerqueryeditor #xml #dataparsing #exceltips
Extract Data in Excel using Power Query Part 93:
Extract Data in Excel using Power Query with delimiters to split text into columns based on characters like commas or spaces. #exceltips #powerqueryeditor #datacleaning #excelshortcuts #datasplit
Extract Data in Excel using Power Query Part 92:
Extract Data in Excel using Power Query with delimiters to split text into columns based on characters like commas or spaces. #ExcelTips #PowerQuery #DataCleaning #ExcelShortcuts #DataSplit