How to create large text containing numbers

I was creating a video on data analytics today. I needed to show a graphic of lots of data scrolling in the background for the video title. This is how I did it.

  • Create many rows of data by using this formula in Excel
    =RANDBETWEEN(1111111111111110,9999999999999990)
  • Copied the resulting data and pasted in Word as Text
  • Search for ^p which means paragraph mark and replace with nothing
  • This merged all the data into one big block of text
  • Paste it into a textbox in PowerPoint and use it for animation to create the title for the video

The result looks like this. Moral of the story? Use the right tool in the right place!

image

Quality Management 5: Pareto Chart

This chart is used to analyze important factors and prioritize action items. It is a combination of bar and line chart. Bar chart shows the data in descending order of importance and line chart shows cumulative percentage. It is popularly known as the 80:20 rule. We will see three ways of creating this chart using Excel.

image

Continue reading