## How to use the Substitute Function (Video)

If cleaning up messy data is part of your work flow, the substitute function is sure to come in helpful. Learn how to use it here:

If cleaning up messy data is part of your work flow, the substitute function is sure to come in helpful. Learn how to use it here:

I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how

What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than

What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother

The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be

What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()

What it does: The LARGE() Function provides the n-th largest piece of data from an array. Plain English: The LARGE() Function

What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria. Plain English:

(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste

Copyright ©2022 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis

Developed by WOWLayers.com