If you work in large Excel files, Word documents or even e-mail, you may find it takes a long time to navigate and find the location you’re after. Hyperlinks are like a time machine in that they can take you there in an instant (but unfortunately they can’t take you back in time), and the [...]
July 2011
A Histogram, also known as a frequency distribution, is a chart that illustrates the distribution of values that fall into groups. Since my 5 year old is big into his football (soccer) we’ll take goals scored as an example…even though in 5 year old’s football matches you’re not supposed to count the goals scored! Below [...]
Each time I write a tutorial I use the Google Keyword tool to find search phrases that are relevant. I use these phrases as tags on my post to help you find it easier in Google and other search engines. The Google keyword tool spits out a list of phrases which I then export into [...]
If you just want a quick count of the number of items in a list or a range of cells you can simply select the range (with your mouse), and look at the Status Bar at the bottom right of your Excel window. This will count all cells that are NOT blank in your selected [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
