If you would like to upskill your staff or your team in Microsoft Word, Excel or PowerPoint, contact us and we will tailor make a course to suit your needs and train you at your premises.  Below is an idea of topics that can be covered using previous courses that we have designed.  Should you be interested, please don't hesitate to contact us - cost is calculated on a per person per hour basis.*

WORD

Section 1: Word Basics

  • How to Open, Edit, Save & Print (Beginner)
  • How to Cut, Copy & Paste (Beginner)
  • How to Format Words (Beginner)
  • How to Format Paragraphs (Intermediate)
  • How to Apply Bullets & Numbering (Intermediate)
  • Adjust Page Settings (Intermediate)
  • Spell Check (Intermediate)
  • View Pages (Intermediate)
  • Password Protect your Document (Intermediate)

Section 2: Formatting your Document

  • Format Text Styles (Intermediate)
  • Find and Replace (Intermediate)
  • Set Tabs (Advanced)
  • Insert Breaks (Advanced)
  • Using Headers & Footers (Advanced)

Section 3: Presentation

  • Using Tables (Advanced)
  • Insert Pictures (Intermediate)
  • Insert Shapes (Intermediate)
  • Insert Smart Art (Intermediate)
  • Insert Hyperlink (Advanced)
  • Format Pages in Columns (Advanced)
  • Print PDFs (Intermediate)
  • Employ Drop Caps (Advanced)

Section 4: Advanced

  • Mail Merges (Advanced)
  • Using Templates (Advanced)
  • Print Envelopes & Labels (Advanced)
  • Count Words (Advanced)
  • Insert Table of Contents (Advanced)

EXCEL

Section 1: Starting Out

  • How to Open, Edit, Save & Print (Beginner)
  • Basic Calculations (Beginner)
    • Add | Subtract | Multiply | Divide | Average | Maximum | Minimum

Section 2: Formatting your Document

  • How to Format Text in Excel Worksheets (Beginner)
  • How to Format Numbers in Excel Worksheets (Beginner)
  • How to Format Cells in Excel Worksheets (Beginner)

Section 3: Manipulating Data

  • Move, Copy & Paste (Beginner)
  • Add/Delete Columns (Beginner)
  • Add/Delete Rows (Beginner)
  • Making Use of Multiple Worksheets (Beginner)
  • Using Autofill (Beginner)

Section 4: Advanced Formulae

  • Create Formulae across Worksheets (Intermediate)
  • Making Use of Absolute References (Intermediate)
  • Using the Function Wizard (Advanced)
    • COUNTIF | SUMIF | IF | VLOOKUP
  • Understanding Formula Errors

Section 5: Making Data Visible

  • Adding Comments (Intermediate)
  • Freeze Panes (Intermediate)
  • Trace Formulae (Intermediate)
  • Apply Filter (Intermediate)
  • Sort Data (Intermediate)
  • Remove Duplicate Data (Intermediate)
  • Using Subtotals (Intermediate)
  • Find and Replace (Intermediate)
  • Hide Column or Row (Intermediate)

Section 6: Charts

  • Using Charts (Advanced)

Section 7: Advanced

  • Sparklines (Advanced)
  • Conditional Formatting (Advanced)
  • Data Validation (Advanced)
  • Logical Functions (Advanced)
  • Date and Time (Advanced)
  • Text Functions (Advanced)
  • Round (Intermediate)
  • Scenario Planning (Advanced)
  • Pivot Tables (Advanced)

POWERPOINT

Section 1: Creating a Presentation

  • How to Open, Edit, Save & Print (Beginner)
  • Create and Add Slides (Beginner)
  • How to Delete a Slide (Beginner)
  • How to Insert a Picture (Beginner)
  • How to Format Text (Beginner)
  • How to Format Pictures or Clip Art (Beginner)
  • Preview a Presentation (Beginner)
  • How to Cut, Copy & Paste (Beginner)
  • Perform a Spell Check on your Presentation (Beginner)
  • Password Protect your Presentation (Intermediate)

Section 2: Customising Presentations

  • Insert Tables (Intermediate)
  • Insert Charts (Intermediate)
  • Making Use of Design Themes and Background Styles (Intermediate)
  • Making Use of a Master Slide (Advanced)
  • Rearranging Slides (Intermediate)
  • How to Work with a Blank Slide (Advanced)

Section 3: Working with Animation

  • Animate Text (Advanced)
  • Insert Graphics (Advanced)
  • Create Slide Transitions (Advanced)
  • Advance Slides Automatically (Advanced)
  • Remove Animation (Advanced)
  • Add Speaker Notes (Advanced)
  • Creating Handouts (Advanced)

*1-5 people @ R200 ppph | 6-10 people @ R150 pph | 11+ people @ R120 ppph.