Excel Zone Compendium: Working with external data (Excel 2007 update)

A

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.

Comments

Sage data to Excel 2003/2007/2010

bsnashall | | Permalink

The Analyser.  - Excel plug-in

At the click of a button, “The Analyser” extracts actual current and budget data from nominal codes, departments and funds for any date range and for any combination of nominal ranges. Additional benefits include the option to add prior year’s data alongside the current year for comparative purposes and to report on single or multiple Sage companies, all in one workbook

The Analyser was born out of the constraints other report writers place upon the user. It is an impressive yet simple, timesaving Reporting Tool that extracts the figures directly from the Sage data into Excel

Also the drill down feature allows the user, from the face of their management information, to drill down to the nominal activity not just for one code but any combination of codes all from Excel without having to open Sage.

Together with The Organiser they could then go one step further and display the scanned image. Again, all from Excel without opening Sage.

The added benefit is that the numbers are returned to Excel so the user is able to use Excel reporting and graphing capabilities to further enhance their reports. Its as good as you are in Excel.

barry@traxuk.com