Power Query - Find Uncommon between Two Lists
1:10
Power Query - Find Uncommon between Two Lists
Power Query - Remove blank rows and columns from your data
1:16
Power Query - Remove blank rows and columns from your data
Excel - Convert a Weekday Name to Number
1:06
Excel - Convert a Weekday Name to Number
Power BI - Multi Column Exact Match XLOOKUP / VLOOKUP in Power Query
1:46
Power BI - Multi Column Exact Match XLOOKUP / VLOOKUP in Power Query
Power BI - Exact Match XLOOKUP/VLOOKUP in Power Query
1:48
Power BI - Exact Match XLOOKUP/VLOOKUP in Power Query
Excel - Filter Text and Numbers from a Range
1:05
Excel - Filter Text and Numbers from a Range
Power BI - New DAX functions launched in 2022
1:12
Power BI - New DAX functions launched in 2022
Excel - Create Any Level of Dependent Drop Downs using Dynamic Arrays
3:14
Excel - Create Any Level of Dependent Drop Downs using Dynamic Arrays
Excel - Dynamic Chart with Drop Down Selection
3:09
Excel - Dynamic Chart with Drop Down Selection
Excel - Search As You Type
2:13
Excel - Search As You Type
Excel - Create In Cell Tornado Chart like Sparklines
1:09
Excel - Create In Cell Tornado Chart like Sparklines
Excel - How to calculate income tax, electricity bill based on slabs
1:39
Excel - How to calculate income tax, electricity bill based on slabs
Date.IsInQuarterToDate, Date.IsInMonthToDate and Date.IsInWeekToDate functions in Power Query
1:52
Date.IsInQuarterToDate, Date.IsInMonthToDate and Date.IsInWeekToDate functions in Power Query
Excel Quick Tip - Sort on the basis of alternate rows
0:41
Excel Quick Tip - Sort on the basis of alternate rows
SQL - Top 10 Free Online SQL Editors
1:14
SQL - Top 10 Free Online SQL Editors
Power Query - Make Text.ExcelTrim Function
0:53
Power Query - Make Text.ExcelTrim Function
Excel Quick Tip - Use F4 to insert / remove $ in your references
0:38
Excel Quick Tip - Use F4 to insert / remove $ in your references
Excel - Create Thermometer Chart
2:02
Excel - Create Thermometer Chart
Excel - Generate Abbreviations from give Words
0:44
Excel - Generate Abbreviations from give Words
Excel - Get the last non blank value in a range
0:55
Excel - Get the last non blank value in a range
Excel - Insert Sequence Numbers like 1st, 2nd....9th, 10th
0:56
Excel - Insert Sequence Numbers like 1st, 2nd....9th, 10th
Excel - Extract the last number in a range
1:10
Excel - Extract the last number in a range
Excel - Insert a Sequence Number or Index or Rank in a Pivot Table
0:42
Excel - Insert a Sequence Number or Index or Rank in a Pivot Table
Excel - Create a 5 Star Rating System for your Data
0:59
Excel - Create a 5 Star Rating System for your Data
Excel - Find the position of First & Last blank cell
0:54
Excel - Find the position of First & Last blank cell
Excel - SUM, AVERAGE, MAX & MIN without Writing Formulas
1:04
Excel - SUM, AVERAGE, MAX & MIN without Writing Formulas
Excel - Highlight Max & Min in your Data Simplified
1:04
Excel - Highlight Max & Min in your Data Simplified
Excel - Add a Target Line to a Bar Chart
1:12
Excel - Add a Target Line to a Bar Chart
Excel - Add a Target line in your Charts
1:05
Excel - Add a Target line in your Charts
Excel - Be Super Smart at Work, use SMART LOOKUP
1:07
Excel - Be Super Smart at Work, use SMART LOOKUP