Named Ranges in Excel enable you to give one, or a group of cells a name other than the default D3 for a single cell, or E3:F50 for a range of cells. Let’s look at a simple example of how you might use a Named Range. Say you had a range of cells containing sales [...]
October 2010
Have you ever wanted your very own interactive Google Map dotted with locations relevant to your business? You might want to plot the locations of your stores or service agents. Or if you’re presenting performance data to management it’s a great visual representation of sales locations and density. These are just a few examples of [...]
If you think SUM is handy, wait til you meet SUBTOTAL. SUBTOTAL has so many tricks up its sleeve you’ll be mesmerised, but don’t be put off because this formula is simple. If you’ve ever worked with Filters or hidden rows you’ve probably wanted to find the total of a column excluding what’s hidden. What [...]
Excel’s AND and OR formulas on their own aren’t very exciting, but mix them up with the IF Statement and you’ve got yourself a formula that’s much more powerful. In this tutorial we’re going to take a look at the basics of the AND and OR functions and then put them to work with an [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
