Excel Intermediate 1
The step from typing numbers into a grid to building a workbook that calculates, sorts and summarises without manual rework.
- Level
- Intermediate
- Price
- On the schedule
- Length
- See schedule
- Class size
- Max 10
Who this course is for
- Anyone comfortable entering data who is still summarising it by hand
- People who use Excel daily but avoid anything past SUM and AVERAGE
- Users whose files have grown past the point where scrolling is a strategy
What it is built around
Excel Intermediate 1 is built around 5 areas: Tables, Sorting and filtering, Absolute and relative references, Multi-sheet workbooks, Charts.
The detailed outline lives in the booking system, not here. Duplicating a syllabus onto a marketing page is how the two drift apart, and a stale outline is worse than a link. The live listing has the current one, alongside dates and pricing.
Before and after
This course assumes Introduction to Excel, or the equivalent experience — you do not need to have taken it with us. If you are not sure you are at that level, the skill assessment will place you.
The natural next step is Excel Intermediate 2, which assumes what this course covers.
Scroll the diagram sideways to see the full path.
Dates and registration
Dates, prices and registration for Excel Intermediate 1 are handled in our booking system, which is always current. See the schedule and register. Prefer to talk it through? Contact us and we will help you pick the right level.
What comes with it
- 90 days of video-library access with the class exercise files
- A free retake for one year
- A class of no more than 10 people
- A certificate of completion
Free guides on this material
If you want to work on some of this before the course — or decide whether you need it at all — start with XLOOKUP vs INDEX MATCH, slicers on pivot tables and the IFS function. They are free and ungated.
Excel Intermediate 1 questions
What do I need before taking Excel Intermediate 1?
Introduction to Excel, or the equivalent experience — you do not have to have taken it with us. If you are unsure, the five-minute skill assessment will tell you whether to start here or a level below.
How much does it cost?
Pricing for this course is held in the booking system rather than duplicated here, so it cannot go stale. The live schedule shows the current price alongside the dates.
Is it delivered in person or online?
Both, and it is the same course either way. For remote delivery we use software that lets the instructor see every participant’s screen, so if something goes wrong on your machine the instructor sees it rather than waiting for you to describe it.
What if I need to take it again?
You can retake this course free for one year, on every course in the catalog. You also get 90 days of access to the video library covering the material, with the exercise files used in class.
Do I get a certificate?
Yes, a certificate of completion naming the course and the date. It is a PowerConcepts certificate rather than a Microsoft certification exam — the training is good preparation for one, but the exam is booked separately.