Blog

How to convert Gregorian to Hijri date and Hijri to Gregorian date

Handling dates is one of most challenging part and if you fail to enter the date correctly then you may lose some amazing features of Excel Time Intelligence. Let us see how to handle Arabic Dates in Excel

Get Live Gold, Silver & Precious Metal Stock Prices In Excel

Get Live Gold, Silver & Precious Metal Stock Prices In Excel.
Extracting precious metal prices like gold, sliver, platinum, etc into excel was one of the challenging task but not any more now.

Excel STOCKHISTORY Function

The STOCKHISTORY function extracts the historical stock data using the Microsoft Webservice about a financial data points and loads in Excel as an array, which will (spill) expand and shrink array size according to the construction of the formula.

How to Return XLOOKUP column dynamically in Excel for Mac and Windows

Return the XLOOKUP column dynamically

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