Principle 3 of the ICAEW 20 Principles for good spreadsheet practice states ‘Ensure that everyone involved in the creation or use of spreadsheets has an appropriate level of knowledge and competence’. This lecture seeks to ensure that attendees have at least the required level of knowledge and competence to cover the basic and general user categories within the ICAEW Spreadsheet Competency Framework.
Target audienceNew or existing users of Excel who want to ensure that they possess the skills and knowledge required to use Excel efficiently and safely while delivering effective and reliable end results. No particular prior knowledge is required. If you are already an experienced Excel user with a comprehensive understanding of a wide range of Excel features and functions then the lecture might be of limited direct benefit, although it might still be a useful guide to understanding what others working with spreadsheets in your organisation need to know. Examples will be based on the latest version of Excel but where an earlier version (2007 onwards) differs substantially this will be highlighted in the lecture. The lecture is not hands-on, but the notes have been designed to provide step-by-step instructions for all the areas covered.
This lecture is suitable for the levels ‘Basic User to General User’ under the ICAEW IT Faculty Spreadsheet Competency Framework. For more information visit www.icaew.com/en/technical/information-technology/excel/spreadsheet-competency-framework.
Reduced rates for unemployed members, please contact Linda Conway +44 (0)121 270 8942 for details.
Discount informationBlock booking of one place on all six tax, practice or business courses: £315.00 +VAT (block booking discount does not apply if mixing and matching between the tax, practice and business courses).Individual courses: £63.00 +VAT.Reduced rates for unemployed members, please contact Linda Conway +44 (0)121 270 8942 for details.The lecture programmes are not subject to any further discount.Please note that the discount will be automatically applied on checkout once six of the respective courses are added to your basket.
Commercial and business programme
Employment taxes, IR35 and PAYE update
15 October 2019
Charities – current issues
01 October 2019
Tax update for accountants in business
24 October 2019
Taxation of farming
28 November 2019
Selling accountancy services
03 December 2019
IFRS update for accountants in business
14 November 2019
Finance Act/Bill – including the annual Budget update
18 March 2020
12 March 2020
Trust and estate planning
21 May 2020
Good spreadsheet practice: Excel fundamentals
21 April 2020
Personal tax update, including UK tax residence issues
13 October 2020
Audit and financial reporting update
19 May 2020
Exploring shareholder value
14 May 2020
12 November 2020
Acting for healthcare professionals
22 September 2020
Groups of companies - taxation and planning
1 October 2020
Simon Hurst, a Chartered Accountant has been involved in computer software for over 30 years. His training organisation, The Knowledge Base (www.tkb.co.uk) provides a wide range of training and consultancy services to accountants and other professionals. Simon writes for several websites including the ICAEW Excel community and is a former chairman of the IT Faculty. He was part of the groups that produced the ICAEW Twenty principles for good spreadsheet practice and the Spreadsheet Competency Framework.
If you are an ICAEW Member or Student or have already created an Account please login below. Otherwise please create an Account.
This screen shows you the details for the selected product.
Click the "Add to Cart" button to add this product to your shopping cart. You can enter a quantity larger then 1 to add multiples of this product to your shopping cart.
If the product is full you will see a "Wait List" button. Click this button if you would like to be notified if/when capacity is added. If capacity is increased we will email you. Upon receipt of the increased capacity notification, registration will be on a first-come, first-served basis.
If the product is not ready for purchase you will see a "Notify Me" button. You can click this button if you would like to be notified when this product is ready for purchase.
Some products can only be purchased through our partner. In this case you will see an "External Register" button. Click this button to purchase through our partner's website.