Latest Excel Tips and Tutorials
Use XLOOKUP with multiple sheets
To use XLOOKUP with multiple sheets, you can specify the sheet name followed by an exclamation point (!) in front of the cell range. For example, if you …
Use XLOOKUP with multiple sheets Read More »
Continue readingAdvanced Xlookup and VBA Equations
Advanced Xlookup and VBA equations in Excel can include complex conditional statements, loops, and custom functions to perform more complex calculations and manipulations. Here are a few examples: …
Advanced Xlookup and VBA Equations Read More »
Continue readingXlookup Equation to Compare Text
Let’s look at the following Xlookup equation to compare text in Excel. In this formula, value to look up is the text you want to compare, range to …
Xlookup Equation to Compare Text Read More »
Continue readingQuick History of Microsoft Excel 1987 to 2023
Learn the detailed history of Microsoft Excel. Microsoft Excel is a spreadsheet software program developed by Microsoft Corporation. It was first released for the Macintosh in 1985 and …
Quick History of Microsoft Excel 1987 to 2023 Read More »
Continue readingFreeze Column or Row in Excel
Learn to freeze a column or row in Excel. Go to “Toolbar Ribbon” and Select “View” – “Freeze Panes“ This brings up 3 options: Freeze Panes – Allows …
Freeze Column or Row 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 dates DAYS dynamic EMI end_date exact holidays index indirect ISOWEEKNUM match minute month months multiple named ranges negative numbers networkdays.intl number num_digits pmt range range_lookup return_type rounding second serial_number significance start_date Subtract if sumif sumif date sumifs date sum_range table time_text tips value weekend xlookup _xlfn