Next Live Training Date:

13- 17 May, 2013

Consolidate Spreadsheet Information

“Every month we get over 30 spreadsheets mailed to us and my PA spends a day copy and pasting the information into one spreadsheet. There must be a better way?”

Spreadsheets are often used to collect and collate data to create useful reports. But that often means someone receiving spreadsheets and then manually consolidating them. Copy paste, copy paste for the whole day is not a productive use of time and more importantly it has significant risk or errors.

We can help so that the first entry into the spreadsheet is the last one. Whether we use Excel or another technique you will be able to seamlessly consolidate spreadsheet information into a single spreadsheet or database, allowing you to focus on the results and not on accumulating the data.

Contact Adrian at Adrian@AuditExcel.co.za with your query

Handy Tips & Tricks

Advanced Excel Course

Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading

Creating a Waterfall Chart in Excel the easy way

A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading

"The best Excel course I've ever attended. Thanks!"- F. Swanepoel Sun International

– F. Swanepoel – Sun International

Video Library & Tutorials //

View Entire Video Gallery ››

Spreadsheet tests

Spreadsheet tests

Spreadsheet Change Control

Spreadsheet Change Control

Waterfall chart using stock charts

Waterfall chart using stock charts

Absolute and Relative cell references

Absolute and Relative cell references

Some of our Featured Clients