BLOG
Analyzing Your Data Like a Pro: Data Analysis Pt. 2
Now that you have installed the Analysis Toolpak, let’s get down to analyzing your data!
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...
Set Your Cells Apart: How to Use Conditional Formatting
Imagine your boss comes in to your office one day and gives you a giant spreadsheet that goes on for pages and pages and pages. He wants you to highlight every single cell that contains word “NO” and says it is a top priority. There are two ways you can do this.
Checking Formulas: Tracing Dependents & Precedents
“Is this formula in cell A10 used for anything?” “Where are these inputs in cell Y54 coming from?” If you ever asked yourself these questions, read on.
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......
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...
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).
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.
The Almighty Alt Key
Now that you have mastered the keyboard shortcuts of last week, let’s learn how to never use your mouse again. Are you ready for this?
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!