Spreadsheet Modelling - Intermediate

APPLY NOWAdd to Basket Download
temp
Start Date: 7 February 2023
Duration: 19 Weeks
Attendance: Part Time
Suitable for: Adults
Location: Enfield Centre

ABOUT THE COURSE

This unit is about the skills and knowledge required by an IT user to select and use a wide range of advanced spreadsheet software tools and techniques to produce, present and check complex and non-routine spreadsheets. Spreadsheet software tools and techniques will be described as ‘advanced’ because: the range of data entry, manipulation and outputting techniques will be complex and non-routine; the tools, formulas and functions needed to analyse and interpret the required information require complex and non-routine knowledge and understanding (for example, data restrictions, data validation using formula, pivot tables, data maps); and the user will take full responsibility for setting up and developing the functionality of the spreadsheet.

WHAT WILL I STUDY?

This course covers the range of skills needed:

  • For data entry, manipulation and outputting of data.
  • To create formulas and functions needed to analyse and interpret the required information.

Develope your understanding of data restrictions, data validation using formula, pivot tables, and data maps.

WHAT WILL I NEED?

All applicants must have an initial assessment and interview to confirm that the course is suitable for them.

HOW WILL I BE ASSESSED?

Assesment methods include:

  • Theory
  • Practical activities
  • Workshops

WHAT WILL IT COST?

None

WHAT CAN I DO AFTER?

Progression to higher level courses

NOT SURE WHICH LEVEL
IS RIGHT FOR YOU?

Find out more about the courses and levels offered at the College of Haringey, Enfield and North East London!

ajax-loader