Tag: Excel

random numbers

Excel Random Number Generation

Whether you need to select a sample or need test data, Microsoft Excel is capable of generating random numbers which can satisfy these requirements and many more. Excel has two key functions which relate to the generation of random numbers: RAND() and RANDBETWEEN(). Random Number Generation (Duplicates Are Acceptable) When randomly generating numbers, you must […]

May 7, 2012 | 0 Comments More
Personal Budget Pig

How to Create a Budget

Let’s face it, when most people hear the phrase “create a budget,” thoughts of boredom, exhaustion and drudgery aren’t far behind. The budgeting process most likely earned this stigma prior to the era of personal computing. There isn’t anything fun about sifting through piles of receipts and pecking on a calculator to create a paper […]

April 18, 2011 | 2 Comments More
IT Word Cloud

Separate All Text to the Right of a Word in Excel

I was recently using an application which exported a report into Microsoft Excel format. The report separated most fields into separate cells, but for some reason, it combined certain fields together into once cell. Unfortunately, I needed a way to separate the combined data into two cells so I could use a filter. The combined data […]

February 6, 2011 | 0 Comments More