Next Live Training Date:

JHB 15-19 Aug , DBN 19-21 Sep CT 12-14 Oct

Accounting Spreadsheets

Audit Excel presents many courses to teach people how to use Microsoft Excel and to create accounting spreadsheets. It is not necessary to buy very expensive accounting software or contract the services of costly accounting professionals if you can create your own accounting spreadsheets in Excel and in this way perform all the accounting functions you require for your business.

Microsoft Excel is flexible and powerful and can be utilised to perform any type of accounting task. It is an especially favourable option for small businesses that cannot afford specialist software to legally conduct their accounting. Audit Excel’s courses will teach you to keep all the accounting data generated by Excel in one place and manipulate it at will. Routine accounting tasks become easy to perform because Excel is so efficient at automating repetitive tasks. Collaborative accounting is easy to achieve too, and may streamline processes and save time and money if several key persons in the company can quickly and easily share accounting information.

First you have to create your accounting spreadsheet before you can share it. You can set specific permissions to limit which collaborators can change which parts of the spreadsheet. In this way, you can protect and/or hide cells and formulas. Now the spreadsheet can be shared over a network so that multiple users can edit data, all at the same time, while you can track all the changes.

Microsoft Excel enables you to manipulate your accounting spreadsheets and perform multiple complex calculations on your financial data. It makes collaborative accounting available to everybody without the need for expensive software. Contact Audit Excel today and learn more about all the courses we offer to put you in command of Excel.

Free Tips & Tricks Newsletter

Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!

Handy Tips & Tricks

All the countries that use MMDDYYYY

The date format of MMDDYYYY is a potential problem for many people the world round. The main reason for this is that most people don’t understand how Excel handles dates. But first the background. Who uses MMDDYYYY Per Wikipedia  the … Continue reading

The Magic of Spreadsheets Podcast

The recent Marks & Spencer spreadsheet blunder will inevitably lead to more questions about the use of spreadsheets. In this podcast from the Financial Times, Lisa Pollack reports on the latest attempts to make spreadsheets more formal and professional. Listen to the … Continue reading

We have used AuditExcel over the last 5 years to develop large scale property modelling developments. All the templates are still in use and allow for intricate sensitivity analysis. As a result we are better able to assess projects and choose the optimal ones. Their response times also make it easy to rely on them for new developments.

– Property Modelling- Basil Read

Video Library & Tutorials //

View Entire Video Gallery ››

Making the same change to multiple worksheets in Excel

Making the same change to multiple worksheets in Excel

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Some of our Featured Clients