In Excel you aren't restricted to having your whole cell full of text formatted in the same way.  You can have individual formatting on different characters within a cell.  (This only...

If you use the file auto recover/ save option in Excel, which I suggest you do. (I learned the very very hard way years ago whilst doing some analysis for my Thesis, my file corrupted after a hefty...

Here's a great shortcut you may not have heard of or maybe you have. I know I was really pleased when I was shown it, and those people who like to use the mouse a lot to navigate will like it as...

Suppose you have created a workbook with a a numbers of sheets, typically a number working data sheets and maybe a summary sheet. You may want to monitor the cells on the summary sheet whilst...

Welcome to Session 3 of Pivot Table Week. In this session we are going to start getting some good information from our raw data, getting the Pivot Table to all of the hard work really start to Pump...

Want to create your own style Excel work book to re use over and over again? It is easy to create your own default template in Excel to fit in with your corporate style or your own personal...