Excel Intermediate
Lookups, PivotTables, charts and tidy data: the Excel skills that save hours every week.
1 day in person · 2 × 3-hour live sessions · 4 hours of eLearning Practitioner Certificate, no expiry 6 CPD hours
About the course
For people who use Excel daily and know there is a faster way. You will work through real-world files using XLOOKUP, PivotTables, conditional formatting, charts and data validation.
What you will be able to do
- Use XLOOKUP and IF functions
- Summarise data with PivotTables
- Build clear charts
- Keep data tidy and valid
What it covers
Morning
- Formulas and references
- XLOOKUP
- IF and logic
Afternoon
- PivotTables
- Charts
- Validation and formatting
Ways to take it
In person£225 per person1 day, 9:00 to 16:30, groups of up to 12Hands-on practice and time away from the desk.See dates Live online£175 per person2 live sessions of 3 hours, from 09:30Teams spread across sites who still want a trainer.See dates eLearning£65 per personAbout 4 hours, at your own pace, 12 months' accessStarting today, on a phone or laptop, around shifts.Start now BlendedFrom £225 per personDo the eLearning at your own pace, then a live half day on your own spreadsheets.Less time in the room, more time on your own work.Ask for blended At your workplaceFrom £1,100 a day for the groupUp to 12 of your people, at your site, our rooms or online, on dates you chooseWhole teams, with examples from your own workplace.Request a quote
Prices are per person plus VAT unless shown per group. eLearning works on any phone, tablet or laptop.
Your certificate
Corran AcademyCRT-7Q4K2M9D
This certifies thatAlex Morganhas successfully completedExcel IntermediateCheck this certificate at corran-academy.example/verify
- What you receive
- Corran certificate of completion in Excel Intermediate. Issued in your learner account the day you pass, as a PDF you can download and share.
- How it is assessed
- A practical workbook built during the day
- On eLearning: hands-on exercises checked as you go, then a final check
- How long it lasts
- No expiry.
- CPD
- 6 hours of learning time to record against your continuing professional development.
- For employers
- The certificate, its expiry and the learner's results go straight to your organisation's training records in GeoTalent, so you can see who is in date without chasing anyone. Check a certificate
Written to the law and guidance
The course follows these public sources. Open them to read the original wording.
Corran courses are aligned with this guidance. The certificate is issued by Corran Academy, not by the bodies listed.
Where it leads
This courseExcel IntermediatePractitioner
Good to know
- Who it is for
- Anyone who uses Excel for reports or lists.
- Before you come
- Comfortable with basic formulas.
- Certificate
- Corran certificate of completion in Excel Intermediate. How it is earned
- Ways to take it
- In person £225 · Live online £175 · eLearning £65 per person, plus VAT
- Course code
- CA-DD210
- Booking for a group?
- Add up to 12 people per date in one booking, or have us run it for your team, up to 12 people.
from £65
Next Tue 17 Nov
Digital and data
Often booked with this
Digital and dataPower BI Essentials
Turn spreadsheets into live dashboards: load, shape, model and share data in Power BI.
Next date Tue 1 Decfrom£495
Digital and dataCyber Security Awareness
Phishing, passwords, devices and data: the everyday habits that keep an organisation safe.
Next date Tue 17 Novfrom£35