How To

A collection of 341 posts

How to use Tax Rates in Excel

This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel. The following tax rates apply to individuals who are residents of Australia. Taxable income Tax
06 November 2020

How to use Weighted Average in Excel

To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function. 1. The AVERAGE function below calculates the normal average of three scores. Suppose your teacher says, “The
06 November 2020

How to use Vlookup function in Excel

The VLOOKUP function is one of the most popular functions in Excel. This page contains many easy to follow VLOOKUP examples. Exact Match Most of the time you are looking for an exact
06 November 2020

How to use Two-way Lookup in Excel

This example teaches you how to lookup a value in a two-dimensional range. We use the INDEX and the MATCH function in Excel. Below you can find the sales of different ice cream
06 November 2020

How to use Today's Date in Excel

To enter today’s date in Excel, use the TODAY function. To enter the current date and time, use the NOW function. To enter the current date and time as a static
06 November 2020

How to use Time Sheet in Excel

This example teaches you how to create a simple timesheet calculator in Excel. Cells that contain formulas are colored light yellow. If you are in a hurry, simply download the Excel file. 1.
06 November 2020

How to use Time Difference in Excel

Calculating the difference between two times in Excel can be tricky. Times are handled internally as numbers between 0 and 1. Simple Formula Let’s start with a simple formula that calculates
06 November 2020

How to use Text to Columns in Excel

To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’. For example, when you want to separate a list of full
06 November 2020

How to use Text Function in Excel

When joining text and a number, use the TEXT function in Excel to format that number. This page contains many easy to follow TEXT function examples. 1a. For example, without using the TEXT
06 November 2020

How to use Switch function in Excel

This example teaches you how to use the SWITCH function in Excel 2016 or later instead of the IFS function. 1a. For example, the IFS function below finds the correct states. Explanation: cell
06 November 2020

How to use Substitute vs Replace in Excel

This example shows the difference between the SUBSTITUTE function and the REPLACE function. 1a. If you know the text to be replaced, use the SUBSTITUTE function. 1b. The SUBSTITUTE function has a 4th
06 November 2020

How to use no SUBSTRING function in Excel

There’s no SUBSTRING function in Excel. Use the MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE, REPT, TRIM and the MAX function in Excel to extract substrings. Mid To extract a substring, starting
06 November 2020

How to use Standard Deviation In Excel

This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using
04 November 2020

How to use Search function In Excel

Use the SEARCH function in Excel to find the position of a substring in a string. The SEARCH function is case-insensitive and supports wildcards. 1. The SEARCH function below finds the string “
04 November 2020

How to use PMT function In Excel

The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate. This page contains many easy to follow PMT examples. PMT examples Consider a
04 November 2020

How to use Or function in Excel

The OR function in Excel returns TRUE if any of the conditions are true and returns FALSE if all conditions are false. Combine the OR function with other functions and become an Excel
04 November 2020

How to use Offset function In Excel

The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells. 1. The OFFSET function below
04 November 2020

How to use Calculate Quarter in Excel

An easy formula that returns the quarter for a given date. There’s no built-in function in Excel that can do this. 1. Enter the formula shown below. Explanation: ROUNDUP(x,0)
04 November 2020

How to Split a String In Excel

This example teaches you how to separate strings in Excel. The problem we are dealing with is that we need to tell Excel where we want to separate the string. In case of
04 November 2020

How to Generate Random Numbers In Excel

Excel has two useful functions when it comes to generating random numbers. The RAND and RANDBETWEEN function. Rand The RAND function generates a random decimal number between 0 and 1. 1. Select cell
04 November 2020

How to Create a Roll the Dice In Excel

This example teaches you how to simulate the roll of two dice in Excel. If you are in a hurry, simply download the Excel file. Note: the instructions below do not teach you
04 November 2020

How to use RANK Function In Excel

The RANK function in Excel returns the rank of a number in a list of numbers. Use RANK.AVG to return the average rank if more than one number has the same rank.
04 November 2020

How to use NPV formula In Excel

The correct NPV formula in Excel uses the NPV function to calculate the present value of a series of future cash flows and subtracts the initial investment. Net Present Value For example, project
01 November 2020

How to Use the IRR function in Excel

Use the IRR function in Excel to calculate a project’s internal rate of return. The internal rate of return is the discount rate that makes the net present value equal to
31 October 2020

How to use the IF Function (WS) In Excel

The IF function is one of the most used functions in Excel. This page contains many easy to follow IF examples. Simple If Examples The IF function checks whether a condition is met,
31 October 2020

How to use Nearest Multiple In Excel

This example illustrates three functions to round numbers to a multiple of x in Excel. The MROUND, CEILING and the FLOOR function. Mround 1. For example, round a number to the nearest multiple
31 October 2020

How to Use Lower/Upper Case In Excel

This example teaches you how to convert a text string to lower, upper or proper case in Excel. 1. Use the LOWER function to convert all letters in a text string to lowercase.
31 October 2020

How to Use Investment or Annuity In Excel

This example teaches you how to calculate the future value of an investment or the present value of an annuity. Tip: when working with financial functions in Excel, always ask yourself the question,
31 October 2020

How to use Indirect In Excel

Use the INDIRECT function in Excel to convert a text string into a valid reference. You can use the & operator to create text strings. Cell Reference Use the INDIRECT function in Excel
31 October 2020

How to use IfError In Excel

Use the IFERROR function in Excel to return an alternative result, such as text, when a formula evaluates to an error. 1. For example, Excel returns the #DIV/0! error when a formula
31 October 2020