ISERROR Function
The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! It is […]
Learning Excel has never been easier. Review hundreds of Excel tutorials geared towards beginners all the way to experts.
The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! It is […]
The Rule of 500 Calculator in Excel is a simple document to let you quickly determine the maximum shutter speed for shooting Astrophotography. For example, if you are
Rule of 500 Calculator – Astrophotography Read More »
Easily determine the Full-Frame Crop Factor of your various lenses using the following calculator in Excel. If you shoot with a Full-Frame or Crop sensor camera, chances are
Full-Frame Crop Factor Calculator in Excel Read More »
The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to determine is the principle of a
The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods of a loan are based on
“We can’t connect to” pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are you will probably received an error message
“We can’t connect to” in Excel Read More »