Microsoft Training

This programme is designed to give complete beginners a solid overview of Microsoft Office Applications including:

• Getting Started with Word Processing
• Using the Internet
• Saving Files and Creating Folders
• Getting Started with Excel Spreadsheets
• Using Outlook to send emails

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for 10 delegates attending.

None - this course is for complete beginners to Microsoft Office, but should be familiar with a PC prior to attending

Day 1 -

• Getting Started with Word Processing
• Using the Internet
• Saving Files and Creating Folders

Day 2 -

• Getting Started with Excel Spreadsheets
• Using Outlook to send emails

The course content for the modules is as follows, however as the course is bespoke the course will be adjusted on the day to ensure the delegate’s objectives are fully met:

Day 1 – Content

Word – Introduction, contents: (Day 1)

• Creating a Document
• Editing Text
• Formatting Text
• Formatting Paragraphs
• Adding Tables
• Using Word Timesavers
• Setting Page Display and Printing Options

Using the Internet and Creating / Saving Files and Folder – (end of day 1):

• This section will show the delegates how to utilise an internet browser, how to search for information on the net, add web address to favourites and briefly discuss why the internet is vital to today’s business environment and other useful tips an tricks to get around the net.
• Time will also be spent on showing the delegates around file creation, saving, searching for files and understanding Windows and further uses of the desktop.

Day 2 – Content

Excel – Introduction, contents: (Day 2, Half Day)

• Getting Started
• Environment
• Terminology
• Creating and editing a worksheet
• Building worksheets from a blank page
• Inserting/ Deleting, columns, rows, sheets
• Performing Simple Calculations
• How to build simple formula
• Using SUM, AVERAGE, MAX, MIN, COUNT
• Relative reference
• Formatting
• Text, Numerics, Borders
• Working with multiple sheets
• Move/Copy, Cut, Copy &Paste
• Creating and Modifying Charts
• How to create a chart
• Tips and advice on what data to use
• Editing the default appearance
• Setting page display and printing options
• Print what you would like to print – not what excel likes to print

 
Outlook – Introduction, contents: (Day 2 – Half Day)

• Sending Messages
• Acting On Messages
• Scheduling Appointments and Events
• Scheduling Meetings
• Using Contacts
• Creating Tasks
• Managing Messages
• Using Notes

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.

At the end of this course delegates will be able to:

• Have a good working knowledge of Outlook 
• Be able to manage and communicate using Microsoft Outlook
• Set up meetings across the network,
• Organise their calendar or delegate it to someone else
• Manage their to-do list using Tasks
• Use email communication
• Enhance group planning
• Schedule meetings

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for 10 delegates attending.

None

Getting Started

• The program window
• The Help system

E-mail

• E-mail accounts
• E-mail messages
• Handling messages
• Printing messages
• Address Books

E-mail and Contact Management

• E-mail management
• Contact management
• The master category list

Tasks

• Working with tasks
• Managing tasks

Appointments and Events

• Working with appointments
• Modifying appointments
• Working with events

Meeting Requests and Responses

• Working with meeting requests
• Managing meeting requests
• Handling meeting responses

Customizing Outlook

• Personal folders
• The organize panel
• Signatures
• Voting buttons
• Interacting with the internet

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.

Office 2007 has a radically new user interface compared with either Office 97/2000 or XP/2003:

• The ‘ribbon’ replaces most menu and toolbar functions in Word, Excel, PowerPoint and Access as well as some parts of Outlook.
• Real-time’ previewing of changes in formatting, prior to application to the current document.
• Documents can now be saved in .pdf format.
• New Graphics engine.
• SmartArt is a new feature designed to create professional-looking diagrams.
• Document Themes allow a consistent use of fonts, formatting, etc across all documents created win Word, Excel and PowerPoint.
• Simplified working with multiple applications, e.g. Excel chart embedded in a Word document.

None

The new Interface – Office 2007

