Excel Intermediate 2
Extend a budget with charts, table tools and more flexible functions. Excel Intermediate 2 introduces named ranges, multiple arguments, nested functions and check boxes used with conditional formatting or formulas.
- 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
- Create and customise charts
- Table functions, filters and slicers
- Table total rows and named ranges
- Functions with multiple arguments
- Check boxes and conditional formatting
- Conditional functions
- Nest functions within functions
Outline checked against the Excel Intermediate 2 booking page on . Confirm any must-have feature or software version with us before registering.
Choose your starting point
A useful starting point is Excel Intermediate 1 or comparable experience. This is a suggested learning path unless an explicit requirement is listed below.
Review the topics in Excel Intermediate 1 to compare your current skills.
For another step in this subject, compare Excel Advanced Functions 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 2?
A useful starting point is Excel Intermediate 1 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.
Use named ranges with a clear owner
A name such as TaxRate or ReviewThreshold can make a workbook easier to read, but the name still needs to point at the intended value. In a practice budget, change the assumption once and confirm that each dependent calculation updates correctly.
Intermediate 2 includes named ranges. Ask to inspect a name’s scope and reference, then test the workbook after adding a worksheet. That exercise helps distinguish a helpful naming convention from a hidden dependency that the next person cannot find.
Related options: Excel Advanced Functions; Excel Training for Teams and Businesses; Excel skills assessment.