How to Use Find function in Excel2020-10-30Functions TextUse the FIND function in Excel to find the position of a substring in a string.
How to Use Floating Point Errors in Excel2020-10-30Functions Formula ErrorsExcel stores and calculates floating point numbers. Sometimes, the result of a formula is a very close approximation.
How to Use Formula Auditing in Excel2020-10-30Functions Formula ErrorsFormula auditing in Excel allows you to display the relationship between formulas and cells.
How to use FREQUENCY function in Excel2020-10-30Functions StatisticalThe FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table.
How to Use holidays function in Excel2020-10-30Functions Date & TimeThis example teaches you how to get the date of a holiday for any year (2020, 2021, etc).
How to use the DATEDIF function2020-10-30Functions Date & TimeTo get the number of days, weeks or years between two dates in Excel, use the DATEDIF function.
How to use the HYPERLINK Function In Excel2020-10-30Functions Cell ReferencesUse the ‘Insert Hyperlink’ dialog box in Excel to create a hyperlink to an existing file, a web page or a place in this document.
How to Use Comparison Operators In Excel to check if two values2020-10-29Functions LogicalUse comparison operators in Excel to check if two values are equal to each other, if one value is greater than another value, if one value is less than another value, etc.
How to use Compound interest formula In Excel2020-10-29Functions FinancialWhat’s compound interest and what’s the formula for compound interest in Excel?
How to use Concatenate function In Excel2020-10-29Functions TextUse the CONCATENATE function in Excel to concatenate (join) strings. Instead of using CONCATENATE, simply use the & operator.
How To Add or Remove decimal In Excel2020-10-28Functions RoundThis example illustrates two functions to chop off decimals in Excel.
How to Compare Two Columns in Excel2020-10-28Functions Lookup & ReferenceTo compare two columns, use the IF, ISERROR and the MATCH function in Excel.
How To Create a Box and Whisker Plot In Excel2020-10-28Functions StatisticalThis example teaches you how to create a box and whisker plot in Excel.
How To Create a Case Sensitive Lookup In Excel2020-10-28Functions Lookup & ReferenceBy default, the VLOOKUP function performs a case-insensitive lookup.
How to Get an Absolute Value In Excel2020-10-28Functions LogicalThe ABS function in Excel returns the absolute value of a number.