Start date: 22 May 2025
Duration: 22nd & 29th May (2pm - 5pm)
Location: Online - Live Webinar
Certificate: N/A
Cost: €99 for Members (€129 for Non Chamber Members)
Course code: N/A
Programme overview
Take your Excel skills to the next level with our Excel Level 2 – Intermediate course. Designed for users who are comfortable with the basics, this practical, hands-on training builds on foundational knowledge to introduce more advanced features such as formulas, functions, data management, and chart creation. Whether you’re working in finance, administration, or project coordination, this course will equip you with the tools to work more efficiently and confidently with spreadsheets in a business context.
Learning Outcomes
- Create an IF Function
- Nest AND, OR and IF Functions
- Sum If, Count If
- Create Named Cells
- Create Named Ranges
- Create drop down lists
- Use the VLOOKUP Function
- Use the HLOOKUP Function
- Text Functions & manipulating Text
- Subtotal Data
- Pivot Tables
- Pivot Table Charts
Who Is This Course For?
This course is perfect if you have an understanding of the fundamentals of Excel and would like to progress to more advanced features.
Modules
- Create an IF Function
- Nest AND, OR and IF Functions
- Sum If, Count If
- Create Named Cells
- Create Named Ranges
- Create drop down lists
- Use the VLOOKUP Function
- Use the HLOOKUP Function
- Text Functions & manipulating Text
- Subtotal Data
- Pivot Tables
- Pivot Table Charts