How to Return XLOOKUP column dynamically in Excel for Mac and Windows
Return the XLOOKUP column dynamically
Blog
Webinar for Azerbaijan Excel Meetup Group – Excel Tips & Tricks. What is New in Excel?
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
What is Power Automate and how to use it?
As the world is getting globally digitalize, our daily life challenges increasing as well. To keep our performance at the peak level we need to hit our target on time.
Often time we have a task that is repetitive e.g. follow-up for approvals, reminders for deliveries, updating records, processing invoices, etc. If you agree with me, such repetitive tasks consume a lot of time and it somewhere impacting our performance area.
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.