Overview

Engineering is challenging enough, without hassling with equations, budgets, analysis of data, project schedules or Gantt charts, process experimental data, databases of clients and projects, and sometimes even manages your human resources. The ability to get the right information, to the right people, at the right time, can create a powerful competitive advantage.

This Microsoft® Office Excel® 2013-2019 course, builds upon your foundational knowledge of Excel. It will jump start you down the road with powerful Excel engineering tools and techniques, to solving challenging engineering problems. It will inspire you to build Excel engineering models, with the ability to analyse massive amounts of data, extract actionable information, and presents that information to decision makers.

NOW CPD VALIDATED WITH ECSA & SACPCMP

Why Should an Individual Attend?

• Transform Excel into a Dynamic Engineering Platform. Learn how to convert ordinary spreadsheets into powerful, automated engineering tools tailored to your technical environment.

• Build Intelligent Excel Models for Reporting Efficiency. Gain practical insight into designing Excel models that generate critical daily, weekly, and monthly insights—instantly and accurately.

• Master Data Analysis with Advanced Excel Functions. Understand how to extract meaningful results using INDEX, MATCH, and LINEST functions, including regression analysis on named ranges.

• Replicate Engineering Software Capabilities in Excel. Discover how Excel can handle complex engineering calculations and simulations—no need for costly or specialized software.

• Unlock Expert-Level Excel Techniques. Pick up tips, tricks, and shortcuts that streamline your workflow, save time, and make navigating Excel feel effortless.

Outcomes

• Customise the Excel environment.
• Create advanced formulas.
• Work array formulas, text to data, flash fill, indirect.
• Analyse data by using functions and conditional formatting.
• Organise and analyse datasets and tables.
• Visualise data by using basic charts.
• Analyse data by using PivotTables, slicers, and Pivot Charts.
• Audit Worksheets by tracing cells, troubleshooting invalid data and formula errors, watching, and evaluating formulas and creating a Data List Outline.
• Analyse data by Creating Trendlines, creating Sparklines, creating Scenarios, What-If Analysis and Statistical Analysis.
• Streamline Workflow through Updating Workbook Properties, creating Macros, applying conditional formatting and. data Validation Criteria.
• Link Spreadsheet data to buttons, spin buttons, sliders.
• Work with the Visual Basic Editor.

Program Outline

Customising the Excel Environment

• Configure Excel Options
• Customise the Ribbon and the Quick Access Toolbar
• Enable Excel Add-Ins

Creating Advanced Formulas

• Use Range Names in Formulas
• Use Specialised Functions
• Use Array Formulas

Analysing Data with Functions and Conditional Formatting

• Analyse Data by Using Text and Logical Functions
• Apply Advanced Conditional Formatting

Organising and Analysing Datasets and Tables

• Create and Modify Tables
• Sort Data
• Filter Data
• Use SUBTOTAL and Database Functions

Visualising Data with Basic Charts

• Create Charts
• Modify and Format Charts

Analysing Data with PivotTables, Slicers, and Pivot Charts

• Create a PivotTable
• Analyse PivotTable Data
• Present Data with Pivot Charts
• Filter Data by Using Slicers

Auditing Worksheets

• Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Create a Data List Outline

Analysing Data

• Create a Trendline
• Create a Sparkline
• Create Scenarios
• Perform a What-If Analysis.
• Perform a Statistical Analysis with the Analysis Tool Pak

Streamlining Workflow

• Update Workbook Properties
• Create a Macro.
• Edit a Macro.
• Apply Conditional Formatting
• Add Data Validation Criteria

Who Should Attend?

• Engineers
• Technicians
• Technologist
• Architects
• Project / Construction Managers
• Quantity Surveyors
• Construction Health and Safety
• Contractors / Sub Contractors
• Executives / Senior Management
• Middle Management