Excel training - Bales Chartered Accountants

BALES, Chartered Accountants, Nailsea

Business accounting, taxation, computing and planning. Personal taxation.

Specialising in providing a full and friendly service for small to medium sized businesses and a personal tax service tailored to the needs of individuals. Serving clients both local and distant

Excel Tutorial Package-

An Introduction to Macro Writing For Programming in Excel

Improve the functionality of your spreadsheets by using macros.

This tutorial package is a comprehensive introduction to macro writing for Microsoft® Excel users, which teaches you how to program the software with Visual Basic for Applications (VBA) language. It starts with an explanation of the software facilities and then leads the reader through the steps to build simple macros. The tutorial then explains how to efficiently combine several macros into one so that a number of operations, both simple or complicated, are carried out simultaneously and automatically by one single mouse click or keyboard stroke. Examples of the code are included at frequent intervals in the tutorial and tips on troubleshooting are included in an appendix.

This is a short extract from one of the many examples of the VBA code included in the tutorial -

Rows("9:9").Select ' The user selected the entire row.

Selection.Insert Shift:=xlDown 'A row was inserted.

- showing the actual VBA code in black and an explanation of its purpose in green.

The tutorial compendium includes an introductory "Read me first" file and the tutorial file, both in Microsoft Word .doc file format, an illustration automated workbook file and a sample data workbook file, both in Microsoft Excel .xls file format, and 2 screenshot picture files. All files are packaged together in a WinZip® self-extractor in order to minimise download time and facilitate easy file decompression for those without file compression software on their computers.

Written with the non-technical user in mind, this tutorial package is a comprehensive introduction to macro writing for both home and business Excel users wanting to extend their knowledge of the capabilities of Microsoft's powerful Excel spreadsheet software. It would also prove to be useful resource material for the professional trainer. After working through this tutorial, the reader will be able to significantly improve the functionality of their spreadsheets.

Written by Chris Bales in conjunction with James Thorne, a Microsoft Certified Excel Expert, this tutorial was an immediate success when it was listed on the award winning AccountingWEB Internet site. AccountingWEB is the winner of the New Media Age 2001 "Best Media Business Website" award.

PURCHASING OPTIONS

Online United Kingdom and International customers can purchase the tutorial package for delivery by email file attachment for just £5.00 (GBPounds). International customers please note that the tutorial is only available in English language and payment must be received in GBPounds by PayPal only. We would prefer United Kingdom customers to pay by PayPal but payment may be made by cheque drawn on a UK bank or Building Society account. Supply will be made within 24 hours of receipt of cleared funds.

United Kingdom customers wanting to receive the tutorial package on CD delivered to a UK address – Payment of £6.00 (GBPounds) can be made by PayPal or by sterling cheque for £6.00 drawn on a UK bank or Building Society. If sending payment by cheque, please do not forget to include your name and delivery address. Your CD will be despatched within 24 hours of receipt of cleared funds

International customers wanting to receive the tutorial package on CD - Please contact us by email so that we can calculate and advise the postage cost.

NOTE 1: The Tutorial is for Excel 97 and later versions and is compatible with Microsoft Office 97 upwards.

NOTE 2: Transmission by Email file attachment. Please note that Outlook 2002, either as an independent program or as part of Office 2002, together with Outlook 2000 patched to SR2 status (service release 2), may not permit the download of .exe executable Email file attachments. If you would be affected by this issue, electronic delivery can be still easily be made using one of the following four options - (A) Use Outlook Express to receive the covering message and file attachment, or (B) Receive the message and attachment into Outlook and then import the message into Outlook Express, or (C) request us, at the time of ordering, to send the file in non self-extracting WinZip format, or (D) request us, at the time of ordering, to send the files as separate files but, in which case, please be aware that the total of the file attachments will aggregate to very nearly 2 MB. Option C is clearly the easiest of the four options but you will need to have file compression software on your machine in order to unpack the condensed file.

Please contact Chris Bales for further information.

BALES, Chartered Accountants, 15 Cheddar Close, Nailsea, Bristol BS48 4YA

Telephone: 01275 854237 Facsimile: 01275 855058 E-mail: c.bales@bales.uk.com

Please print and/or bookmark this page now for future reference.

http://www.bales.uk.com or http://www.chartered-accountant.uk.com

Have you visited our useful links page yet? click here