Excel VBA

This Excel VBA Training Course will boost your MS Office programming skills. Unleash the power of Excel with a bit of coding.

Prerequisite

Good working knowledge of MS Office

Intended Audience

Excel users who want to learn more powerful techniques

Further Training

If you are interested in becoming a programmer, we can recommend VB.NET or C#.NET

Course Material

Included in the course price

Course Info

1: Introducing VBA

  • What is VBA?
  • Jumping right in

2: How VBA works with Excel

  • Working in the Visual basic Editor
  • Introducing the Excel Object Model
  • VBA Sub and Function Procedures
  • Using the Excel Macro Recorder

3: Programming Concepts

  • Essential VBA Language Elements
  • Working with Range Objects
  • Using VBA and Worksheet Functions
  • Controlling Program Flow and Making Decisions
  • Automatic Procedures and Events
  • Error-Handling Techniques
  • Bug Extermination Techniques
  • VBA Programming Examples
4: Communicating with your users

  • Simple Dialog Boxes
  • UserForm Basics
  • Using UserForm Controls
  • UserForm Techniques and Tricks
  • Accessing your Macros through the User Interface

5: Putting it all together

  • Creating Worksheet Functions – and Living to tell about it
  • Creating Excel Add-Inns

6: The part of Tens

  • Ten VBA Questions (and answers)
  • (Almost) Ten Excel Resources

 

Duration and pricing

  • Full-time over 5 days (R9995 excl VAT)
  • Distance-learning over up to 3 months (R9995 excl Vat)

Certificate

1. Upon completion of this course we will issue you with attendance certificate to certify your attendance and / or completion of the prescribed minimum examples.
2. You have the option to get the competency / academic certificate if you :
hand in a project (pre-approved) covering most of the topics in the book.

Schedule

On the calendar on this page below.
If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our ‘Contact Us’ page.

Bookings

You can download the course registration form on our home page or by clicking here

Brochure

You may download a pdf copy of this page by clicking here.

Questions

Please email us




HTML and CSS

No previous experience required. Whether you are a beginner, keen to start writing your first Web Page or a more experienced programmer seeking to update your skills, we cover practical introductions to these essential languages as well as tips and techniques used by experienced web developers, this HTML / CSS Training Course is for you.

Prerequisites

Matric is recommended, but a will to succeed is better.

Further Training

Web Design and / or Introduction to Computer Programming if you are considering to go into Programming.

Course Material

We give you an original copy of the book: Head First HTML with CSS & XHTML (by O’Reilly Press) as we use this mainly, but we also give additional examples where it falls short.

Course Info

 Day 1:

Getting to know HTML
Going further with hypertext
Building blocks
Day 3:Getting started with CSS
Styling with fonts and colours
The box model
Day 5:Practical project
 Day 2:

Getting connected
Adding images to your pages
Standards, compliance
Day 4:Divs and spans
Layout and positioning
HTML5 markup
Tables and more lists
HTML forms

 

 

  • Duration and pricing

Price group A

  • Certificate

Read about our certificates

  • BookingsYou can download the course registration form on our home page or by clicking hereBrochure

    You may download a pdf copy of this page by clicking on the pdf icon at the top of the page.

    Questions

    Please email us

    Schedule

    On the calendar below. If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our Contact Us page.

[contentblock id=3 img=gcb.png]




Intro to Programming

This Intro to Programming Course will teach you the fundamentals of coding. These topics that are common to all coding languages today: Variables, program flow, data structures, modularisation, functions and how to build basic solutions using these fundamentals. Although we are using JavaScript in this course, the emphasis is not on language, rather on generic coding fundamentals applicable to all coding languages today. Using JavaScript is a bonus because it is the most widely used coding language in the world and used by all other coding environments.

Prerequisites

None. No Matric required, neither any previous training in computer programming for our Intro to Programming course. If you can pass this Entry Test, you may skip this course before doing any Beginner course like Beginner Java, Beginner C#, Beginner PHP , Beginner Python  Beginner C++ and more or any of the Bootcamps.

Intended Audience:

Anybody who has not programmed before and wants to get into programming the right way

Further Training

All Coding Bootcamps and Beginner Courses

Course Material

Provided

International Alignment

We cover various internationally known syllabi e.g.

Course Info

DAY 1

Programming the Web

  • What Is Programming?
  • Talking to Computers
  • Choosing a Language
  • What Is JavaScript?
  • Get Your Browser Ready
  • Opening the Web Developer Tools
  • Introducing the JavaScript Console
  • Running Your First JavaScript Commands
  • Having Fun with Math

