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

Get Trained – Work Better!

Training Background

Software Africa has long been involved in high quality skills development for users of Microsoft and QuickBooks software. Courses can be custom-written to meet specific user needs.  We usually run live in-person courses at your premises to a schedule that suits your company.

With modern technology, we can run courses live on-line so that your staff can participate directly from the office or their homes. We are also increasingly putting the training material on the internet so that trainees can work through the course in their own time at their own pace.

We ensure individual attention by keeping live groups small –usually a maximum of 8–12 users per session– and by evaluating participants beforehand. We can include workflow and presentation of documents so that the course accurately reflects the reality of your work environment.

Each trainee receives a comprehensive manual (typically 60 to 80 pages) containing step-by-step instructions, example files, a certificate of completion, and three months' free telephonic and e-mail support on the course material. Final assessment of trainees can be done if required.

In-house courses typically cost (South African Rand) R8 800 plus VAT per day for a group of up to 8 people. Open courses are priced per trainee.  These prices are subject to change without notice.

Our training manuals are available under license for you to run in-house training using your own trainer.

We can write training manuals to suit your needs. The cost varies depending on complexity, how much already exists, and who holds copyright. We've created training courses for Quest International (Pty) Ltd; Longhop Platinum Mines; MAPP Healthcare; PG Autoglass and many others.

Courses are available on the following software packages:

(Click underlined links for more information)

Microsoft

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

back to top


Microsoft Excel for Engineers

Who should attend?

Technical users with experience in recent versions of Microsoft Excel who now wish to upgrade their skills with specific focus on engineering and scientific problems.

Duration: Two days

Contents

  • Excel as an Engineering and Scientific Tool
  • Recap of Basics: Screen layout, moving around and selecting cells, copying and moving cells, formatting cells, entering and editing data, overview of the menus, shortcuts, toolbar buttons, simple formulas and formatting.
  • Other Useful Features: Tools > Options, Range Naming, Freeze Panes      
  • Preview and Print 
  • Guidelines for Good Worksheet Design  
  • Some Advanced Functions.
  • Excel Add-Ins.
  • Creating and Working with a Database: Using a list as a database, data forms, filtering and sorting data.
  • Groups and Outlines.
  • Pivot Tables.
  • Scenario Manager.
  • Goal Seek and Solver.
  • Graphs.
  • Introduction to Macros: Recording and running a macro, modifying Visual Basic code, main features of Visual Basic. Examples.
  • Assigning a macro to a worksheet button or a toolbar button.
  • Iterating for a Solution: Using Copy, Circular References, and Macros.
  • Using Excel as a Pre-Processor: Exporting Data.
  • Using Excel as a Post-Processor: Importing Data.
  • Other Examples: Pipe Flows, Survey Calculations, Reservoir Simulation, LINEST.

A comprehensive manual and examples are provided, plus three months’ free support on the course material.

Customisation of the Course

The course can be customised to suit user requirements and focused on particular needs. Please let us know of any particular feature that you wish to look at in depth before the course. Examples from users’ work are particularly welcomed.

For more information, options, and to book on a scheduled course, click here (new page).

back to top


Microsoft Excel Macros (Programming)

Who should attend?

Very experienced Excel users who wish to be able to program applications.

Duration: Two days

Content

In depth coverage of Visual Basic for Applications (VBA) and its interface with Excel.  During the course, participants will develop a number of applications to use in Excel.

Debugging of the applications is also included. Further details available on application.

For more information, options, and to book on a scheduled course, click here (new page).

back to top


Microsoft Access Beginners

Who should attend?

This course is designed for the first-time user. No previous experience of Access 2010 and later, or databases in general, is required, but will be useful. Windows knowledge is essential, including using a mouse. Typing ability will be an advantage.

Duration: Two days

