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.
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.
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)
This course will start at 8:30am and till finish at 1pm and will be delivered in the Winter Gardens in Weston Super Mare.
Full Fee: £70.00 ?
Supported Fee: £70.00
HEAR ABOUT THE LATEST VACANCIES
Sign up to our Apprenticeship Vacancy Mailing list and be the first to hear about the latest opportunities