Have you ever wondered, "I wonder what X needs to be in order for Y to be 50%?" Good news! Excel thought of that as well! If you know what a certain results needs to be (i.e. profit margin needs to be 35%) but don't know what input value (i.e. Sales) will get you there, then use Goal Seek to find it for you. It sure beats trying to guessing 100 iterations in order get there yourself. Here is how it works. read more
I remember in college receiving a set of data going down a column. However, I wanted to present it going across the row. How could I ever do this?! I will tell you how. I started from top and one by one copied and pasted each cell. If you are doing this then STOP THE MADNESS!!! Here is how you can quickly transpose data. read more
Most people know how to use the basic Excel filter. However, do you know how to "extreme filter and sort"? Let's take your knowledge one step further and show you some neat functions of filters you probably did not know about. read more
The two most common frustrations with the VLOOKUP formula is either the lookup spits out the wrong value or you get the dreaded #VALUE. Even seasoned Excel experts can get stumped by this. However, 9.5 times out of 10 the reason your VLOOKUP formula is not working is due to one simple word: FALSE. Let me explain. read more
Most Excel users know (for better or worse) how to hide rows and columns. However, many times this is a brutish way to hide or organize your data, especially if you want to see that data again. This is where the power of grouping comes in. read more
Last week we talked about Data Validation and the fun and excitement one could have restricting cells with it. Today, we are going to talk about one specific tool in Data Validation, the List option. read more
Are you ready to learn one of the slickest tricks in Excel? Then read on, my fellow Excelerites! Today we are going to learn about Data Validation. read more
If you have eaten food in the last 3 days then chances are you have come across the annoying #N/A or #DIV/0! error in Excel. read more
Now that your boss is thoroughly impressed with your number formatting skills, let's blow her mind with some more! In this post we will teach you how to customize numbers and dates. With that knowledge, you will be able to customize all of your other values. Let's...
You have the wonderful task of entering in hundreds of phone numbers into a spreadsheet. Your boss wants all of the phone numbers to be in this format: (617) 555-5555. Before you came to this blog, this would have been a very, very tedious job. Now you will learn how...