This course is aimed at the more experienced Excel user who wishes to consolidate their knowledge and learn some new features.
If your job involves working with Excel manipulating and analysing data in Excel, you will find this course very useful. This course is aimed to help you fill in gaps in your knowledge.
During the day we will look at many advanced functions such as Lookups, COUNTIFS, SUMIFS, What IF functions and Scenario building. You will also be shown short cuts and tips on creating spreadsheets quickly including the use of macros. We will build on skills to import data into Excel, prepare it and set up pivot tables to analyse it.
Topics covered include:
- Data Validation and Data Validation Lists
- Countif/ Countifs, Sumif & Sumifs
- Array Formula
- Importing External Data & Working with Data Lists
- Working with Pivot Tables & Pivot Chart Reports
- Using VLOOKUP
- Using HLOOKUP
- Creating Macros
- Protecting Cella and Work Books
The course is workshop based and can be adapted to your personal requirements.
There is no assessment with this course, however, you will receive a certificate of attendance.
You should have some prior experience of Excel. This is not a course for the IT beginner nor is it suitable for learners who have only recently completed the Introduction to Excel course. Some consolidation of learning needs to take place before attending this course.
After Your Course
This is a useful course for all working in the administration and IT industries.
Course fees are per year. There may also be additional costs associated with the course (please see the course overview).
Whether you qualify for student finance depends on specific criteria. The main student finance package for full-time students includes a tuition fee loan and maintenance loan for living costs. Part-time students can access a tuition fee loan to pay for your course.
Generally, you will only get student finance if you’re doing your first degree-level qualification. This is true even if your previous course was self-funded.
For further information please see www.gov.uk/student-finance
Access to Learning Fund
The Access to Learning Fund is a non-repayable discretionary fund that gives students facing hardship extra financial support to access and remain in higher education. This can is accessed via the college. Contact Student Services for more information: firstname.lastname@example.org / 01539 814700