Rule of 500 Calculator – Astrophotography
The Rule of 500 Calculator in Excel is a simple document to let you quickly determine the maximum shutter speed for shooting...
Full-Frame Crop Factor Calculator in Excel
Easily determine the Full-Frame Crop Factor of your various lenses using the following calculator in Excel. If you shoot with a Full-Frame...
PPMT Function
The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to...
NPER Function
The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods...
“We can’t connect to” in Excel
"We can't connect to" pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are...
CUMPRINC Function
The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an...
YEARFRAC Function
The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax:
Add Text to End Number in Excel
Easily learn to Add Text to the End of a Number in Excel. This simple trick will allow you to format numbers...
Add Text to Beginning Number in Excel
Easily learn to Add Text to the beginning of a Number in Excel. In many instances, you are required to format number...
YEAR Function
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out...
