How to use Indirect In Excel
Oct 31, 2020
Use the INDIRECT function in Excel to convert a text string into a valid reference.
How to Use Investment or Annuity In Excel
Oct 31, 2020
This example teaches you how to calculate the future value of an investment or the present value of an annuity.
How to Use IsError function in Excel
Oct 31, 2020
This example illustrates the ISERROR function in Excel.
How to Use Left Lookup function In Excel
Oct 31, 2020
The VLOOKUP function only looks to the right.
How to Use Loans with Different Durations In Excel
Oct 31, 2020
This example teaches you how to compare loans with different durations in Excel.
How to Use Locate Maximum Value In Excel
Oct 31, 2020
This example teaches you how to find the cell address of the maximum value in a column.
How to Use Lower/Upper Case In Excel
Oct 31, 2020
This 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 Excel
Oct 31, 2020
Use 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 Excel
Oct 31, 2020
This example illustrates three functions to round numbers to a multiple of x in Excel.
How to use the IF Function (WS) In Excel
Oct 31, 2020
The IF function is one of the most used functions in Excel.