SESCA Enterprises Ltd. - Professional Accountancy and Business Training
NEWS   COURSES   CONFERENCES
AND SEMINARS
  VENUES   SPEAKERS   FLEXITICKET   CPD   OTHER
SERVICES
  LINKS   CONTACT
US
 
EVENT DETAILS  
COURSE TITLE

50 ADVANCED TECHNIQUES FOR CREATING INSPIRATIONAL SPREADSHEETS

DATE Thursday 18 May 2017
VENUE Coppid Beech Hotel, Binfield near Bracknell
SPEAKER Simon Hurst
COURSE CODE MY18B7
COURSE FEE

£99+VAT. (Click here for information on the Flexiticket discount scheme - fees as low as £45.60+VAT per place) The courses ‘Good Spreadsheet Practice', '100 Ways to Make Excel Easier', ‘Practical Excel Techniques‘, 'More Power to your Pivot' and '50 Advanced Techniques for Creating Inspidational Spreadsheets', are available to IT Faculty members  for £60+VAT each.  For details of these other courses click here. Phone 01737 223999 for more details.

TIMING
Registration Course starts Coffee Course ends
13:00 13:30 15:00 16:30
OBJECTIVES

The course is designed to address some more advanced Excel features and capabilities that will be of use to those working with financial data. It is based on the very popular '100 ways to make Excel easier course' but, in the few cases where similar techniques are covered, this course will feature different or extended applications of those techniques. Some significant new features in recent versions of Excel 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 including making spreadsheets more automatic, more reliable and also increasing their impact through improved presentation. 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 will assume a familiarity with some Excel subjects, eg:

  • Absolute and relative cell references
  • Excel functions such as IF(), VLOOKUP(), SUMIF()
  • Basic chart creation
  • Basic PivotTables

This course is suitable for the levels “General User to Developer” under the ICAEW IT Faculty  Spreadsheet Competency Framework. For more information visit www.sesca.co.uk/scf.pdf.
Previous attendance on any existing SESCA Excel courses, or other similar courses, should provide adequate preparation for this course. If you already use complex financial functions, understand array formulae, make extensive use Excel form tools including PivotTables and write or edit VBA code then the course may well be of limited benefit to you.

TOPICS
  • Advanced use of functions – including using apparently simple functions to save hours of manual effort
  • Excel formulae and techniques – including array formulae, alternatives to array formulae, advanced aspects of range names
  • Macros and Visual Basic. Creating user defined functions, editing and writing macros. Increasing interactivity and automating spreadsheets with macros.
  • Data analysis tools – working efficiently with external data and using extended data tools and PivotTable features
  • Presentation – improving general spreadsheet presentation and making charts better. Using the latest Excel graphics features to create inspirational spreadsheets

 

Click here for booking form (pdf)

© SESCA Enterprises Ltd. 2001-