aatfree wrote: »
As well as books I've always found the help section very useful - once you find what you are looking for that is!
The other place to look is the microsoft site. They have a lot of free Office training courses. Not sure which version of excel you have but here is all the Excel 2003 training videos available on the microsoft site.
A-Vic wrote: »
Can anyone either send me the link for pivot tables and how to use them ? or are they on that site - ?
ambitious wrote: »
Just to add to this thread, I did an interview with the NHS recently for a trainee accountant role and failed miserably (typical me). They set me a 5min presentation, a competancy interview and an excel test. In the excel test I was tested on 3 things. They were commenting on variances and describe trends (definitely technician level stuff), a test on finding the top 5 items by using pivot tables (I had to work that one out), and something that required VLOOKUP which I had very little knowledge of. It's funny that a lot of accountancy jobs ask for these skills yet they are never covered on the AAT. I'm sorry but if these are required then why the hell are we studying the AAT ?! Why are these not covered ? It's clear that the theory of the AAT will not land anyone a job alone, unless your lucky with your contacts.
ambitious wrote: »
Well if the AAT can offer "payroll" as an additional course I can't see why they don't offer a course in "excel" used in an accouting context. It would certainly be popular. Why leave this stuff for CPD (Continued professional development) ? AAT have excel method documents as CPD but I think that's plain daft plus they are far too simple especially when I had my interview at the NHS. The modern accountant uses excel and as theoretical as the AAT is, excel has to be an essential part of learning for everyone. Working with computers was good but there needs to be an advancement on that especially for the purpose of utilising anyone's valuable AAT knowledge. How accounting theory and excel are connected is a gap that definitely needs to be covered. Correct me if I'm wrong, but I bet this stuff is not even covered on courses like CIMA or ACCA. Using HLOOKUP, VLOOKUP, time functions, complex IF statements, conditonal formatting, macros are some things that definitely that need to be taught.
Bluewednesday wrote: »
I don't mean to sound harsh but it can't all be the AAT's fault!
Sonny_L wrote: »
Of course, serious accountants and analysts know that Lotus 123 blows Excel out of the water. :001_tt2:
The power of Microsoft for you.
Sapphire wrote: »
Would you mind emailing the excel booklet over to me please @ [email protected]
GreenMousey wrote: »
I completed an Extreme excel course Mouse
MrCoffee wrote: »
Excel is a vital finance/accounting tool but it's not something that can really be assessed by the AAT.
PGM wrote: »
Is this doing spreadsheets while hanging off a mountain?! :thumbup: