Specialising in software development for Excel
spreadsheets and Internal Audit/Consultancy
Allen Computing and Business Analysis was
established in 1998.
Services and Products
Audit and Consultancy
Analytical and Audit Software
Excel Workbooks
Examples of how Excel workbooks can be designed and used to generate fully functional
processes and methodologies without resorting to specialist code developement.
Spreadsheet design
Specialist Excel Functions
An eclectic group of Add-ins and examples of Code developed within ACBA (UK) LTD for
its own use and published free for wider availability.
- Post a String - package for manipulating string arrays
- Convert to Single Column - more manipulating string arrays
- Reset to Default - a high speed function for reformatting a
pre-selected range back to standard layout
- Merge and Word Wrap - selected cells are merged and word
wrapped with specified cells to the right while ensuring that the row height is sufficient
to keep the whole string visible
- Auto-delete Rows - built to help clean up
databases imported from other sources. Selects and deletes rows based on the value of the
first cell in the row.
- Automatic Review of VBA Code in Excel - a complete
example of a procedure for reporting the instances of a user specified string within an
Excel VB project code.
Contact
ACBA (UK) LTD, 38 London Road, Harleston, Norfolk, England IP20 9BW or by e-mail.
Mobile 0(+44)7748 195353
Personnel
Stephen Allen, MIIA
ACBA Functions - User Group
ACBA maintains a discussion forum for its software product users, who are welcome to
join. The forum is moderated by ACBA and covers technical issues, general discussions on
methodologies, answers to queries and future developments for ACBA software. Membership is
free.
Links
This site is listed with
- OzGrid.com. OzGrid has a
really fine collection of Excel files and add-ins.
- 4Tops.com Mainly for MS Access end users but also
carries a wide range of links
- willyancey.com Consultation on statistical
sampling and litigation support - sadly Will died 11 February 2010 - see tribute from Bob Jensen - Dr
Yancey's web site, however, continues for the time being
- Enable Technology Limited Specialists in Excel
2003 and a wide variety of other computer software related training.
- Blue Pecan Computer Training On-site Excel
Training in Sussex, Surrey, Hants & London, UK
- AuditNet run by Jim Kaplan is the primary on-line
resource for Internal Auditors
- Prime Office Space -
Norwich - An online service that helps businesses find office space in Norwich and
surrounding Norfolk
