Excel Archives - Page 2 of 6

December 5, 2021February 16, 2022Faraz ShaikhLeave a Comment

How to calculate Hijri Age in Excel

Calculate the Hijri Age In Excel, using the old-school method & with LAMBDA Function.

August 4, 2021August 7, 2021Faraz ShaikhLeave a Comment

How to create Excel Table with the current sheet name using VBA

Simple line of VBA Code allow you to convert active sheets data into Excel Table with active sheet name just by one click.
#FarazShaikh #ExcelExciting #VBA #Macro #ExcelForMac #ExcelForWindows

August 2, 2021August 2, 2021Faraz ShaikhLeave a Comment

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.

June 9, 2021June 9, 2021Faraz ShaikhLeave a Comment

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

April 28, 2021October 24, 2024Faraz Shaikh1 Comment

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.

April 3, 2021October 24, 2024Faraz ShaikhLeave a Comment

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.