A pivot table is a feature of Microsoft Excel that allows a user to quickly summarize and analyze a large set of data.
Everything that a pivot table does can be done by hand or by using other Excel formulas. However, pivot tables often speed up the process and allow the person receiving the report to quickly identify what’s important in the data.
Check out our more in-depth series on Pivot Tables:
What it does: The RANDBETWEEN() Function generates a random number between two integers.
Plain English: Rather than generating a random number between 0 and 1, RANDBETWEEN() generates an integer between a given range of integers that you provide. For example, you may want to pick 6 random lottery numbers between 1 and 35. This formula could help generate those.
What it does: The RAND() Function generates a random number between 0 and 1.
Plain English: The random function is a brother to the RANDBETWEEN() function. It generates a number in between 0 and 1, like .6231. This is a great function for creating sample data or running simulations where you need a random number generated.