• The Ribbon
• Tabs
• Command Groups
• Dialog box Launcher
• Quick Access Toolbar
• Status bar – including Views, Zoom, customising
• Office Button
  
  • Creating a new file
  • The Office 2007 file formats
  • Open files
  • Saving files to ERM
  • Saving as PDF
  • Saving for earlier version
  • Converting files to Office 2007
  • Printing
  • Preparing for print

• Document properties
• Marking documents as final
• Compatibility checker
  
  • Sending as e-mail
  • The Options button

• Mini-toolbar
• Live Preview
• Tool tips

New Features - Word

• Styles and Quick Styles
• Cover page gallery
• Automatic Word count
• Contextual spell checker
• Quick Parts and Building Blocks
• Using Tables Quick Styles
• Document comparison, review and merging

New Features -Excel

• New worksheet size and capabilities
• Formula Autocomplete
• Formatting from Home Ribbon
• New features in Conditional Formatting
• Improved Sorting and Filtering
• Page Layout view
• Charts and reports from existing worksheets
• New Table options
• Pivot Tables
• Name Manager
• SUMIFS, etc.

New Features - Outlook

• The Navigation Pane
• Changing look of reading pane
• Instant Search
• Search Folders
• Colour Categories
• Preview Attachments
• The To Do Bar
• Additional Flag facilities
• Formatting e-mails
• The Create e-mail tabs
• Task Integration
• Calendar views and scheduling
• Calendar snapshots
• RSS Feeds

New features - PowerPoint

• Additional formatting options
• Changing the direction of text
• Indenting text
• Font command group
• Aligning text
• Text in columns
• Quick Styles
• Themes
• Enhanced tables and pasting tables from Excel
• Custom slide layouts – Slide Layout Gallery
• Slide Master Layouts
• Smart Art Graphics
• Converting bulleted lists to Smart Art
• New Effects in animations and transitions
• Presenter View
• Reuse Slides task pane

New features -Access

• Creating a blank database
• Navigation pane, including customisation
• Access Options
• New features in tables
  
  • Adding a field from another template
  • Creating a new field using the field template
  • Creating a table using a template
  • Creating a table using a SharePoint list
  • Performing calculations using the Totals row
  • Date picker

• New features in form
  
  • Creating a form using the Report Wizard
  • Creating a split form

• New features in reports
  
  • Creating a group or sort
  • Modifying groups or sorts
  • Adding a calculated function

• Aligning controls in forms and reports
   (New Users)

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.

At the end of this course delegates will be able to:

• Have a complete understanding of the higher functions of Word
• Perform the most advanced functions
• Merge your documents with databases for mail-shots and producing well-defined forms.
• Work with extremely large documents
• Use macros

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for 10 delegates attending.

None - delegates must be proficient with Word or have completed our Stage 2 course

Using Mail Merge

• Creating form letters
• Working with data sources
• Creating mailing labels

Working with Forms

• Creating forms
• Modifying forms
• Protecting and printing forms

Working with Large Documents

• Master documents
• Footnotes and endnotes
• Indexes
• Bookmarks and cross-references

Managing Document Revision

• Using track changes
• Comparing document versions

Creating Macros

• Recording and running macros
• Modifying and deleting macros
• Using macros in forms
• Creating custom menus
• Customising toolbars

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.

Public Course Availability

Word Training - Stage 3 (Advanced Users) is available as a public course on the following dates at the venues shown. You can book yourself and other delegates onto any of these courses simply by clicking the Book now buttons.

At the end of this course delegates will be able to:

• Divide a document into sections and columns
• Format tables and populate them with data directly from Excel spreadsheets
• Add recurrent data to documents in a series such as page numbers and headers
• Prepare labels and envelopes
• Add your company logo to a letter
• Set up a template for future mail 

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for 10 delegates attending.

None - the course is for more adept users of Word, or completed our basic skills course

