Level 1
Excel Advanced Short Course (half day)
Level 1
Excel Advanced Short Course (half day)
Ready to take your Excel skills to the next level? Our Excel Advanced Short Course is ideal for adults who already understand the basics and want to work more efficiently, confidently, and professionally with data.
What will I study?
In this practical, hands-on half-day session, you’ll explore powerful tools including advanced formulas like IF and VLOOKUP, data validation, and PivotTables—helping you analyse, manage, and present data with ease. You’ll also learn how to streamline your work using smarter formatting techniques and dynamic charts.
What you will learn:
Advanced Formulas
- Logical functions: IF, AND, OR
- Lookup functions: VLOOKUP, HLOOKUP, INDEX-MATCH
- Text functions: LEFT, RIGHT, MID, LEN, CONCATENATE, TEXTJOIN
- Advanced Aggregates: SUMIF, COUNTIF
Advanced Formatting
- Managing multiple worksheets in a workbook
- Custom number formatting
- Conditional formatting with formulas
- Using themes and cell styles
Working with Tables and Data Validation
- Creating and formatting Excel tables
- Structured references
- Data validation: drop-down lists, input messages, error alerts
PivotTables and PivotCharts
- Building PivotTables
- Grouping, filtering, slicers
- Creating PivotCharts
- Advanced charts (combination charts, scatter plots)
Course Details
Course: Excel Basics Short Course - Half Day Location: Winter Gardens, North, Royal Parade, Weston-super-Mare BS23 1AJ Date: 10th June 2026 Duration: Half day from Time: 13:30 to 17:00 Delivery: Face to face Cost: £65 per person
Full Fee: £0.00 ?
Supported Fee: £0.00
Most people qualify for FREE tuition and material fees due to discounts we offer. Click on the icon(s) below to find out what you’ll need to pay.
HEAR ABOUT THE LATEST VACANCIES
Sign up to our Apprenticeship Vacancy Mailing list and be the first to hear about the latest opportunities