Excel Intermediate 1
Build a budget while improving the way you use Excel tables, references and formatting. The published course uses construction examples to practise a workflow that also applies to everyday spreadsheet work.
- Level
- Intermediate
- Length
- 4 hours
- Public class size
- Up to 10
Who this course is for
- People already using Excel who need the particular skills covered in this outline
What you will work on
- Build and format a budget worksheet
- Excel tables, sorting and filtering
- Absolute and relative references
- Flash Fill and Autofill
- Quick Access Toolbar and workbook views
- Selection techniques and Go To
- Print areas, orientation, headers and footers
Outline checked against the Excel Intermediate 1 booking page on . Confirm any must-have feature or software version with us before registering.
Choose your starting point
A useful starting point is Introduction to Excel or comparable experience. This is a suggested learning path unless an explicit requirement is listed below.
Review the topics in Introduction to Excel to compare your current skills.
For another step in this subject, compare Excel Intermediate 2 and check that its topics match your next task.
Browse the Excel course comparison or ask for help choosing a course.
What comes with the public course
- 90 days of course video access with class exercise files
- A free retake of the same course for one year
- A Power Concepts certificate of completion
Already registered? Use student sign-in for your account, or find course manuals and exercise files.
Excel course questions
What should I know before Excel Intermediate 1?
A useful starting point is Introduction to Excel or comparable experience. This is a suggested learning path unless an explicit requirement is listed below.
Where can I check dates and fees?
Use the course booking links on this page to see the available sessions and their current prices. Check the session time zone, delivery format, currency and tax total before completing registration.
Can my team take this training together?
Contact Power Concepts to discuss a private session. Tell us the number of learners, their current experience, the work they need to do and the software versions they use so we can recommend a suitable scope.
What certificate does the course include?
The course includes a Power Concepts certificate of completion. It is not a vendor certification exam or a professional accounting qualification.
Dates and registration
Choose a session on the booking site, then review the time zone, delivery details and final fee before registering.
Build confidence with tables and references
Excel Intermediate 1 develops the way a workbook is organised and calculated. Its published budget exercise uses construction examples, alongside tables, sorting, filtering and absolute and relative references.
A useful readiness check is whether you can enter a basic formula and explain what happens when it is copied. If that is unfamiliar, review Introduction to Excel first. For further charting, conditional functions and nested functions, compare the separate Intermediate 2 outline rather than assuming both courses have the same content.
Related options: Excel Training for Teams and Businesses; Excel skills assessment.