MS Excel Advanced

Home / MS Excel Advanced

MS Excel Advanced

Event Location / Date & Time: Raheen, 6th March 2018 (09:30-16:30)

Seat Rate: 10

MS Excel Advanced 

Duration: 1 Day

Date: Mon 9th April 2018

Times: 09:30 to 16:30

Venue: Aras Mumhan, Castletroy, Limerick

Course Fee: €120 per person (including 20% skillnet funding)

Course Outline:

MS Excel Advanced training is all about understanding “Why” items work in the way they do. This intensive course will prepare you for your continued lifelong learning of Excel. It will concentrate on functions and formulas and how to manipulate, manage data and to extract data from Excel.

Course Content: 

  • Nesting functions within other functions. 
  • Use data validation to force compliance with input standards.
  • Creating dynamic dropdown lists.
  • Creating Tables within Excel.
  • Using Goal Seek.
  • Creating an Array Formula
  • Create & using a Pivot Table.
  • Creating Formulas in Pivot Tables.
  • Rearranging and filtering Pivot Tables.
  • Grouping data in Pivot Tables.

Course Requirement: Participants who attend this course should have a good knowledge of Excel and should be using it on a daily basis.

Learning Outcome: The learner will improve on: setup & printing, functions & formulas, date & time functions, logical, look up functions, named ranges, cell formatting & manipulating worksheets.


For further queries contact Anne on 061 217608/ or Kinga on 061 217601 or

Facebook By Weblizar Powered By Weblizar

Can We Help You?

To find out more information or to discuss how Limerick Chamber and Limerick Skillnet can aid you in your business and training needs please contact us.

Contact Us ›