Excel made easy
Database of Excel tips and tutorials.
Latest Excel Tips and Tutorials
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 […]
Continue readingRule 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 […]
Continue readingFull-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 […]
Continue readingPPMT 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 […]
Continue readingNPER 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 […]
Continue readingLearn about XLOOKUP
Learn how to use the XLOOKUP function in Excel. See for yourself why this new function makes Excel that much easier.
- XLOOKUP with Multiple Criteria
Perform an XLOOKUP with multiple Criteria using concatenate features in Excel - XLOOKUP Horizontal Lookup
With XLOOKUP, you no longer have to use the very limited HLOOKUP function. - XLOOKUP Function in Excel
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! - Fix XLOOKUP #SPILL Error
Learn to easily fix an XLOOKUP #SPILL Error in Excel.
camera tool ceiling criteria date DAYS dynamic end_date exact format_text holidays index indirect ltv mass delete match minute months multiple named ranges number num_digits pmi pmt range range_lookup return_type rounding search_key second separate serial_number significance start_date Subtract if sumif sum_range table text tips value weekend xlookup xlookup multiple year _xlfn