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.