Quite often we want to see a running total or running balance column for our data. There’s a couple of ways we can do this, both are dead easy. Let’s take the table below; say we want to add a running total to column G. Running Total option 1: Use a simple = + calculation [...]
November 2010
HLOOKUP is just like the VLOOKUP formula only the table you are looking up is laid out in a horizontal list, rather than vertically. Hence the ‘H’ for horizontal, and ‘V’ for vertical. Just like the VLOOKUP, the HLOOKUP can be used to find an exact match or used in a sorted list. Download the [...]
You may have worked out by now that I am a big fan of Excel, after all that’s what I mostly write about. Even though I’ve been working with Excel for 15 years it wasn’t love at first sight. It was stressful and frustrating at first, but now that I’ve mastered it I enjoy teaching [...]
The OFFSET function is one of Excel’s best kept secrets. Probably because it’s quite tricky to explain, and can be confusing to understand. So, in this tutorial I’m going to do my best to keep it simple so you can get your head around it and then I’ll cover a few of the most useful [...]
Creating a drop down list in Excel enables you to control the value entered into a specific cell by limiting the choices to those on a pre-defined list. A drop down list is simply a type of data validation. That is, Excel validates that the entry in the cell matches an item from your pre-defined [...]
Your email is one of the most important things on your computer and you must have an Outlook backup process in place. Here I will describe two methods to use for Outlook backup, a manual method and an automated method. This article relates to Outlook 2007, and does not deal with Outlook Express. The manual [...]
I'm sure you like to know handy little things that make your life easier or let you get things done just that little bit quicker. So here are 6 features of Microsoft Office that you should know about and use. AutoCorrect This is a handy little feature and can be used in more than one [...]
It’s common practice in Excel to format decimal places to get the desired rounding of numbers. But the problem with this approach is it can display totals that don’t appear to add up correctly. Take the screen shot below that shows 2+2+3=8. That’s because the underlying numbers are actually 2.4+2.4+3.2. The solution is to use [...]
If you have an email address, then you will get spam. It’s just a fact of life. I want to share with you some of my top tips to avoid spam. There are many reasons why you get spam but they all boil down to your email address being found by those bad, nasty people [...]
Pivot Tables in Excel are one of the most powerful tools, and once you understand how they work, they’re actually quite easy to insert and modify. In this example we’re going to work with a small amount of data for illustration purposes, but Pivot Tables are in their element with huge amounts of data laid [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
