Excel made easy
Database of Excel tips and tutorials.
Latest Excel Tips and Tutorials
XLOOKUP Horizontal Lookup
Learn to perform a horizontal lookup using XLOOKUP. With XLOOKUP, you no longer have to use the very limited HLOOKUP function. In the example below, we will perform […]
Continue readingBoolean Logic in Excel
What is Boolean logic in Excel? So, how do you use Boolean logic and how can it be used in Excel. Changes are you have heard this term […]
Continue readingEffective Rate of Return in Excel
Learn how to calculate the effective rate of return in Excel. The Effective Annual Return (EAR) is the annual rate per year of an investment taking into consideration […]
Continue readingMultiple Criteria XLOOKUP
Learn how to use XLOOKUP with multiple criteria in Excel. In our example, we will show how you can use the XLOOKUP Function with multiple criteria. The functionality […]
Continue readingFix Data Validation Greyed Out
Have you ever run across the Data Validation box Greyed out in Excel? The reason Data Validation is Greyed Out is due to the characteristics of your spreadsheet. […]
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