Excel Level 2: Intermediate

Start date: 08 October 2024

Duration: 8th & 9th October (9:30am - 12:30pm)

Location: Online - Live Webinar

Certificate: N/A

Cost: €99 for Members (€129 for Non Chamber Members)

Course code: N/A

Programme overview

Excel is the most in commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light.

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 Now To Guarantee a Place

Book Now

Applications Closing on 07/10/2024

Enquire Now