Find your Event

50 ADVANCED TECHNIQUES FOR CREATING INSPIRATIONAL SPREADSHEETS - Recorded online course.

From April 24, 2020 09:30 until April 24, 2020 12:30

TIMING

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

COURSE FEE

£110+VAT. (click here for information on the Flexiticket discount scheme - fees as low as £61.67+VAT per place). The courses 'Why Power Query is the most important Excel development ever', 'Good Spreadsheet practice', 50 Advanced Techniques for Creating Inspirational Spreadsheets and 'More Power to your Pivot', if booked individually are available to IT Faculty members  for £60+VAT each.

COURSE CODE

AP24A0

SPEAKER

Simon Hurst

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. The examples will be based on the latest version of Excel but where an earlier version (2007 onwards) differs substantially this will be highlighted on the course

WHO SHOULD ATTEND?

The course will assume a familiarity with some Excel subjects, e.g.:

  • 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.icaew.com/en/technical/information-technology/excel/spreadsheet-competency-framework.
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 of 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
  • How Power Query changes everything. Excel without formulae.
  • Presentation – improving general spreadsheet presentation and making charts better. Using the latest Excel graphics features to create inspirational spreadsheets

VENUE

This course will be available recorded online .You will be emailed the link to join two days before the course date.

DISTRICT

South East

 

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