Excel Level 2: Intermediate

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

Book Below via Card or Contact aidan.callan@dundalkskillnet.ie for Invoice

Book Now

Applications Closing on 21/05/2025

Enquire Now