Working with Sections and Columns

• Creating and formatting sections
• Working with multiple columns
• Working with text in columns

Formatting Tables

• Table formatting basics
• Borders and shading
• Table AutoFormat
• Drawing tables

Working with Excel Data

• Working with Excel data in word
• Creating Charts in Word
• Performing calculations in tables

Working with Styles

• Defining and Applying styles
• Modifying and deleting styles
• Using Styles to create outlines
• Using AutoText and AutoFormat

Headers and Footers

• Different headers and footers
• Page numbering

Printing Options

• Advanced Printing options
• Labels and envelopes

Working with Graphics and Objects

• Working with graphics and clip art
• Inserting WordArt and symbols
• Applying watermarks
• Using drawing tools

Document Templates

• Using templates
• Creating templates

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.

Public Course Availability

Word Training - Stage 2 (Intermediate Users) is available as a public course on the following dates at the venues shown. You can book yourself and other delegates onto any of these courses simply by clicking the Book now buttons.

At the end of this course delegates will be able to:

• Have a good working knowledge of Word basics
• Create a document from scratch
• Understand and use some of the built in layout and text editing functionality
• Produce far more striking and effective documentation
• Create more presentable documents

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for 10 delegates attending.

None

Getting Started

• Exploring the Word window
• Creating and saving documents
• Printing Documents
• Getting Help

Editing Documents

• Opening and navigating in documents
• Automated tasks
• Editing text
• The undo and redo commands

Moving and Copying Text

• Selecting text
• Cutting, copying, and pasting text
• Finding and replacing text

Formatting Characters and Paragraphs

• Character formatting
• Using tabs
• Paragraph formatting
• Advanced paragraph formatting

Creating and Managing Tables

• Creating tables
• Working with tables
• Modifying tables

Controlling Page Layout

• Creating headers and footers
• Working with margins
• Working with page breaks

Proofing and Printing Documents

• Checking spelling and grammar
• Previewing and printing documents

Web Features

• Saving documents as web pages
• Working with hyperlinks
• Emailing documents

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.

Public Course Availability

Word Training - Basic Skills (New Users) is available as a public course on the following dates at the venues shown. You can book yourself and other delegates onto any of these courses simply by clicking the Book now buttons.

At the end of the course delegates will be able to:

• Be proficient in Microsoft PowerPoint
• Use templates to build custom presentations
• Introduce stimulating graphical and animated content
• Understand advanced delivery options
• Customise your workspace
• Inter-relate your presentation with both Excel and Word files

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for 10 delegates attending.

None - the course is for proficient users of PowerPoint

Building Custom Presentations

• Modifying templates
• Building custom templates
• Building custom slide masters
• Advanced slide master techniques

Using Multimedia in Presentations

• Advanced clip art and drawing techniques
• Adding movies and sound
• Using animations
• Using scanned images

Using Organisation Charts and Tables

• Advanced organisation chart options
• Formatting and modifying tables

Advanced Presentation Techniques

• Adding special effects
• Working with slide show options
• Setting up review cycles

Advanced Presentation Delivery Options

• Working with shared workspaces
• Working with the package for CD feature
• Advanced delivery techniques

Customising the Environment

• Customising and creating toolbars
• Automating your work

Microsoft Office Integration

• Working with Excel
• Working with Word

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.

At the end of this course the delegates will be able to:

• Have a good working knowledge of PowerPoint basics.
• Create presentations from scratch
• Improve the format of text
• Import and manipulate graphics
• Use the PowerPoint drawing tools
• Use chart and table design tools
• Modify your presentation
• Deliver a live presentation

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for 10 delegates attending.

None

PowerPoint Basics

• Exploring the PowerPoint environment
• Help options
• Closing presentations and closing PowerPoint

Building New Presentations

• Creating new presentations
• Saving presentations
• Working in the outline tab
• Rearranging and deleting slides
• Using slides from other presentations

