Excel made easy
Database of Excel tips and tutorials.
Latest Excel Tips and Tutorials
ACOS Function
The ACOS Function returns the inverse cosine of a number in radians. The number must be between -1 and 1. If the number is outside -1 to 1, […]
Continue readingRelative Reference in Excel
Relative Reference in Excel points to a cell or range of cells. However, this is pointed to cell is not locked like an absolute referenced cell. In Excel, […]
Continue readingAbsolute Reference in Excel
Absolute reference in Excel refers to a cell reference that is “locked.” This means that the rows and columns won’t change when copied within a spreadsheet (or sheets). […]
Continue readingCoil Steel Price per ft and in
Learn how to quickly calculate the coil steel price per ft and the coil steel price per in. For a quicker option, download the demonstration file. Coil Steel […]
Continue readingSplit String by colon, semi-colon, comma, or delimiter
This quick example will demonstrate how to split a string by a colon, semi-colon, comma, or delimiter in Excel. The example below will split a name from the […]
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 effect 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 year _xlfn