St Helens College and Knowsley Community College Online Store
Cart 0
Microsoft Excel Level 2 - Intermediate

Microsoft Excel Level 2 - Intermediate


Microsoft Excel level 2 (Intermediate) - using more advanced formulae and functions, process and analyse data, present information, formatting, pivot tables, modification, themes, dynamic linking and updates, etc. - users looking to further develop skills and confidence.

When will I start the course and how long will it take?

This course has various start dates throughout the year. 

What will I study?

This is just a 'flavour' of the content - as we will tailor the course to meet your individual requirements.

  • Create more advanced formulae including logic statements
  • Use Specialized Functions
  • Apply Cell and Range Names
  • Data validation
  • Sheet protection
  • Calculate Data across Worksheets
  • Analyse Data with Logical and Lookup Functions.
  • Create basic macros
  • Use form controls
  • Sort or Filter Data
  • Use Functions to Calculate Data
  • Create a Chart, modify Charts, format Charts
  • Create a PivotTable
  • Customise the Excel Environment
  • Customise Workbooks
  • Manage Themes
  • Create and Use Templates

What are the course fees?

Course cost: £99.

Typical Itinerary of the day:
Start time - 13.30: Arrival at St Helens College Main Reception. Candidates will be collected and escorted to training room.

Session will consist of: Approx. 5 hours of tutor led/supported delivery. Registration, enrolment then session overview followed by tutor facilitated delivery / instruction / support / exercises. This will be a practical hands-on session pitched at the level of the candidates. Break times negotiable.

Once you have received your order confirmation for the course, a member of our Computing department will contact you via email to arrange the date for your course. 

Share this Product

More from this collection