Microsoft Office Training

We offer training courses in Microsoft Excel, Access, PowerPoint and Word (versions 2003, 2007 and 2010). View the course outlines below to determine which course is right for you.

Manta Projects operates from the Western Cape, and caters for one-on-one and group training sessions – either at our premises in Cape Town’s southern suburbs or at yours.

Contact us on lynn@mantaprojects.co.za for a quote.

Course Outlines

Microsoft Access I: Getting Started (2 days)

Microsoft Excel I: Getting Started (1 day)

Microsoft Excel II: Beyond the Basics (1 day)

Microsoft Excel Advanced: Functions and PivotTables (1 day)

Microsoft Excel Advanced: Introduction to Controls and Macros (½ day)

Microsoft PowerPoint Intensive (1 day)

Microsoft Word I: Getting Started (1 day)

Microsoft Access I : Getting Started

CREATE A NEW DATABASE
Using an Online Template
Create a Blank Database
DATABASE OBJECTS
The Navigation Pane
Object Views
TABLES
Data Types
Primary Keys
Foreign Keys
Create a Table
Field Properties
RELATIONSHIPS
Referential Integrity
QUERIES
The Select Query
The Append Query
The Update Query
The Delete Query
The Make-Table Query
The Cross-Tab Query
Aggregate Queries
FORMS
Create a Form
Views
Modify the Design
Properties
REPORTS
Create a Report
Modify the Design
Create a Running Sum
Sorting and Grouping
TIPS
Export to Word or Excel
Set the Default Open Folder
Set a Form to Display on Startup
Conditional Formatting
Compacting/Repairing your Database

Top

 

Microsoft Excel I : Getting Started

ANATOMY OF AN EXCEL WORKBOOK
PAGE SETUP
ENTERING TEXT and NUMBERS
Editing Cells
Entering Numbers as Text
SELECTING, MOVING and COPYING
Selecting Cells
Moving Cells
Copying Cells
AutoFill
Incrementing Using AutoFill
Create a custom AutoFill series
WORKING WITH WORKSHEETS
Adjusting Column Width and Row Height
Inserting and Deleting Columns and Rows
Inserting and Deleting Cells
Hiding and Unhiding Columns and Rows
Worksheets
Freezing Columns and Rows
Splitting a Worksheet
MOVING AROUND A WORKSHEET
Shortcuts
Move to a Specific Cell
FORMATTING CELLS
PROTECTING A WORKSHEET
COPYING FORMATS
SORTING and FILTERING
Sorting by One or More Columns
Filtering using AutoFilter

SIMPLE FORMULAS

AUTOSUM

COMMENTS

Create a Comment
Edit a Comment
Delete a Comment
Change the Look of a Comment
Print Comments

Top

Microsoft Excel II : Beyond the Basics
COPY & PASTE
The Format Painter
Paste Special
FIND & REPLACE

CUSTOM NUMBER FORMATS

FILTERING

FORMULAS
COPYING A FORMULA
Relative vs Absolute Cell Addresses
CONDITIONAL FORMATTING

SIMPLE FUNCTIONS

AutoSum
AVERAGE, MIN, MAX
COUNT, COUNTA
IF
RANK
AND, OR
ROUND
CONCATENATE
MORE COMPLEX FUNCTIONS
COUNTIF, SUMIF
Nested Functions
CHARTS
Create a Chart
Anatomy of a Chart
Formatting a Chart

 

Top

 

Microsoft Excel Advanced: Functions and PivotTables

TABLES (LISTS in Excel 2003 and earlier)

Elements of an Excel Table

Create a Table

Convert a Table to a Range

FUNCTIONS

Nesting Functions

Text Functions

  – LEFT, RIGHT
  – MID
  – TRIM
  – LEN
  – SEARCH, FIND
  – SUBSTITUTE, REPLACE
Date & Time Functions
  – NOW, TODAY
  – DAY, MONTH, YEAR
  – DATE
  – WEEKDAY
Statistical / Mathematical Functions
  – SMALL, LARGE
  – SUBTOTAL
Lookup Functions
  – VLOOKUP, HLOOKUP
Error Functions
  – ISERROR, ISERR, ISNA

PIVOT TABLES

Create a PivotTable
Change the Look
Manipulate a PivotTable
  – Pivoting

  – Sorting

  – Filtering

  – Viewing Detail

  – Creating a Snapshot

  – Changing the Summary Type

  – Custom Calculations
  – Grouping Data

GETPIVOTDATA Function

Create a PivotChart

Top

 

Microsoft Excel Advanced: Introduction to Controls and Macros
CONTROLS
What are Controls?
Form Controls v ActiveX Controls
Control types: Command Buttons, Checkboxes, Comboboxes and more
Working with Controls
MACROS
What are Macros?
Record a Basic Macro
Run a Macro
Edit a Macro
The Visual Basic for Applications Window
Delete a Macro
Assign a Macro to a Control
Macro Security

 

Top

Microsoft PowerPoint Intensive 
EXPLORING THE POWERPOINT WINDOW
CREATE A NEW PRESENTATION
Using design templates
Using the AutoContent Wizard
Using an Existing Presentation
CHANGE SCHEME ATTRIBUTES
Change the scheme colours
The Slide Master
The Title Master
CHANGE SLIDE ATTRIBUTES
Change the font
Bulleted/numbered lists
Add a footer
ADDING SLIDES TO YOUR PRESENTATION
Add a new blank slide
Copy a slide
CHANGE THE SLIDE LAYOUT
FILL THE BACKGROUND
ADD GRAPHICS
Add a picture
Add a digram
Other graphics
Aligning objects
ADD EXCEL DATA
Insert a table
Insert a chart
APPLYING ANIMATION
Apply a preset animation scheme
Apply slide transition animation
Apply custom animation to your text
ADDING SOUNDS
Add narration
Add a sound file
SPELLCHECKING YOUR PRESENTATION
Check spelling in the whole presentation
Check spelling as you type
SET UP THE SLIDE SHOW
Slideshow timing
The Set Up Show dialog box
SLIDE NAVIGATION DURING A PRESENTATION
HANDOUTS & NOTES

Top

 

Microsoft Word I : Getting Started

THE WORD ENVIRONMENT
The Quick Access Toolbar
The Title Bar
The Ribbon
The Ruler
The Status Bar
DOCUMENT VIEWS
Change the Document View
PRINT & SAVE A DOCUMENT
Preview a Document Before Printing
Print a Document
Save a Document

EDIT A DOCUMENT

Select Text
Move Text
Copy Text
Undo or Redo Changes
Find Text
Replace Text
AutoCorrect
FORMATTING
Font
Copy Formats
PARAGRAPHS
Tabs
Align Paragraphs
Indent Paragraphs
Change Line Spacing
Change the Spacing Between Paragraphs
Borders and Shading

LISTS

Create a Bulleted or Numbered List
Restart a List
Create a Multilevel List

TABLES

Insert a Table
Apply a Table Style
Insert or Delete Columns or Rows
Merge or Split Cells
Convert Text to a Table
Convert a Table to Text
STYLES
Character, Paragraph and Linked Styles
List Styles
Table Styles
The Document Map
Quick Style Sets

PROOF A DOCUMENT

Use the Thesaurus
Check Spelling and Grammar
Check Word Count