Home | About Us | Feature | Programs | Support | Training | Development | Downloads | Free Tools | Newsletter | Links | Contact

Training Course Fact Sheet:
Microsoft Excel for Engineers

Microsoft Office Excel is (pardon the laboured pun) an excellent engineering and scientific tool.  Not only does it have all basic mathematical functions, it has advanced statistical functions, matrix manipulation, charts, and much else.  Are you, as an engineer, using it to the full?  Are you aware of how much it can do?  Many of us are self-taught and have gaps in our knowledge.  Fill those gaps on the Excel for Engineers training: two full days of personal attention in a small class.

The course is intended for Engineers, Engineering Technologists and Technicians who have a basic knowledge of Microsoft Excel, probably self-taught. We start by reviewing the basics to fill possible gaps in your knowledge. We then build through simple uses to more complex examples, using typical engineering problems. We also introduce the advanced feature of programming macros in Visual Basic for Applications (VBA).

Next Scheduled Course: Thursday 24 and Friday 25 February 2022 (two days, 08:00-17:00 CAT).

Following Courses:

Thursday 28 and Friday 29 April 2022 (two days, 08:00-17:00 CAT).
Thursday 23 and Friday 24 June 2022 (two days, 08:00-17:00 CAT).
Thursday 25 and Friday 26 August 2022 (two days, 08:00-17:00 CAT).
Thursday 27 and Friday 28 October 2022 (two days, 08:00-17:00 CAT).

Venue: Live Online via Zoom.  65-page PDF manual is supplied, and 14 examples files.
Special Price if paid not later than two weeks before the start of the course: Only R4,500 plus VAT per trainee.
Thereafter R5,000 plus VAT each.

Course Creator and Facilitator: Rick Raubenheimer B Sc (Eng) (Wits) (1975).

For more information and to book a course online or in-house at your company, click here and send the resulting email or email info@softwareafrica.co.za

Are you unable to attend live?  Or you find the live course too expensive?  We understand.  Take our self-paced online course in your own time at a fraction of the price.  No live support, however.

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.

Essential: A working knowledge of Microsoft Windows and Excel, and how to use a mouse.

Duration

Two days.  Note: This is an intensive working course: Delegates who are just looking for a two-day holiday from the office are strongly advised to stay at work.

Content

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.

The course consists of the following sections:

  • 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 Ribbon (Excel 2010, 2016 and later).
  • Useful Shortcuts
  • 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
  • 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
  • Overview of the Course examples as supplied.

After the course, trainees have three months' free support by e-mail, WhatsApp, Telegram app, and telephone on the course content, and a free subscription to the monthly Software Africa e-newsletter.

Trainees who wish to go further may also be interested in our two-day course on programming Excel Macros.

The online version of this course is available to attendees as a refresher.

The content of this course can be customised to suit customer requirements.

For more information and to book a course, click here and send the resulting email or email info@softwareafrica.co.za

Bookmark this page for future reference!


Press Ctrl+F to search this page for keywords.


| Back to top | ©2000-2022 Communication in Action cc t/a Software Africa. All rights reserved.  Updated 20 January 2022 e-mail Webmaster.