Generating Random Data to Set Up a Pivot Table Tutorial
4,522 views · Published 14 January 2013 · 10:28 · Indexed 23 September 2026
Channel: Excel On Fire (Oz du Soleil) · 2013 · Education
Blogpost associated with this video: http://datascopic.net/generate-data/ Often we need to generate a set of bogus data in order to create examples or test solutions. In this video, I show how to generate fake call center data in order to show an example of a pivot table. This includes: RAND, RANDBETWEEN, date formatting, Find-Replace
More from this channel
-
5:03
Basic Excel Table Demo
-
8:23
Excel Data Validation: Why It's Important
-
3:41
Excel demo: retrieving current and historical stock data from the web.
-
5:45
Sriracha Taste Test 2: Sky Valley, Saigon Sisters & Lee Kum Kee
-
8:38
Excel Helps Determine the Dog's Fate
-
18:20
Pressman by Primus (Using Excel to study song structure)
-
8:12
Why Data & Excel: feeling the true impact
-
7:05
Converting a Grid into Clean Segmented Lists