How to change autosave or auto-recovery default time in Excel?
Microsoft Excel default saves behavior to autosave the workbook is every 10 minutes. We will see how change that default setting by reducing the time.
Category: Excel
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.