Latest Excel Tips and Tutorials
OFFSET Function in Excel
Learn how to use the offset function in Excel for efficient data manipulation.
Continue readingUse VBA code to calculate Compound Annual Growth Rate
You can use VBA code to calculate compound annual growth rate in Excel. Let’s start by looking at the following code. To use the function in a worksheet, …
Use VBA code to calculate Compound Annual Growth Rate Read More »
Continue readingUse VBA and XLOOKUP together!
Learn how to use VBA and XLOOKUP Function together. In this example, the VBA macro will prompt the user to enter a search value, and then use the …
Use VBA and XLOOKUP together! Read More »
Continue readingXLOOKUP with Logical Criteria
To use XLOOKUP with logical criteria, you can create a separate column with the logical values and then use XLOOKUP to search for the matching value in that …
XLOOKUP with Logical Criteria Read More »
Continue readingHow to Subtract dates in Excel
Learn to subtract dates in Excel. To subtract two dates in Excel and get the number of days between them, you can use the “DATEDIF” function. The syntax …
How to Subtract dates in Excel Read More »
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 time_text tips value weekend xlookup year _xlfn