How to generate random data based upon known percentage distribution using Excel

Let us say I want to create sample data for my analytics class for a customer. I dont have access to the actual customer data. But I want the data to look familiar to the participants. I want to use the names of their products in sample data containing 1000 rows. I could use Randbetween() with Vlookup but that gives me almost equal distribution for all products. I want to make the data look realistic. I want to use the market share values of their products to generate the sample data. Here is how you do it. 3.5 minute video.

How to deliver high-impact demos: Knowledge Pack

Cloud and water mixed animation using transparency with video

Here is a list of articles I have written about delivering great and high-impact demos.

  1. How to deliver high-impact demos – Part 1
    Talks about the concepts, creating sample files selection and presentation approaches.
  2. How to deliver high-impact demos – Part 2
    Explains the tools and techniques, using the right language, customizing the content to user needs and converting features to business value.
  3. How to deliver high-impact demos – Part 3
    Covers AV technical aspects, common causes of failures and how to manage them and presenter view.
  4. Using Zoom effectively
    1. High Impact Demos : Use Zoom
    2. PowerPoint 2013: How to use Zoom to show details
    3. More about Zoom
    4. What did I learn today: Great feature in Windows Magnifier
    5. Windows Magnifier (Zoom) and Surface Pro
    6. The amazing ZoomIt utility


What did I learn today: For Demo Warriors Only: Clear Outlook Categories

This article is relevant only for people who conduct demos or training on Outlook. During demos we create custom color categories. These categories remain customized for the next demo as well. Ideally I would want the categories to have default names (Red Category, Blue Category and so on). How to clean all of them quickly just before the demo? Simple.

Start Outlook with the Startup Switch /clearcategories

<office installation path>\outlook.exe /clearcategories.

This DOES NOT remove custom categories which have already been applied to Outlook items like mails, appointments or tasks. These have to be removed separately. But it does remove the custom descriptions. Now the category dialog looks like this.