If you are a budding Excel guru or you want to be able to achieve more in Excel faster and quicker then an online visit to Institute of Chartered Accountants in England & Wales can help. There you will find the Excel Guru in the form of Simon Hurstat their online network IT Counts.
A selection of Simon's tips are listed below:
Useful Excel shortcuts
Office IT Quick tip – Excel data entry
Did you know? Random MS Office tips
Excel and instant year ends
Part 2 – the best ever Excel tip?
Excel functions: MATCH(), INDEX() and the Lookup Wizard
Roadshow day 4, Lancaster - Excel's OFFSET() function
Simon's tips come in bite size chunks at IT Counts. The online approach works well as many tips include animated screen shots which aids in grasping the concepts. The tips are also permanently online so if you forget a point then the answer is just a click of the mouse away.
If this has given you an appetite for more of Simon's tips then clicking on the link below. You will have to join the IT Counts online network first - membership is free and open to all.
Simon Hurst's Excel IT Counts Posts
I'm retired now, and have been for almost fifteen years, but a few years back I got into doing some consulting, and the first time I ran into an Excel spreadsheet, I have to say I was overwhelmed. I could have used some training like this. I still don't know how to use Pivot Tables, or even what they are. Maybe it's good I got out when I did. I can tell you that if I was still doing auditing or accounting, I'd sure as all out be a customer of theirs.
Cheers to you folks over there,
Kirk Ward
http://kirk-ward.com
Posted by: Kirk Ward | 09 January 2009 at 17:47
Hello Kirk
Yes, it can be a bit overwelming. Excel is a very powerful tool and most users only use a fraction of it. Simon is just as good in real life as he is online.
If you really want to understand pivot tables then I can also recommend Emily's Coltman's videos at http://www.feechan.co.uk/index.htm?page=excelvideotraining
Posted by: Philip Woodgate | 09 January 2009 at 20:01
I must tell you that these the links which were provided were very useful. totally learning based, like online learning. thanks
Posted by: Joy Lynford | 05 February 2009 at 06:08
I had started following your article 3 months back and till date every article i go through is a good learning experience. thanks.
Posted by: KarROX | 17 March 2009 at 04:33