Microsoft Excel Advanced

 

MS Excel Advanced

 

 

Cost: €120.00pp

 

Date: 18th of April

 

Location: Raheen, Limerick

 

 

Contact Rachel  or Paul  to book at rjoyce@limerickchamber.ie / training@limerickchamber.ie  or call 061 217605 / 061 217601

 

Introduction: Ms Excel Advanced 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 Rachel on 061 217605 or rjoyce@limerickchamber.ie

Back

Share On.....