Course Content:

  • What is a Relational Database Management System?
  • Starting Microsoft Access
  • The Menus (covered in detail throughout the course)
  • Database design considerations
  • Creating a New Database: Directory considerations, File naming and backups
  • Components of a database: Tables, Queries, Forms, Reports, Macros.
  • Creating a new table: The Components of a Table
  • Entering Data into a Table; Copy and Move data; Moving a Column.
  • Opening an existing file
  • Finding and Replacing data
  • Making design changes to a table
  • Queries and Forms
  • Views: Design, Datasheet, Form View.
  • Forms: Why use a Form?; Creating and Modifying a Form; Using the Form
  • Sorting in Form View: Working with Filters
  • Form Design - Using the toolbox; Giving a form a different source
  • Printing through a Form
  • Creating reports: Single-Columnar Reports, Groups/Totals Reports.
  • Splitting a Database: Using Query to create a new table
  • Creating an Update query
  • Setting Relationships
  • A data input system; Creating a Check box; Creating a Combo box
  • Example: A mass mail-out: Creating Mailing Labels and Form Letters
  • Introduction to Macros: Creating a macro, Putting a macro on a button.

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

back to top


Microsoft Visual Basic 6.0 Beginners

Purpose:

This course is designed for new users of Microsoft Visual Basic 6.0.  By the end of the course trainees will be able to develop and distribute their own simple Visual Basic programs for Windows.  This is a hands-on working course focusing on the practical use of Visual Basic.  More advanced topics such as Database Handling, Help Files and Graphics are covered on the Visual Basic 6.0 Intermediate course.

Prerequisites:

The trainee must know how to use Windows and a mouse, and have fair typing skills.  A user-level knowledge of other Windows packages such as Excel or Word will be an asset.  Previous use of a programming language or macros will also be useful. 

Homework will be given (about 2 hrs per day).  For this purpose trainees must either have access to a legal copy of Visual Basic 6.0, or be willing to use our premises after hours.

Duration and Cost:

The course is run over four non-consecutive days once a week (for example, successive Wednesdays) for groups of three to six people.  The course is structured into two modules per day.  For smaller or faster groups, each day’s work can be covered in a somewhat shorter period.  The cost is R5000 plus VAT per day.  The course fee includes a detailed manual, a diskette with solutions to homework, and free telephone support on the course material for the next three months.

Course Content:

The course content is subject to change without prior notice, and may be influenced by the requirements of the participants. 

    Module 1: Introduction:

  • The Visual Basic Programming environment.  Forms.

  • Common Controls

  • Objects and Properties

  • Event-driven programming vs. the sequential program:  No Main Program!

  • Adding code to a control: Our first program.  Exercises.

    Module 2: Programming Basics

  • Program Structure

  • Variable Types

  • Declaring Variables and Arrays

  • Scope and Lifetime of Variables

  • Formulas and Constants

  • Modules

  • Procedures: Subprograms and Functions.  Homework.

    Module 3: Programming Topics

  • Program Control Structures - Conditional and Unconditional Branching; Looping.

  • Classes and Collections; Events, Properties and Methods.

  • Using Visual Basic Help

  • Message Box and Input Box

  • Error-handling; Scope of Error Handlers

  • Debugging and Testing Code.

  • Exercises

    Module 4: Formulae and Built-in Functions

  • Math Built-in functions e.g. Int, Abs.

  • Text Built-in functions - string manipulation.

  • Date calculations - plain dates, Between, Date/Time Built-in functions e.g. DateAdd, Month, Year, conversions.

  • Other useful Functions

  • Homework

    Module 5: File Handling and Common Dialogs

  • Types of File Access

  • Open and Close

  • Reading and Writing to different file formats

  • Common Dialogs for file handling

  • FileCopy, Dir, Name, Kill; changing Drive and Directory.

  • Exercises

    Module 6: Simple Graphics and Printing

  • Printing to a form, a control, and the printer

  • Drawing to these objects: A simple graph

  • Positioning and Justifying Text.  Homework

    Module 7: Improving the User Interface

  • The Menu Editor. 

  • Controlling menus programmatically

  • Cut, Copy and Paste.

  • Forms as Dialog boxes.  Modal and Modeless Dialogs

  • The Toolbar control.  Exercises

    Module 8: Rounding out the Application

  • Sequence of Events at Start-up

  • Creating a Splash Screen

  • The Timer Control

  • Providing Simple Help

  • Distributing the Application: the Setup Wizard

  • Workshopping of user problems.

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

back to top


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.