Excel Level 2: Intermediate – SOLD OUT

Start date: 22 September 2020

Duration: 9:30am - 12:30pm - 22nd & 23rd Sept

Location: Online - Live Webinar

Certificate: N/A

Cost: €39 for Members (€49 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 Place(s)

Applications Closing on 21/09/2020

Enquire Now