Excel Level 2: Intermediate

 

Date

 

Monday 25th September

 

Duration

 

One day.

 

Start & Finish Time

 

9.30 am- 4.30 pm.

 

Trainer

 

Gary Pleasey, Direct Training Ireland

 

Places

 

Places are available

 

Location

 

 Wexford Chamber Boardroom, Wexford Chamber of Commerce, Hill Street, Wexford

 

Price

 

€125 per person if you are a member of Wexford, Enniscorthy, New Ross or Gorey Chamber a 10% discount applies.

 

To book this course please contact Emma Larkin at admin@wexfordchamber.ie or by phone on 053 91 22226

 

Overview

At the end of this course participants will have a better understanding of how formulas are constructed and will have a thorough knowledge of how to structure a spreadsheet and database within Excel.

This course is specifically for those who already have some experience of Excel and know how to input data into a spreadsheet. It will specifically be of interest to those who are working on spreadsheets created by others but want to know how to set up and manage their own workbooks.

Syllabus

    Understanding the difference between “relative” and “absolute” cell references.

    Defined Names of cells and ranges and using the Name Manager.

    Create custom formats for dates and numbers.

    Use the IF function.

    Understand and use the VLOOKUP and HLOOKUP functions.

Learn how to use the SUMIF(s), COUNTIF(s) and AVERAGEIF(s)       functions.

    Work with Text by using the common Text functions.

    Import data from other systems and clean it up.

    Review the basics from Level 1 Excel

    Learn how to prepare a basic Pivot Table    Average – AverageIF – AverageIFs – Clean – Concatenate – Count – CountIF – CountIFs – CountA – Countblank – Exact – HLookup – IF – Left – Lower – Max – Mid – Min – Now – Proper – Right – Sum – SumIF – SumIFS – Today – Trim – Upper – VLookUp

Trainer Profile

 Direct Training Ireland specialises in training individuals and groups to the highest standards using the most efficient and up to date methods.

Direct Training Ireland is a Certified Training Centre. (C.T.C.).   The Irish Computer Society – (ICS Skills) recognises and certifies top quality training and test centres on the basis of specific criteria of training excellence.

“The key to excellence in training delivery is the expertise of the trainer, and the CTP programme guarantees that the holder of this qualification has demonstrated a high level of competence in the planning, delivery and evaluation of training”.

 

For further details and booking contact: Wexford Chamber Skillnet

Telephone: (053) 912 2226 Email: admin@wexfordchamber.ie

 

This entry was posted in Wexford Chamber Skillnet. Bookmark the permalink.


Comments