Latest Excel Tips and Tutorials
Freeze 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 readingACOS Function
The ACOS Function returns the inverse cosine of a number in radians. The number must be between -1 and 1. If the number is outside -1 to 1, …
Continue readingRelative Reference in Excel
Relative Reference in Excel points to a cell or range of cells. However, this is pointed to cell is not locked like an absolute referenced cell. In Excel, …
Relative Reference 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 concatenate criteria date dates DAYS dynamic EMI end_date exact format_text holidays index indirect ISOWEEKNUM match minute month months multiple named ranges networkdays.intl number num_digits pmt range range_lookup return_type Reverse CAGR second serial_number significance start_date Subtract if sumif sumif date sumifs date sum_range table time_text tips value weekend _xlfn