Next Live Training Date:

11-15 Aug 2014 JHB

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.

Handy Tips & Tricks

Accounting for dummies

Accounting for dummies There are many users of Excel who need to read, interpret and analyse financial statements. But, without a solid accounting knowledge, accounting jargon sounds threatening and balance sheets and income statements can be intimidating. You may feel … Continue reading

Pivot table not pulling all data

Pivot table not pulling all data Pivot tables are great tools but due to the lack of understanding of how they work we are often told that the pivot table is not pulling all the data. There could be a … Continue reading

Adrian was really good. He explained everything really professionally- Bookkeeper.
It dealt with my daily challenges at work- IS Management Accountant.
There was nothing I did not like about the workshop. Adrian was fantastic- Accountant.

– Excel Testimonials

Video Library & Tutorials //

View Entire Video Gallery ››

Clean excel data in as few steps possible

Clean excel data in as few steps possible

Solver Excel 2013

Solver Excel 2013

Offset Excel 2013

Offset Excel 2013

Vlookup Approximate Match

Vlookup Approximate Match

Some of our Featured Clients