Intermediate Excel for Construction

This course is 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. 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.

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