Excel made easy
Database of Excel tips and tutorials.
Latest Excel Tips
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 reading
What is Dry Powder? If you have been around investing, you most likely have heard of keeping Dry Powder in your reserves. However, most people don’t actually know …Continue reading
Learn 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.
autofilter autosum average averageif camera tool criteria criteria_range date dates DAYS dynamic end_date exact format_text greater than holidays index indirect ISOWEEKNUM is_sorted less than ltv match minute month months named ranges networkdays.intl number num_digits pmi pmt range range_lookup return_type search_key second serial_number significance start_date sumif sum_range table value weekend