Find your Event

GOOD SPREADSHEET PRACTICE: EXCEL FUNDAMENTALS

From March 01, 2019 13:30 until March 01, 2019 16:30

TIMING

Registration Course starts CoffeeCourse ends
13:00 13:30 15:00 16:30

COURSE FEE

£105+VAT. (click here for information on the Flexiticket discount scheme - fees as low as £58.33+VAT per place). The courses ‘Why Power Query is the most important Excel development ever’, 'Good Spreadsheet practice', ‘Practical Excel Techniques to reduce spreadsheet risk‘, 'More Power to your Pivot', if booked individually are available to IT Faculty members  for £60+VAT each.

COURSE CODE

MA01B9

SPEAKER

Simon Hurst

OBJECTIVES

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 course seeks to cover that attendees have at least the required level of knowledge and competence.

 

WHO SHOULD ATTEND?

This course is aimed at new or existing users of Excel who wish 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 course 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 Excel 2016 but where an earlier version (2007 onwards) differs substantially this will be highlighted on the course. The course is not hands-on, but the course notes have been designed to provide step-by-step instructions for all the areas covered.

This course 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.

TOPICS

  1. Excel anatomy: how everything fits together and how worksheets and workbooks should be set up to be as efficient and reliable as possible.
  2. Formula fundamentals: cell references, calculations, brackets, what the dollar signs do and why it's essential that you know. The most common Excel formula mistake and why avoiding it will save you time, effort and grief. The importance of Excel Tables.
  3. Function fundamentals: What functions are and how to use them safely. Key functions SUM(), IF(), SUMIFS(), VLOOKUP().
  4. Effective formatting: cell formats, Styles, number and date formats, Conditional formats, Charts and graphics.
  5. Fundamental featurs:working with data, Pivot tables, Data Validation.
  6. Is it right? Testing your spreadsheet and building in checks and controls.
  7. Tips and shortcuts - keyboard and other shortcuts to work more efficiently and impress your colleagues.

 

VENUE

Mercure Maidstone, Great Danes Hotel

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