Excel Tutorial DATABASE
Hundreds of free Excel tutorials
- Searchable database
- Growing community
- Constant updates
Latest additions
Insert Picture Into Cell in Excel
Learn how to add images to cells in Excel. Also use them with a filter. In order to get started, you need to have specific
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
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,
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
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
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
“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
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
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
Do you have an Excel Question?
ASK our community!
Using the VLOOKUP Function can sometimes be complicated. The easiest way to learn is by example. Check out the following tutorial for a downloadable demo file that illustrates how to nest a VLOOKUP Function.
XLOOKUP Function in Excel is an extremely powerful lookup tool recently introduced by Microsoft. In fact, VLOOKUP may be a thing of the past. Learn about the XLOOKUP function now.
Trying to become a financial wizard. You first need to understand the basics. Learn Compound Annual Growth Rate and Average Annual Growth Rates in Excel.
Learning shortcuts in Excel in essential to speeding up your work flow. This Chart is neatly organized to assist in the process. Check it out here.