How to Return XLOOKUP column dynamically in Excel for Mac and Windows
Return the XLOOKUP column dynamically
Category: Tip & Tricks
How to remove GETPIVOTDATA in Excel for Mac and Windows
How to Stop generating GETPIVOTDATA function in Excel for Mac and Windows.
How to filter max or min value in Power Query using UI Method in Excel & Power BI – “NO TIES”
Filter MAX or MIN value in Power Query for Excel & Power BI using UI Method in Excel & Power BI – “NO TIES”
How to Filter max or min value in Power Query for Excel & Power BI
Filter max or min value in Power Query for Excel & Power BI using the M function List.Max and List.Min
How to adjust the image size in Excel for header or footer?
When we insert image in the header or footer it happens that image is stretched outside the range of the document size print area. Here are the simple step to resize the image in Excel for windows.
How to leave an organization on Microsoft Teams?
Follows these steps to leave or exit any organization on Microsoft Teams
How to CHANGE an organization on Microsoft Teams?
Switch the organization on Microsoft Teams (macOS & Windows) Login to Microsoft Teams app In the right top corner, you will see an arrow pointing downwards Click on the arrow Select the organization to login Switch the organization on Microsoft Teams (any mobile device) Login to Microsoft Teams app In the left corner on the…
How to Insert Data from Picture?
Data entry is one of the tedious tasks and especially when you have the data printed in front of you and feed the data into spreadsheets. Microsoft Team has a solution for this issue by using their Microsoft AI technology.
What is the #SPILL! error and how to fix it?
Microsoft 365(Office365) users are upgraded with the new features regularly. Dynamic Arrays are one of the most waited features currently we have in Excel and which is a revolutionary change in the history of Excel.
How to share Microsoft 365 Family Subscription with families and friends
Microsoft 365 holds a great subscription deal. When anyone asks me which is the best out there, I strongly recommend them to buy by Microsoft 365 Family. For detail comparison check the link here & my video why I recommend the same.