Course overview
This Excel course is offered one-to-one or in a small group of up to 4, because we understand that professionals have varying skill levels and varying applications. You already have the basic Excel skills but have many questions daily and want to be more proficients.
Important: If booking within 7 days of the date of the course, we will confirm availability within 24 hours
Study method
- Online
- Blended
- In-class

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.
Enrol in a course today to unlock exclusive deals.
Duration study load
- 1 Day
Course features
- Excel Intermediate course certificate on completion (assessment based)
- Excel Intermediate course notes
- Practical Excel Intermediate course exercises, Excel Intermediate course homework/Excel Intermediate course revision work
- To assist after the course, 1 free session for questions online Excel Intermediate course via Skype/Teamviewer
Subjects
- Creating Formulae in Excel, General Calculations
- The Function Wizard
- Using Functions in Excel: The 5 Popular Functions
- IF- Function
- Working with Names and Ranges
- Copying Formulae
- Lookups – Vlookup, Hlookup, Index, Match
- Working with Tables
- Working with Records and Fields
- Filters and Sorting, Freeze Panes, Split, Protecting and Unprotecting
- Using Excel as a Database- Advanced Filter
- Create a Pivot Table, Amend, Filter, Sort, Format Pivot Tables, Add Additional Formulas, Refresh Data.
- Pivot Charts
- Adding Comments
- Using Themes
- Adding Text Boxes
- Adding and Editing Charts
- Adding and Editing Sparklines
- Inserting SmartArt, Formatting SmartArt, Adding Symbols, Equations, and Shapes
About PCWorkshops
PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.
We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.
Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.