Enquiries:
0800 99 66 99

Microsoft Excel level 2 Intermediate

This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You'll have a powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role.

It will give you additional knowledge using more advanced formulae and functions, process and analyse data, present information, formatting, pivot tables, modification, themes, dynamic linking and updates. You'll further develop your skills and confidence with Excel.

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

This course has flexible start dates. You will attend college for one afternoon (usually Wednesday) from 1.30pm - 7.00pm.

If required, we are able to set discrete dates for employers upon request.

What will I study?

This course is flexible and can be tailored to meet individual student requirements. The course can cover:

  • 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?

The total cost of this course is £99.

What can I go on to do once I have completed this course?

Upon completion of this course you will have the opportunity to progress onto Microsoft Excel level 3 Advanced course to further develop your knowledge.

I'm interested in this course, what do I do next?

If you would like any further information in relation to this course, please contact our enquiries team directly on 0800 99 66 99 or email enquire @ sthelens.ac.uk or drop into our next Enrolment and Information Event. Alternatively, submit an application form to secure a place.

Ref: Matt Cashmore

Courses

All
Full-time
Part-time

Why study Computing and IT with us?

Microsoft Office Specialist

Impress future employers and universities by gaining MOS status alongside your course.

Tutors

Tutors are passionate about the subjects they teach with years of experience.

Progression Routes

Progress onto university, an apprenticeship or into employment.

Valuable Work Experience

Gain valuable work experience in the computing and IT industry to boost your CV. 

Diverse Range of Skills

You'll learn everything from programming and web design to multimedia application production.

Technical Support

You'll have access to the latest software to help you get the most out of your course.