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 course builds upon the individuals 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

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

• Individualise Your Excel Workspace: Customise the Excel environment to work smarter and more efficiently.
• Build Powerful Formulas: Create advanced formulas to automate calculations and improve accuracy.
• Master Advanced Data Tools: Work confidently with array formulas, Flash Fill, Text to Columns, and INDIRECT functions.
• Turn Data into Insights: Use functions and conditional formatting to analyse and highlight key information.
• Manage Data Like a Pro: Organise, structure, and analyse datasets and tables with ease.
• Bring Data to Life: Create clear and impactful charts that communicate information effectively.
• Unlock the Power of PivotTables: Analyse large volumes of data using PivotTables, Pivot Charts, and slicers.
• Troubleshoot with Confidence: Audit worksheets, trace errors, and validate data for reliable results.
• Forecast and Model Outcomes: Apply trendlines, scenarios, What-If Analysis, and statistical tools to support decision-making.
• Automate Repetitive Tasks: Streamline workflows with macros, data validation, and advanced formatting tools.
• Create Interactive Dashboards: Link spreadsheet data to buttons, sliders, and other controls for dynamic reporting.
• Explore Excel Automation: Work with the Visual Basic Editor to enhance functionality and productivity.

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