Latest Excel Tips and Tutorials
Xlookup 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 readingConvert Degrees to Radians in Excel
Learn to convert Degrees to Radians in Excel using the following formula in Excel. Input the degrees in the highlighted box. By using the following formula, you can …
Convert Degrees to Radians in Excel Read More »
Continue readingConvert Radian to Degrees in Excel
Learn to convert Radian to Degrees in Excel using the following formula in Excel. Input the number of radians and use the Degree function to convert to degrees. …
Convert Radian to Degrees 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 end_date exact format_text greater than holidays index indirect ISOWEEKNUM ltv match minute month months multiple named ranges networkdays.intl number num_digits pmt range range_lookup return_type second serial_number significance start_date Subtract if sumif sumif date sumifs date sum_range table time_text tips value weekend xlookup _xlfn