If you have used Microsoft Excel then you will know how powerful it is for our business and also personal use. Sometimes you just need your spreadsheet to also look good. Whether you enter data...

Sometimes it's necessary to limit the number of character entries into cells, for example account codes or user names.  You may want to limit an account code to 6 characters.  This cuts down on...

Most of the time in Excel an AutoFilter would enable you filter lists in the ways you need to,  But, in some cases you may need or want to exert more control of over the way filtering operates....

I just HAD to share this little gem with you.  There is a button in Excel for freezing rows and columns really easily.  It's a small icon right at the very top of the scroll bar, and a similar one...

Recently a colleague was having an issue with their Pivot Table, they claimed some if their data was 'missing', a subscriber to my newsletter also had this issue so I thought I would cover it in...

It's amazing what a simple command of Copy and Paste can achieve when it comes to Excel. Dig beneath the surface and there is so much more than you would think.  Most people do the CTRL+C - CTRL+V,...