Intermediate Excel for use in Construction

Start date: 10 May 2021

Duration: 2 Half Days. Second day 17.05.21. 10am - 1pm both days

Location: Virtually

Certificate: Attendance Certificate

Cost: Skillnet Members: €230. Non Members: €295

Programme overview

To book this or any course, or for further information, please contact Liz Carroll at cpskillnet@cif.ie.

Target Audience:
Aimed at users who have basic experience with Excel and want to build on their current knowledge to set up their own spreadsheets and manipulate existing ones.

PREREQUISITES
Participants should be existing users of Microsoft Excel who can create, edit, format and print a spreadsheet. They should also be able to create basic formulae and, ideally, should have completed the Excel Introduction training programme.

Course Objectives:
Learn how to:
Create complex formulae incorporating relative and absolute cell addressing (used in BOQ, etc.)
Use a wide range of Excel functions such as Sumif, Countif, IF, Or, And, Lookups, ISError and many more
Build and apply Conditional Formatting
Link Sheets and Files
Manipulate Data – Sorting, Filtering, Validation
Create Pivot Tables
Create a wide range of Charts