How to Use Locate Maximum Value In Excel2020-10-31Functions Lookup & ReferenceThis example teaches you how to find the cell address of the maximum value in a column.
How to Use Lower/Upper Case In Excel2020-10-31FunctionsThis example teaches you how to convert a text string to lower, upper or proper case in Excel.
How to Use MaxIfs and MinIfs Function In Excel2020-10-31Functions StatisticalUse MAXIFS and MINIFS in Excel 2016 or later to find the maximum and minimum value based on one criteria or multiple criteria.
How to use Nearest Multiple In Excel2020-10-31Functions RoundThis example illustrates three functions to round numbers to a multiple of x in Excel.
How to use the IF Function (WS) In Excel2020-10-31Functions LogicalThe IF function is one of the most used functions in Excel.
How to Use the IRR function in Excel2020-10-31Functions FinancialUse the IRR function in Excel to calculate a project’s internal rate of return.
How to calculate depreciation in Excel2020-10-30Functions FinancialExcel offers five different depreciation functions.
How to Copy Exact Formula In Excel2020-10-30FunctionsWhen you copy a formula, Excel automatically adjusts the cell references for each new cell the formula is copied to.
How to Count the Errors In Excel2020-10-30Functions Array FormulasThis example shows you how to create an array formula that counts the number of errors in a range.
How to Count Unique Values In Excel2020-10-30Functions Array FormulasThis example shows you how to create an array formula that counts unique values.
How to Count with Or Criteria In Excel2020-10-30Functions Array FormulasCounting with Or criteria in Excel can be tricky. This article shows several easy to follow examples.
How to Create an External References In Excel2020-10-30Functions Cell ReferencesAn external reference in Excel is a reference to a cell or range of cells in another workbook.
How to Use Day of the Year In Excel2020-10-30Functions Date & TimeAn easy formula that returns the day of the year for a given date.
How to Use Days until Birthday In Excel2020-10-30Functions Date & TimeTo calculate the number of days until your birthday in Excel, execute the following steps.
How to use Even and Odd function in Excel2020-10-30Functions RoundThis example illustrates the EVEN and the ODD function in Excel.