Formatting and Proofing

• Exploring text formatting
• Moving and copying text
• Setting tabs and alignment

Using the spelling checker

• Examining AutoCorrect and the style checker
• Using Drawing Tools
• Drawing objects
• Using AutoShapes

Working with text in objects

• Enhancing objects
• Working with WordArt and Clip Art
• Working with WordArt
• Adding clip art

Using Tables and Charts

• Working with tables
• Creating and enhancing charts
• Creating organization charts

Enhancing Presentations

• Using templates
• Working with the slide master
• Working with multiple slide masters
• Adding transitions and timings
• Adding speaker notes and footers

Delivering Presentations

• Running presentations
• Printing presentations
• Exporting to other formats
• Saving presentations for web delivery

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.

Delegates at the end of the advanced course will be able to:

• Have a complete understanding of the higher functions of Access
• Learn to automate functions by creating simple and then very advanced macros
• Understand advanced querying
• Add SQL statements in your queries
• Work with objects
• Understand the fundamentals of database management
• Protect valuable data sources
  

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for 10 delegates attending.

None - proficient users of Access only, or delegates who have completed our database creation course

PivotTables and PivotCharts

• Create a PivotTable
• Modify a PivotTable
• Working with a PivotChart

Creating Advanced Forms

• Designing a form based on joined tables
• Automating data entry
• Grouped control
• How to improve the user interface
• Designing subforms

Macros

• Create and run macros
• Attach macros to events of database objects

Creating Advanced Macros

• Create macros to provide user interaction
• Create macros requiring user decision
• Use AutoKeys and AutoExec macros

Exploring Access SQL

• How to identify different clauses in an SQL statement
• Writing SQL statements
• Attach an SQL statement to database objects

Integrating the Internet

• Work with hyperlink fields
• Work with data access pages

Managing Databases

• Work with database utilities to optimise resources
• Secure data by database replication

Security Fundamentals

• Protect databases

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.

This 2 day course will enable a new user / non trained user to create a fully workable database for your organisation.

At the end of this course the delegates will:

• Have a good working knowledge of Microsoft Access.
• Be able to create a database from scratch.
• Understanding and use tables, fields and records and the rules for entering data
• Create simple queries, use forms and, ultimately create reports
• Understand relational databases and be able to work with related tables

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for up to 10 delegates attending.

None

Day 1 -

Database Concepts

• Database concepts and terminology
• Exploring the Access environment
• Planning and designing databases
• Getting help
• Closing a database and Access

Access Basics

• Exploring tables
• Examining queries
• Exploring reports

Creating Databases

• Creating a database
• Using the table wizard
• Working in design view

Working with Fields and Records

• Changing the design of a table
• Adding and deleting records
• Finding and editing records
• Sorting and filtering records

Querying Tables

• Creating and using queries
• Modifying query results and queries
• Using calculations in queries

Creating and Using Forms

• Creating forms by using AutoForm
• Using the form wizard
• Using design view
• Finding, sorting and filtering records

Creating and Using Reports

• Using the report wizard and queries
• Creating, modifying and printing reports

Importing, Exporting and Linking Objects

• Importing Access objects
• Exporting Access objects
• Linking Access objects

Day 2

Creating relational databases

• Database normalising
• Introducing relating tables
• Adding referential integrity

Working with related tables

• The lookup wizard
• Changing lookup fields
• Inputting data to related tables

Defining data entry rules

• Using input masks
• Setting a property
• Setting a validation rule

Using advanced query features

• How to join a table in queries
• Creating a calculated field
• Using an action query

Creating advanced queries

• Summarise and group values
• Create a crosstab query
• Using a parameter query

Creating advanced form design

• Working with graphics
• Working with calculations
• Working with combo boxes
• Working with unbound controls

Using advanced report features

• Create customized headers and footers
• Add a calculated value
• Work with sub-reports

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.