Excel, Power Query, DAX, Power BI

Highlight the entire row based on item mentioned in other cell https://youtube.com/shorts/cRYWYzycFro?feature=share

How to sort month in pivot table as per Indian financial year Apr to Mar https://youtube.com/shorts/BnE64oKLqgY?si=FVPwYLQmGydAvSoa

What to do when SUMIFS is not working and can't add helper columns. https://youtu.be/gkTaqp4bmCE?si=Af01JCUBG0HFDwZl

Change the default layout of the pivot table field list https://youtube.com/shorts/NNlg2Uqyv6Q?feature=share

Not happy with default charts in Excel, want create professional and interactive charts then watch this https://youtube.com/shorts/6GisMmGvIt0?si=4lcXIe6g0ueA58H9

How to extract day numbers into multiple columns for respective days using Power Query in Excel https://youtu.be/j_09pAyr8aI

Navigate to a particular cell inside an Excel file by naming the cell and using go to toolbar https://youtube.com/shorts/Z92kBNNj3ww?feature=share

How to create multiple sheets in Excel with sheet names mentioned inside cell without using VBA https://youtube.com/shorts/wYvnuKCUI54?feature=share

If you want to sort data in calendar month order or custom order then watch this https://youtube.com/shorts/nn-4BYMbwbw?feature=share

Did you wonder why axis labels take so much in the horizontal bar chart in Excel? What is the alternative to it? https://youtu.be/CJ8Z3UtM0LU

How to unpivot data in Excel using formula https://youtu.be/m_oBHS-pHbY

Did you think Pivot Table totals could be incorrect or misleading? Checkout this video to know more https://youtu.be/GLzVGOwZ-XE

How to get a financial year from a date in excel https://youtube.com/shorts/TcOrKni4gZo?feature=share

While merging three columns you just want the first value to be included in the final column - checkout this video https://youtube.com/shorts/Etkq8OOtuKA?feature=share

If you want to open the same Excel file multiple times then use this feature in Excel https://youtu.be/3xAQ5El48Bo

If you want to bring values from multiple columns and do not want to write multiple VLOOKUP or INDEX & MATCH function then watch this. https://youtube.com/shorts/EhNFJ823QaU?feature=share