Home Excel

Excel

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

Rule of 500 Calculator – Astrophotography

0
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

0
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

PPMT Function

0
The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to...
NPER Function

NPER Function

0
The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods...
We cannot connect excel

“We can’t connect to” in Excel

0
"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

CUMPRINC Function

0
The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an...
YEARFRAC Function

YEARFRAC Function

0
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

0
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

0
Easily learn to Add Text to the beginning of a Number in Excel. In many instances, you are required to format number...
Year Function

YEAR Function

0
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out...

Latest Tutorials