AIM:
To introduce Adobe InDesign

OBJECTIVES:
To be able to layout a range of publications with images and images, and prepare a document for print

MAIN COURSE CONTENT:

• Overview of InDesign
• What the package is used for
• Basics of Page Layout Design
• Overview of the work area: document set up, guides, palettes, tools
• Importing and Managing Text & Images
• Using colour
• Master pages
• Preparing for print

COURSE PROGRESSION OPPORTUNITES:

• Optional follow on day to consolidate and recap knowledge

Plus ….

• Managing Longer documents;
• Master Pages and Page Numbering
• Character and Paragraph Styles
• Creating Tables

AIM:
To introduce Excel Spreadsheets

OBJECTIVES:
To understand, practice and demonstrate content as listed.

MAIN COURSE CONTENT:

Spreadsheet Creation

• Entering and editing text and numerical data
• Saving the spreadsheet
• Inserting & deleting rows and columns
• Headers and footers
• Printing spreadsheets

Formatting spreadsheets

• Use common numerical formatting and alignment
• Formatting Text and Numbers
• Using borders and shading
• Using Chart Wizard

Formulas and Functions

• Using formulas: add, subtract, multiply, divide
• Using simple functions

AIM:
To enhance existing Excel Spreadsheet skills

OBJECTIVES:
To understand, practice and demonstrate content as listed.

MAIN COURSE CONTENT:

• Linking worksheets/spreadsheets
• Formulae
• Functions
• Advanced Cell Formatting
• Naming and Cell Referencing
• Filtering Lists
• Sorting Data
• Worksheet Views
• Advanced Printing

AIM:
To extend and enhance Excel Spreadsheet skills

OBJECTIVES:
To understand, practice and demonstrate content as listed.

MAIN COURSE CONTENT:

Link live data from one spreadsheet to another

• Linking worksheets/spreadsheets/worksheet/book protection

Select and control data source

• Functions; count, count if etc.
• Freezing panes
• Deleting Rows and Columns
• Inserting Rows
• Filtering and Sorting Data
• Conditional formatting
• Practical exercises
• Overview of Pivot tables
• HV Lookup

Present data using graphs and charts

• Exploded Pie Charts
• Chart Labels, Legends and Formats
• Adding a Footer
• XY Scatter Graphs and Bar Graphs
• Format axes and labels
• Changing Axes Scales
• Formatting Data Points
• Adding Text Boxes to Graphs

AIM:
To enhance Word Processing skills covering generic aspects of using Microsoft Word that may be applied to general work tasks.

OBJECTIVES:
To understand, practice and demonstrate content as listed from both sessions via a practical assignment.

MAIN COURSE CONTENT:

• Document Creation:-
  Setting Page orientation and margins
  Setting Line Spacing, Setting Font Type, Size and Alignment
  Entering Text
  Saving and Printing
  Spell Checking, Grammar Checking
• File Management:-
  Files and Folders,
  Renaming Files and Folders
  Creating a Subfolder           
  Moving, Copying and Deleting Files
• Editing and Re-Formatting Documents:-
  Copy and paste
  Formatting Tables
  Adding Bullets
• Working with Documents:-
  Editing and Re-Formatting Documents:-
  Formatting Text and Creating Tables
  Formatting Tables
  Adding, Deleting, Moving and Indenting Text
  Find and Replace
  Word Count

AIM:
To enhance Word Processing skills

OBJECTIVES:
Demonstrate understanding of Mailmerge, Demonstrate understanding of Text and Graphic Formatting and Placement.

MAIN COURSE CONTENT:

Mailmerge

• Creating a Mailmerge Document
• Creating a Mailmerge Master
• Attaching a Datafile
• Inserting Merge Fields
• Creating a Mailmerge Query

Working with Documents

• Formatting Text
• Saving and Printing
• Setting Up the Document
• Importing an Image and working with pictures
• Resizing and Repositioning an Image
• Page Break, Headers and Footers

OBJECTIVES:
To introduce Microsoft PowerPoint, covering generic aspects of using presentation software to help build effective presentations.

OUTCOME:
To understand, practice and demonstrate content as listed from both sessions via a practical assignment.

MAIN COURSE CONTENT:

• Creating a PowerPoint presentation using master slides
• Saving a presentation to run on any computer
• Micro-presentations
• Using PowerPoint templates to produce slide shows
• PowerPoint logistics
• Techniques and tips for powerful slides

OBJECTIVES:
To introduce Microsoft Access Database, covering generic aspects of creating a database, running queries and producing reports.

OUTCOME:
To improve productivity using the Access database by being able to set up a simple database, run simple queries and print out data and results. 

MAIN COURSE CONTENT:

• Database Principles and Fundamentals
• Manipulating a database
• Running queries in a database using search criteria
• Set up and adjust reports
• Plan and print reports
• Data analysis to prepare a database table from scratch
• The use of forms

AIM:
To introduce Microsoft Publisher, covering generic aspects of using page layout software to help produce successful publications.

OBJECTIVES:
To understand, practice and demonstrate content as listed from both sessions via a practical assignment.

MAIN COURSE CONTENT:

• Set up a standard page layout and text box properties
• Import and place text and image files
• Manipulate text and images to balance page
• Drawing lines and auto shapes
• Print a composite publication
• Look at the various different types of publication available
• Use paragraph spacing to balance text
• Linking text boxes
• Dealing with overflowing text