What is a Pivot Table?

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:

  1. Pivot Tables – Part 1 – Setup and Features
  2. Pivot Tables – Part 2 – Conditional Formatting

RANDBETWEEN – Excel Function

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.

Arguments: RANDBETWEEN(lower number, higher number)

  • Lower number – the lowest integer possible you want to generate
  • Higher number – the highest integer possible you want to generate

Blog Posts using RANDBETWEEN()

  • Article 1

Videos using RANDBETWEEN()

  • Video 1

RAND – Excel Function

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.

Syntax: RAND()

  • (no arguments needed for this function)

Blog Posts using RAND()

  • Article 1

Videos using RAND()

  • Video 1