Overview

This focused two-day Excel course equips intermediate users with practical skills to organise, analyse, and interpret data effectively. By mastering core functions, participants will learn how to navigate Excel’s capabilities for better decision-making and clearer communication.

With Excel being a standard business tool, all staff - from entry-level to executive - benefit from knowing how to create and manage spreadsheets. This course ensures participants can confidently apply Excel across varied roles and tasks within the organisation.

Why Should an Individual Attend?

• Boost Data Confidence: Gain skills to navigate, organize, and analyze data for reporting and decision-making.
• Master Key Spreadsheet Functions: Use formulas, formatting, shortcuts, and layout tools for daily efficiency.
• Speak Excel Fluently: Understand ribbons, tabs, worksheets, and more to use the platform with ease.
• Enable Cross-Functional Excel Proficiency: Harness Excel’s capabilities to streamline data handling across technical, managerial, and support roles.
• Secure and Showcase Your Data: Ensure data integrity and enhance readability with clean formatting and themed design.
• Stay ahead with Excel proficiency: An essential tool in today’s tech-driven workplace.

Outcomes

By the end of this course, delegates will be able to:

• Understand the terminology of Excel –the “jargon”.
• Keyboard shortcuts.
• General, Editing, Navigating, Inserting, Highlighting.
• Understanding the ribbon line, the “tabs”, the icons.
• Understand the “layout “of the spreadsheet, and the concepts of Workbook, Worksheets, and the capacities of Excel.
• The individual functions within the “tabs”, viz: copy, paste, cut etc.
• The hierarchical nature of Excel.

Program Outline

Getting Started with Microsoft Office Excel 2019

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help

Performing Calculations

• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions

Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools

Formatting a Worksheet

• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

Printing Workbooks

• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers

Managing Workbooks

• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

Customising Excel

• Use and apply the Quick Access toolbar
• Understand how to set the option via the “Back Stage “view

Who Should Attend?

• Engineers
• Architects
• Project / Construction Managers
• Quantity Surveyors
• Construction Health and Safety
• Contractors / Sub Contractors
• Financial Managers and Assistants
• Executives / Senior Management
• Middle Management
• Secretaries and PAs
• Office Managers 
• Administrative Officers