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?

This course will provide you with:

• Knowledge on how to turn Excel spreadsheets into powerful engineering tools.
• Insight into creating powerful Excel engineering models, which at the touch of a button can give you critical information for daily, weekly, and monthly reports and presentations.
• Understanding Excel functionality in order to assist you in many tasks, like taking existing data and determine the y-value for a given value of x, using the “index” and “match” functionality, or use the lines function to give a least squares regression on named ranges.
• Comprehending Excel enabling you to complete tasks in Excel which you would think only more complex engineering software packages can perform.
• Tips and tricks to make your Excel easier.

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

DAY ONE

Lesson 1: Customising the Excel Environment

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

Lesson 2: Creating Advanced Formulas

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

Lesson 3: Analysing Data with Functions and Conditional Formatting

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

Lesson 4: Organising and Analysing Datasets and Tables

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

DAY TWO

Lesson 5: Visualising Data with Basic Charts

• Create Charts
• Modify and Format Charts

Lesson 6: Analysing Data with PivotTables, Slicers, and Pivot Charts

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

Lesson 7: Auditing Worksheets

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

Lesson 8: Analysing Data

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

Lesson 9: 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