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: Karen Thorpe

Courses

All
Full-time
Part-time

Microsoft Logo
Saint-Gobain Logo
WargraveHouse Logo

Why study Computing and IT with us?

Microsoft Office Specialist

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

Industry Experts

Tutors have industry experience and a passion for the subjects they teach.

Progression Routes

Our excellent progression routes can lead to an apprenticeship, university or 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.