BLOG
Goal Seek: Finding the Perfect Number
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.
From Vertical to Horizontal: Transposing your Lists
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.
Extreme Filters & Sorting
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.
Why Your VLOOKUP Is Not Working
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.
Group, Don’t Hide, Your Data
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.
Data Validation’s Most Powerful Tool: Drop Down List
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.
Data Validation: Limiting Others’ Inputs w/o Limiting your Outputs
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.
How to Fix Errors: Remove #N/A and other Errors from your Spreadsheet
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.
Number Formatting Pt. 2: Customizing Your Numbers
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...
Number Formatting Pt. 1: Phone #’s, Zip Codes, and SSN
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...