Understanding Syntax

  • Saying Precisely What You Mean
  • Making a Statement
  • Following the Rules

Giving and Receiving Data

  • Mastering Variables
  • Understanding Data Types
  • Prompting the User for Input
  • Responding to Input
  • Combining Input and Output

Fiddling with Web Applications

  • Introducing JSFiddle
  • Creating a JSFiddle Account
  • Sharing Your Fiddle
  • Saving Your App

JavaScript and HTML

  • Writing HTML
  • Knowing Your HTML Elements
  • Adding Attributes to Elements
  • Changing HTML with JavaScript

DAY 2

JavaScript and CSS

  • Meet the JavaScript Robot
  • CSS Basics
  • CSS Properties Give You Style
  • Customize Your Own JavaScript Robot!

Building an Animated Robot

  • Changing CSS with JavaScript
  • Make The Robot Dance

Operands

  • Knowing Your Operands
  • Working with Objects
  • Configuring Your Dream Car

Operators

  • Introducing the Super‐Calculator
  • Super‐Calculator Tricks

Creating A JavaScript Word Game

  • Creating a Variable Story
  • Creating the Word Replacement Game

DAY 3

Arrays

  • What Are Arrays?
  • Creating and Accessing Arrays
  • Changing Array Element Values
  • Working with Array Methods
  • Learning the Ways of Arrays

Making It Functional with Functions

  • Understanding Functions
  • Knowing What Functions Are Made Of
  • Building Function Junction

Creating a Wish List Program

  • Introducing the Wish List Program
  • Writing the HTML
  • Writing the JavaScript Code

Making Decisions

  • If…Else Statement
  • Boolean Logic
  • Introducing if…else Statements
  • Combining Comparisons with Logical Operators
  • Freshening Up the JavaScript Pizzeria

Switch Statement

  • Writing a Switch
  • Building an Activity‐of‐the‐Day Calendar

DAY 4

Coding An Adventure Story Game

  • Planning the Story
  • Playing the Game
  • Forking the Code
  • Tiptoeing through the HTML and CSS
  • Writing the Martian Rescue! JavaScript

Loops

  • Introducing the for Loop
  • Random Weather Forecasting App

While Loops

  • Writing a while Loop
  • Coding a Lunch Game
  • Moving to Your Own Website

Building a Lemonade Stand Game

  • Playing the Game
  • A Lesson in Business
  • Building the Game
  • Improving the Lemonade Game

DAY 5

  • Practical Projects
  • Assesments

Duration and pricing

Pricing Group C

Certificate

Read about our certificates

Bookings

You can download the course registration form on our home page or by clicking here

Brochure

You may download a pdf copy of this page by clicking on the pdf icon at the top of the page.

Questions

Please email us

Schedule

On the calendar below. If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our Contact Us page.




WordPress

Prerequisites
You should have a good knowledge of HTML, CSS and XHTML .

Intended Audience
Anyone who wants to become a better web designer.

Further Training
Introduction to Computer Programming if you are considering to go into Programming.

Course Material
Included in the course price.

Course Contents

Day 1

  • Thinking like WordPress
  • Planning your site for WordPress
  • Installing WordPress
  • Admin Area Overview
  • Basic Admin Settings
  • Adding a new post – overview
  • Working with the text editor
  • Laying out text

Day 2

  • Advanced Post Postings
  • Adding a new Page
  • The basics of handling media files
  • The upload / insert window tabs
  • Image options in detail
  • Editing and laying out images
  • Working with Image galleries.

Day 3

  • Adding video and audio
  • Adding documents
  • Managing posts and pages
  • Managing media files
  • Managing post categories and tags
  • Managing widgets and menus
  • The links manager
  • Managing comments
  • Bringing in content from other sites

Day 4

  • Helping others to connect to your site
  • Having multiple site users
  • Overview of WordPress themes
  • Creating a child theme
  • Basic customisation of your design
  • Optimising your content
  • Optimising your site as a whole
  • How is your site doing?

Day 5

  • Keeping up to date
  • Backing up your site
  • Installing and activating plugins
  • Two example plugins
  • Other common uses for plugins
  • Running multiple sites with WordPress
  • Customising WordPress
  • Troubleshooting WordPress

Duration and pricing

Certificate

Read about our certificates

Schedule

On the calendar on this page below.
If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our ‘Contact Us’ page.

Bookings
You can download the course registration form on our home page or by clicking here

Brochure
You may download a pdf copy of this page by clicking here.

Questions
Please email us