Excel made easy
Database of Excel tips and tutorials.
Latest Excel Tips and Tutorials
Use FLASH FILL In Excel
Learn how to use the FLASH FILL in Excel. Flash Fill quickly looks at similar cells and automatically picks up commonalities. Let’s look at the following data set. […]
Continue readingCalculate Shipping Days Left in a Month
Quickly learn how to calculate shipping days left in a month using a simple formula in Excel. Does your job require you ship packages or customer freight? Chances […]
Continue readingSingle Cell Text List with Dynamic Response
Dealing with a single cell text list can be challenging in Excel. You cannot use VLOOKUP or XLOOKUP as search functions to returns results. Additionally, depending on the […]
Continue readingSet Negative values to Zero
When working in Excel, it may be required to set negative values to zero. For example, if you are trying to determine how much positive income you generated […]
Continue readingHow to use the CAMERA Tool in Excel
Learn how to use the Camera tool in Excel. Unlike most tools in Excel, the Camera tool is not very well known. In fact, in order to use […]
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