Microsoft Excel for Engineers

An intensive 2-Day working course

Overview:

We start by reviewing the basics to fill possible gaps in your knowledge. We then build through simple uses to complex examples, using typical engineering problems. We also introduce the advanced feature of programming macros in Visual Basic.

Who should attend?

Engineers, Engineering Technologists and Technicians who have a basic knowledge of Microsoft Excel (possibly self taught), and want to learn how to apply Excel to their discipline should attend and will certainly benefit from this intensive training webinar

Date:

27-28 June 2024
(2 Day Training)

Time:

8:30 – 16:30 daily

Points:

2 CPD Points ECSA

Fees:

R6490 ex VAT (Early Bird)
R6999 ex VAT (Standard)

About:

This is a intensive  2-day working and interactive training webinar covering in detail Microsoft Excel specifically for Built Environment Professionals,

The training is accredited with the following councils/associations:

ECSA- 2 CPD Points

Catering services will be offered by UBER Eats- Delegates to receive meal vouchers Daily, provided Uber Eats is available in your area*

Day 1

– Introduction: Prerequisites, Duration, Conventions, Notes
– Excel as an Engineering and scientific Tool
– Review of Basics: Screen Layout, Moving Around, Selecting Cells, Copying and Moving, Formatting Cells, Entering and – – – Editing Data Overview of the Menus (Excel 2003 and earlier) or the Ribbon (Excel 2007 and Excel 2010)
– Useful Shortcuts
– Handy Toolbar Buttons (only Excel 2003 and earlier).
– Simple Formulas and Formatting
– Other Useful Features: Tools > Options, Range Naming (Pipe Flow example), Freeze Panes
– Printing: Print Area, Preview and Print
– Good Worksheet Design
– Some Advanced Functions: Financial, Date / Time, Mathematical and Trigonometric, Statistical, Lookup & Reference, Database, Text Functions, Logical, Information
– Excel Add Ins

Day 2

– Creating and Working with a Database: Using a List as a Database, Data Forms, Filtering and Sorting Data
– Groups and Outlines: Creating an Outline Automatically or Manually, Removing an Outline
– Pivot Tables
– Scenario Manager
– Goal Seek
– Solver: Using Solver, Solver Special
– Reports, Linear and Non linear Problems, Example
– Graphs
– Introduction to Macros: Macro Security, Recording a Macro, Running a Macro, The Visual Basic Editor, Modifying Visual Basic Code, Assigning a Macro to a Worksheet Button and a Toolbar Button
– Iterating for a Solution: Using Copy Down, Circular References, a Macro
– Using Excel as a Pre Processor:
– Exporting Data
– Using Excel as a Post Processor:
– Importing Data
– Final Examples: Pipe Flow Calculation, Survey Calculations, Reservoir Simulation
– The Course examples as supplied.

How Much?

Early Bird: R 6490 + vat
Standard: R 6999 + vat

When?

Date: 27-28 June 2024
Time: 08:30am – 16:30pm (CAT Daily)

Discounts?

3-5: 5% off
6-11: 10% off
+11: 15% off

FAQ:

This is a intensive  2-day working and interactive training webinar covering in detail Microsoft Excel specifically for Built Environment Professionals,

The training is accredited with the following councils/associations:

ECSA- 2 CPD Points

Catering services will be offered by UBER Eats- Delegates to receive meal vouchers Daily, provided Uber Eats is available in your area*

What Do I Need?

Each delegate will need the following to attend:

  • Steady Internet connection for the duration of the training
  • Laptop / PC / Smart Phone and Power supply (Charger)
  • Zoom Meeting Software installed onto your laptop /
  • PC / Smart Phone
  • Quiet Space

Preferable but not compulsory:

  • Headset / Ear Phones to clearly hear the facilitator

About The Trainer?

Rick Ruibenheimer graduated in 1975 from University of the Witwatersrand with a B.Sc.( Eng )(Civil). Prizes for the best reinforced concrete design. Qualified as Professional Engineer (Pr. Eng.). In May 1982, joined WLPU Consulting Engineers (now Knight Piésold ), in Braamfontein. Promoted to Principal Engineer. After a variety of Civil Engineering design work,
gravitated to the computer section, working on an HP1000 minicomputer as joint System Manager, Hewlett Packard desktop computers, and PC’s in 1986. Did in house PC training for WLPU on introduction to PCs, DOS, Multimate , GW BASIC and Lotus 1 2 3.

Terms & Conditions

Payment Terms:

  • Payment is required within five (5) working days on receipt of tax invoice.
  • Following completion and return of the registration form, full payment is required within five (5) working days from receipt of tax invoice.
  • We reserve the right to refuse admission and withhold CPD points and certificate if payment is not received on time, a payment or an official purchase order must be received prior to the conference or training seminar.

Fees:

  • Fees are exclusive of VAT
  • Bulk discounts are not calculated on early bird price. Invoiced amounts need to be paid on or before the early bird date to receive the rate.

Cancellation Policy:

  • All cancellations must be sent in writing at least 10 working days prior to the event.
  • Cancellations within 10 working days before the event starts will not receive any refund and will be liable for the full invoiced amount, however, a substitution of the delegate will be allowed.

Indemnity:

  • Should for any reason outside the control of BEST Training events, the dates or speakers change, or the event is cancelled due to an act of terrorism, extreme weather conditions or industrial action, BEST Training shall endeavour to reschedule but the client hereby indemnifies and holds BEST Training harmless from and against any and all costs, damages and expenses, including attorney’s fees, which are incurred by the client.
  • The construction, validity and performance of this agreement shall be governed in all respects by the laws of South Africa and to the exclusive jurisdiction of whose courts the parties hereby agree to submit.

No-shows:

  • Registrants who do not attend the event, without written notices as per the cancellation policy will be liable for 100% of the invoiced amount.

Important Notice:

  • The booking form below constitutes as a legal binding contract.
    Whilst every reasonable effort will be made to adhere to the advertised brochure(s), BEST Training reserves the right to change dates of events if the need arises.

GET IN TOUCH WITH US

We want to hear from you. The team at BEST Training has experience in the Built Environment and offers a range of various courses and webinars when you need it most.

If you have ANY questions, contact us.