Excel

[Mathew]

Anyone no a good little tips and tricks site for Excel. As I will be getting tested on the basics and need to dust up.

 

[Spire]

http://www.mrexcel.com/podcast/learnexcelpodcast.html

 

[John Stokdyk]

Pay a visit to ExcelZone on AccountingWEB: accountingweb.co.uk/excelzone

I'm not allowed to post links yet (still got 11 more posts to go) but there are a bunch of tutorials there, starting with our "ExcelZone Compendium" which contains pretty much everything you might have wanted to ask, but were afraid... Search for "Compendium" on the site's search box to find it.

If this is the sort of thing that you'd like to get on a regular basis, you can also subscribe to our fortnightly newswire.

Maybe there's another way I can get the links to you...

 

[DanMartin]

Further to John's comments, here are the links he was referring to:

Content on AccountingWEB's ExcelZone:
www.accountingweb.co.uk/excelzone.

John has been running this for a couple of years now and we've assembled quite a good collection of free tutorials.

The "ExcelZone Compendium" which contains pretty much everything you might have wanted to ask:
http://www.accountingweb.co.uk/item/141045/1032/1033/1026

It may be a bit overwhelming, but look for summary articles at the top of each individual section. For more digestible tips, have a look at:

Two minute Excel tips
http://www.accountingweb.co.uk/item/168307/1032/1023/1026

Improve your reporting skills with self-teach tutorials
http://www.accountingweb.co.uk/item/161080/1032/1023/1026

Or for something a little more sophisticated, see some of the pivot table tutorials we have:
http://www.accountingweb.co.uk/item/141552/1033/1026

Five Minute Pivot Table Tips
http://www.accountingweb.co.uk/item/141552/1032/1033/1026

If this is the sort of thing that you'd like to get on a regular basis, you can subscribe to the fortnightly ExcelZone newswire here:
https://secure1.accountingweb.co.uk/cgi-bin/register.cgi?page=0

Go to the MyNewswires link and make sure to tick the ExcelZone newswire option - or any others that you might like to get from AccountingWEB.