Microsoft Office Training

We offer training courses in Microsoft Excel, Access, PowerPoint and Word. 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: PivotTables (1 day)

Microsoft Excel Advanced: Functions (1 day)

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

Microsoft PowerPoint Intensive (1 day)

Microsoft Word I: Getting Started (1 day)

 

Microsoft Access I : Getting Started

CREATE A NEW 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
ENTERING TEXT and NUMBERS
How Excel Interprets Cell Entries
Editing Cells
Entering Numbers as Text
SELECTING, MOVING and COPYING
Selecting Cells
Moving Cells
Copying Cells
AutoFill
Incrementing Using AutoFill
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
Freezing Columns and Rows
Splitting a Worksheet
Adding, Deleting, Moving and Copying Worksheets
FORMATTING CELLS
COPYING FORMATS
PROTECTING A WORKSHEET
SORTING and FILTERING
Sorting by One or More Columns
Filtering using AutoFilter
SIMPLE FORMULAS
SUM (AutoSum)
TIME SAVING TIPS
Keyboard Shortcuts
Moving around a Worksheet

Top

  Microsoft Excel II : Beyond the Basics
COPY & PASTE
The Format Painter
Paste Special
FIND & REPLACE
FILTERING
FORMULAS
USING DATES IN CALCULATIONS
COPYING A FORMULA
Relative vs Absolute Cell Addresses
SIMPLE FUNCTIONS
SUM (AutoSum)
AVERAGE, MIN, MAX
COUNT, COUNTA
MORE COMPLEX FUNCTIONS
IF
ROUND
VLOOKUP
Nested Functions
CONDITIONAL FORMATTING

Top

Microsoft Excel Advanced: Functions
Nested Functions
Statistical / Mathematical Functions
  – COUNT/COUNTA
  – SUBTOTAL
Text Functions
  – LEFT, RIGHT
  – MID
  – TRIM
  – LEN
  – SEARCH, FIND
  – SUBSTITUTE, REPLACE
Date & Time Formats & Functions
  – TODAY
  – EOMONTH
  – DAY, MONTH, YEAR
  – DATE
  – WEEKDAY
Logical Functions
  – IF
  – IFERROR
Lookup Functions
  – VLOOKUP
 
TopMicrosoft Excel Advanced: PivotTables

PivotTable DATA SOURCE PREPARATION
CREATE A PivotTable
CHANGE THE LOOK
CREATE A PivotChart
MANIPULATE A PivotTable
  – Pivoting
  – Sorting
  – Filtering
  – Viewing Detail
  – View Raw Data
  – Creating a Snapshot
  – Changing the Summary Type
  – Custom Calculations
  – Grouping Data

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