Home » Excel » Page 3

# Excel

Learning Excel has never been easier. Review hundreds of Excel tutorials geared towards beginners all the way to experts.

## 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 …

## 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 Astrophotography. For example, if you are …

## 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 or Crop sensor camera, chances are …

## PPMT Function

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 …

## NPER Function

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” 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 you will probably received an error message …

## CUMPRINC Function

The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an excellent tool to quickly understand your …

## YEARFRAC Function

The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date, [basis]) Arguments: start_date – The start date. end_date …

## 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 with specified Text at the end. …

## 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 with Text at the beginning. The …

Scroll to Top