Find your Event

PRACTICAL EXCEL TECHNIQUES TO REDUCE SPREADSHEET RISK

From September 14, 2017 09:30 until September 14, 2017 12:30

TIMING

Registration Course starts CoffeeCourse ends
09:00 09:30 11:00 12:30

COURSE FEE

 £99+VAT. (click here for information on the Flexiticket discount scheme - fees as low as £45.60+VAT per place). The courses ‘Using the latest versions of Excel’, ‘Practical Excel techniques‘, 'More Power to your Pivot' and '100 ways to make Excel easier', if booked individually are available to IT Faculty members  for £60+VAT each.

COURSE CODE

SE14A7

SPEAKER

Simon Hurst

OBJECTIVES

There is growing concern over the risks associated with the use of spreadsheets in all aspects of business. This course will concentrate on some practical tips and techniques to help reduce those risks. Some significant new features in Excel 2007 through to Excel 2016 will be covered, but most of the course will be relevant to users of any Excel version. The intention is to cover areas that provide real practical benefits which not  only make spreadsheets more robust and more reliable, but also improve efficiency and performance. Please note, the course is not hands-on but comprehensive notes will be provided to allow  you to explore the areas covered in more detail.

WHO SHOULD ATTEND?

The course should be useful to anyone who uses Excel or is responsible for the use of Excel in their organisation. It will cover both basic and advanced features in the context of the avoidance and detection of spreadsheet errors.

This course is suitable for the levels “General User to Creator” under the ICAEW IT Faculty Spreadsheet Competency Framework.

TOPICS

  • Firm foundations – how to design your spreadsheets to minimise the risk of errors. The  basic Excel techniques and knowledge that underpin efficient and reliable spreadsheets.
  • What not to use Excel for. Why Excel can't manage data. How best to get your data into Excel.
  • Managing input – Data Validation and Protection
  • Robust formulae – designing formulae to work reliably and adjust for changes
  • Checks and controls – the Excel functions that can help spot errors for you and bring them to your attention
  • Auditing tools – Excel's built in error-checking and why you shouldn't rely on it. The Formula Auditing tools and other techniques to reveal errors and inconsistencies.
  • The workbook review and auditing tools introduced in Excel 2013

VENUE

Solent Hotel Whiteley Fareham

DISTRICT

Southern

 

 

 


Find out about the SESCA Flexiticket

The more you buy the cheaper they get

The Flexiticket offers one of the best value for money CPD discount schemes. Tickets are totally transferable and may be used by any number of individuals from different organisations, allowing smaller groups and sole practitioners and members in business to club together. Tickets are valid for up to 13 months, as they expire 12 months from the last day of the month in which they are paid for.

 

Find out more

Flexiticket