Hi Nikki,
I use Excel a lot, however I would offer a few words of warning regarding the software.
If you have clients who have a large volume of transactions Excel can be unreliable, it has a tendency to crash if you over load it.
Also if your client requires their accounts audited, Excel is very easily manipulated and would present a significant audit risk to an auditor, therefore a significantly increased audit fee.
That said if your clients are just small businesses Excel is great.
Once you understand the basics of writing formula I would recommend looking at the Pivot Table function provided by Excel and the Sumif function.
Pivot tables are to large a topic to go into here, but the Sumif function give you the ability to calculate the total of entries in say column A based on Values Entered in Column B. It is a great function for calculating account totals from lists of entries.
As Helen said though if your clients already have a system your probably best sticking with that, especially if it's sage, that's the best product for the job I have ever used.
Regards IanB
|