Analyzing Your Data Like a Pro: Data Analysis Pt.1

Let's say you have 3,000 rows of data, for instance, historical stock prices. You want to quickly see the following information: average, standard deviation, confidence level, minimum, and maximum You could create a separate area on your spreadsheet and manually input...

read more

Dissecting a String: =LEFT() & =RIGHT()

Excel data dumps are very great at combining lots of individual pieces of good information into one string. Unfortunately, this makes it very frustrating to the end user who then needs to extract that data. What if we could use formulas to do that dirty work for us......

read more

Date Formulas Part II: EDATE() & EOMONTH()

This is part II of amazing date formulas where we'll learn about EDATE() and EOMONTH(). EDATE(): This formula returns a date that is a certain number of months before or after a specific date. This is very useful for when you need to calculate a date that falls on the...

read more

Date Formulas Part I: TODAY() & DAYS()

Date formulas can become your best friends, if you just take the time to get to know them. The next couple of posts will be dedicated to ‘various Excel date functions and how to use them to optimize your spreadsheet (and maybe even win the heart of your next date).

read more

Named Ranges

Have you ever looked at a formula and thought, “What in the world does this mean! What items make up this crazy formula?” Or have you ever found your self constantly linking back to a cell and thought, there has to be a better way? If so, you are not alone. That is why named ranges exist! After you use named ranges, you’ll wonder how you ever got through life before.

read more

The Power of Keyboard Shortcuts

If you wanted to quickly insert a row, how would you go about doing that? If you are like most Excel users, you will use your mouse to click on the row, right click, and then select “Insert Row”. What if you wanted to quickly select all items in a column with 203,453 rows? Would you use your mouse to select and scroll alllll the way down?
Stop the madness! Never (at least rarely) use your mouse again!

read more