COMPUTER SKILLS TRAINING

Nothing Found!!Nothing Found!!

We now offer Microsoft Computer Skills Training through our experienced Computer Training Consultant. We offer:

Windows – versions 7, 8 and 10 (and all versions of Microsoft Office)

  • Word Introduction

    Who is this course for?

    Our Microsoft Word Introduction course is suitable for complete beginners to Microsoft Word.

    Prerequisites

    A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Word is required.

    Benefits

    At the end of this one day Word training course you will have a good working knowledge of Word basics. You will feel more confident using Word and be able to create a document from scratch. Understanding and using some of the built in layout and text editing functionality will enable you to produce far more striking and effective documentation in your work and home Word environments. Documents that you create will be easier to read and look more presentable.

    After completing this Word Introduction Course you will be prepared to attend the Word Intermediate training course.

    Course Syllabus

    What's new in Word

    Getting Started

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

    Editing Documents

    Opening and navigating in documents
    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
    Paragraph formatting
    Advanced paragraph formatting

    Creating and Managing Tables

    Creating tables
    Working with tables
    Modifying tables

    Controlling Page Layout

    Working with margins
    Working with page breaks

    Proofing and Printing Documents

    Checking spelling and grammar
    Previewing and printing documents

  • Word Intermediate

    Who is this course for?

    Our Microsoft Word Intermediate training course is suitable for those with a basic working knowledge of Microsoft Word.

    Prerequisites

    A working knowledge of Word is required, or our Word Introduction course.

    Benefits

    This Microsoft Word training course is designed for those users who wish to improve their current knowledge of Word and take advantage of the more complex features. You will be able to divide a document into sections and columns, to format tables and populate them with data directly from Excel spreadsheets. You will also learn how to add recurrent data to documents in a series such as page numbers and headers. Finally you will be shown how to prepare labels and envelopes, add your company logo to a letter and set up a template for future mail.

    After completing this word course you will be prepared to attend the Word Advanced training course.

    Course Syllabus

    What's new in Word

    Working with Large Documents

    Inserting and deleting Page Breaks
    Creating and formatting sections
    Working with Headers and Footers
    Inserting Page Numbers

    Working with Styles and Building Blocks

    Applying styles
    Modifying and deleting styles
    Using styles to create outlines
    Quick Parts

    Formatting Tables

    Table formatting
    Borders and shading
    Table Styles

    Working with Excel Data

    Working with Excel data in Word
    Performing calculations in tables

    Working with Graphics

    Inserting pictures
    Formatting pictures
    Using SmartArt
    Inserting WordArt and symbols
    Applying watermarks
    Using shapes

    Document Templates

    Using templates
    Creating templates

  • Word Advanced

    Who is this course for?

    Our Microsoft Word Advanced course is suitable for those with a sound working knowledge of Word who wish to progress to the most complicated functions and features. It is also suitable for those seeking MS Word Formatting Training.

    Prerequisites

    A good working knowledge of Word is required, or our Word Intermediate course.

    Benefits

    At the end of this Word course you will have a complete understanding of the higher functions of Word. You will be able to perform the most advanced functions, including merging your documents with databases for mail-shots and producing well-defined forms. You will learn how to work with extremely large documents and how to use macros to speed through any repetitive functions.

    Course Syllabus

    What's new in Word

    Using Mail Merge

    Creating form letters
    Working with data sources
    Creating mailing labels

    Working with Forms

    Creating forms
    Modifying forms
    Protecting and printing forms

    Templates

    Use Word pre-set templates
    Create and editing a template

    Columns

    Working with multiple columns
    Working with text in columns

    Working with Large Documents

    Creating a Table of Contents
    Master documents
    Footnotes and endnotes
    Indexes
    Bookmarks and cross-references

    Managing Document Revision

    Using track changes
    Comparing document

    Automation and Customisation

    Recording and running macros
    Modifying and deleting macros
    Customise Word

  • Excel – basic
  • Excel- intermediate
  • Excel – advanced
  • PowerPoint Introduction

    Who is this course for?

    Our Microsoft PowerPoint Introduction course is suitable for complete beginners to Microsoft PowerPoint.

    Prerequisites

    A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS PowerPoint is required.

    Benefits

    At the end of this course you will have a good working knowledge of PowerPoint basics. You will feel more confident using PowerPoint and be able to create a presentation from scratch. You will learn how to improve the format of your text as well as getting to grips with importing and manipulating graphics, using the PowerPoint drawing tools and the chart and table design tools to make your presentation much more visually stimulating. You will also learn how to make modifications to your presentation before you learn how PowerPoint is used in a live presentation.

    After completing this course you will be prepared to attend the PowerPoint Advanced training course.

    Course Syllabus

    PowerPoint Design Tips and Techniques
    What's new in PowerPoint

    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 and slide sorter
    Rearranging and deleting slides
    Using slides from other presentations

    Formatting and Proofing

    Moving and copying text
    Text formatting
    Setting tabs and alignment
    Using the spelling checker and AutoCorrect
    Using templates and themes

  • PowerPoint Intermediate/Advanced

    Who is this course for?

    Our Microsoft PowerPoint Intermediate/Advanced course is suitable for those with a working knowledge of PowerPoint who wish to progress to the most complicated functions and features.

    Prerequisites

    A working knowledge of PowerPoint or our PowerPoint Introduction course.

    Benefits

    On completion of this course you will be proficient in Microsoft PowerPoint.

    You will be able to use templates to build custom presentations and introduce much more stimulating graphical and animated content.

    We will show you how to use the advanced delivery options, customise your workspace and link your presentation with both Excel and Word files.

    Course Syllabus

    PowerPoint Design Tips and Techniques
    What's new in PowerPoint

    Customising Presentation Templates

    Modifying templates
    Building custom templates and themes
    Building custom slide masters
    Advanced slide master techniques

    Enhancing Presentations

    Advanced drawing techniques
    Using alignment tools
    Sourcing and enhancing images
    Adding movies and sound
    Using animations and transitions

    Using SmartArt, Tables and Charts

    Inserting and editing SmartArt
    Creating organisation charts
    Formatting and modifying tables
    Inserting and designing charts and graphs
    Working with Excel – linking tables and charts

  • Project Introduction

    Who is this course for?

    Our Microsoft Project Introduction course is suitable for complete beginners to Microsoft Project.

    Prerequisites

    A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Project is required.

    Benefits

    At the end of this course you will have a good working knowledge of MS Project basics. You will feel confident using Project and be able to define, schedule and monitor tasks using a variety of tools and views.

    After completing this course you will be prepared to attend the Project Intermediate training course.

    Course Syllabus

    Introduction to Ms Project

    Basic project management concepts
    Project environment overview including what's new
    Navigation including customising the Ribbon and Backstage View
    Getting Help

    Task creation and scheduling

    Creating a task list
    Modifying a task list
    Change Highlighting
    Multi-Level undo
    Manual Scheduling
    Structuring tasks to create an outline

    Scheduling Tasks

    Working with base calendars
    Named calendar exceptions
    Defining recurring exceptions and work weeks
    Auto Scheduling
    Creating task relationships
    Types of task relationship
    Using lag and lead times
    Recurring tasks
    Setting constraints
    Setting deadlines
    Using the critical path
    Task Drivers
    Working with top down planning
    Inactivate tasks

    Using task views

    Working with the Timeline
    Using calendar view
    Using network diagram view
    Modifying views
    Modifying the Timescale, Zoom and Zoom slider

    Formatting and Sharing information

    Project Properties
    Adding notes & hyperlinks
    Copy / paste Picture
    Copy / paste tasks and rows
    Formatting Bars and the Gantt area
    Formatting for printing
    Troubleshooting printing Gantt charts
    Using Background highlighting
    Working with built-in reports

  • Project Intermediate

    Who is this course for?

    Our Microsoft Project Intermediate course is suitable for those with basic working knowledge and experience of MS Project.

    Prerequisites

    A working knowledge of Project or our Project Introduction course. You will need to have prior knowledge of the Project Management fundamentals or other Project software applications.

    Benefits

    This course is designed for those users who wish to improve their current knowledge of Project to take advantage of the more complex features. On completion of the course, delegates will use project to help manage their resources and costs; to set plans, deadlines and schedules. At this level they will be able to track their project and create and print Gantt charts and reports.

    After completing this course you will be prepared to attend the Project Advanced training course.

    Course Syllabus

    Managing Resources and Costs

    Creating work, material and cost resources
    Working with multiple calendars
    Assigning resources
    Effort Driven Scheduling
    Task Types
    Working with resource costs and fixed costs
    Work contours
    Working with the Team Planner
    Identifying budget variance

    Finalising the Plan

    Reviewing the schedule
    Levelling resource over-allocation

    Tracking

    Creating baselines
    Entering project progress
    Viewing variance information

    Analyse and adjust a schedule

    Analysing schedules
    Reschedule the project
    Adjustment of resource schedules
    Progress lines

    Filters and sort

    Add new columns
    Working with auto filters
    Applying built-in filters
    Sorting and grouping data

    Manage multiple projects

    Consolidating and sharing projects
    Resource pools: Sharing resources across projects
    Levelling and reporting across multiple projects

    Exchange project data

    Import, export and copy data from Microsoft Excel
    Enhanced copy and paste
    Copy Picture

  • Project Advanced

    Who is this course for?

    Our MS Project Training Advanced course is suitable for those with a sound working knowledge of Project or have migrated from an older version and wish to progress to the most complicated functions and features.

    Prerequisites

    A working knowledge of Project or our Project Intermediate course.

    Benefits

    At the end of this course you will have a complete understanding of the higher functions of Project. You will be able to perform the most advanced functions of managing a project and operate multiple projects. Your Project expertise will enable you to customise your layouts and take your macro skills on to new levels of sophistication while your ability to create and use templates will speed up your future Project process.

    Course Syllabus

    Custom Filters and Groups

    Creating custom filters
    Filtering using calculations
    Creating custom groups

    Custom Calculated Fields

    Creating custom fields
    Calculated custom fields
    Using custom indicators

    Custom Tables and Views

    Creating a table
    Creating a view

    Comparison

    Comparing versions of plans

    Budgeting Resources

    Creating and tracking resource budgets

    Analyse Project Data using Excel

    Creating custom export maps

    Visual reporting

    Using, modifying and creating visual reports

    Macro Features

    Recording a macro
    Running a macro
    Assigning macros to toolbars

    Project Templates

    Creating a template
    Editing a template
    Using templates
    How to use the organiser

OneNote

  • Access Introduction

    Who is this course for?

    Our Microsoft Access Introduction course is suitable for complete beginners to Microsoft Access.

    Prerequisites

    A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Access is required.

    Benefits

    At the end of this course you will have a good working knowledge of Microsoft Access training basics. You will feel more confident using Access, and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and, ultimately create reports.

    After completing this course you will be prepared to attend the Access Intermediate training course.

    Course Syllabus

    What's new in Access

    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

  • Access Intermediate

    Who is this course for?

    Our Microsoft Access Intermediate course is suitable for those with a basic working knowledge of Microsoft Access.

    Prerequisites

    A working knowledge of Access is required, or our Access Introduction course.

    Benefits

    This course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports before tackling PivotCharts and PivotTables.

    After completing this course you will be prepared to attend the Access Advanced training course.

    Course Syllabus

    What's new in Access

    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

  • Access Advanced

    Who is this course for?

    Our advanced Microsoft Access training course is suitable for those with a sound working knowledge of Access who wish to progress to the most complicated functions and features.

    Prerequisites

    A working knowledge of Access is required, or our Access Intermediate course.

    Benefits

    At the end of this course you will have a complete understanding of the higher functions of Access. You will learn to automate functions by creating simple and then very advanced macros. You will advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources.

    You will then be qualified to progress to the VBA course for Access.

    Course Syllabus

    What's new in Access

    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

    Managing Databases

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

    Security Fundamentals

    Protect databases

Microsoft Publisher

  • Publisher

    Who is this course for?

    This course is suitable for anyone who needs to create newsletters, business cards, brochures and pamphlets and tends to use Microsoft Word to create them.

    Prerequisites

    A working knowledge of Windows is required or our Microsoft Windows Introduction course. No experience otherwise is required.

    Benefits

    • Understanding different visual and design elements
    • Creating publications that send in html format
    • Creating templates for future use

    Course Syllabus

    Basic Skills

    Page Layout
    Creating Frames
    Adding Text & Pictures
    Modifying Frames
    Open, Close
    Save a Publication

    Working with Text Boxes

    Text Flow
    Line & Character Spacing
    Indents
    Lists
    Tabs
    Styles
    Headers & Footers
    Vertical Text Alignment

    Working with Text

    Formatting Text
    Rotating Text
    Paragraph Formatting
    Styles
    Spell Check
    Flowing
    Importing

    Tables

    Creating & Modifying tables
    Applying Borders

    Drawing Tools

    Drawing Objects
    Formatting Objects
    Grouping
    WordArt

    Graphic Objects

    Using Clip Art
    Importing Images
    Resizing
    Cropping
    Re-colouring
    Rotating Pictures

    Multi-Page Publications

    Inserting New Pages
    Navigating
    Flowing Text between Pages

    Background Pages

    The Background Page
    Headers & Footers
    Page Numbering

    Publication Wizards

    Create a Publication by Wizard
    Create a Publication by Design

    Printing Publications

    Changing Page Layout

    Working with Newsletters

    Getting Started with Newsletters
    Modifying Newsletters

Visio

  • Visio Introduction

    Who is this course for?

    Our Microsoft Visio introduction course is suitable for complete beginners to Microsoft Visio.

    Prerequisites

    A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Visio is required.

    Benefits

    • At the end of this course you will have a good working knowledge of Visio basics.
    • You will feel more confident using Visio and be able to able to create a diagram or a chart.
    • Understanding and using some of the built-in drawing and object manipulation functionality will enable you to progress to creating concise and clear diagrams and charts.
    • Structures that you create will be easier to build, amend, read and will be professionally formatted.
    • After completing the Visio beginners course you will be prepared to attend the Visio Advancedtraining course.

    Course Syllabus

    Getting Started

    The Visio Drawing Window
    Toolbars
    Overview of Templates, Stencils and Shapes
    Changing View Settings

    Drawing Tools

    Creating New Drawings
    Drawing Closed Shapes
    Drawing Open Shapes
    Using the Freeform tool
    Drawing Compound Lines
    Finding Stencils and Shapes

    Creating Basic Diagrams

    Selection Techniques
    Connecting Shapes
    Moving and Deleting Shapes
    Aligning Shapes
    Distributing Shapes
    Rotating Shapes
    Grouping Shapes

    Formatting Shapes

    Shape formatting
    Adding Text to Shapes
    Formatting Text
    Duplicating Shapes
    Scaling and resizing Shapes
    Using Themes (2007 version only)

    Working with Pages

    Inserting, Naming and Deleting Pages
    Page and Printer Setup
    Creating Background Pages
    Inserting Headers and Footers

    Building Diagrams

    Creating Organisation Charts
    Adding Multiple Shapes
    Modifying Chart Layouts
    Creating a Flowchart
    Creating a Brainstorming Diagram
    Using the Brainstorming Outline Window

  • Visio Advanced

    Who is this course for?

    Our Microsoft Visio intermediate/advanced training course is suitable for those who are familiar with the basic functions and features of Microsoft Visio.

    Prerequisites

    A basic working knowledge of Visio is required, or our Microsoft Visio Introduction course.

    Benefits

    • This course is designed for those users who wish to advance their current knowledge of Visio to take advantage of the more complex features.
    • You will feel more confident using Visio and be able to create technical layouts, work flow & fishbone diagrams and many more advanced diagram types.
    • Understanding and using the built-in interoperability between your diagrams and data, such as the database wizard, will allow for much more complexity.
    • Finally you will learn how to work with far more advanced custom shape designs.

    Course Syllabus

    Creating Technical Layouts

    Understanding Layers
    Creating, Removing and Renaming Layers
    Setting Layer Properties
    Controlling Shape Placement
    Setting a Drawing Scale
    Working with Building Plan Layouts
    Drawing with Precision
    Using Perspective
    Working with Area Measurements

    Exploring Advanced Diagrams

    Create work flow diagrams
    Create Fishbone (Cause and Effect) diagrams
    Use Calendars, Gantt and PERT charts
    Create easy-to-read maps and route directions

    Diagramming and Data

    Adding Shape Data
    Creating Custom Properties
    Generating Property Reports
    Importing and Exporting Data
    Working with Data Sources
    The Database Wizard

    Advanced Custom Shape Design

    Creating New Shapes
    Revising Existing Shapes
    Locking and Protecting Shapes
    Creating Custom Stencils
    Adding Shapes to the Stencil
    Saving the Stencil

Lync/Skype

  • Skype for Business – ½ day course

    Skype for Business is an authoritative integrated communications client. Users are able to send instant messages, make voice or video calls, and broadcast their availability. They are also able to share presentations and applications.

    Skype for Business can help to make staff more efficient and improve communication within the organisation and with people outside the organisation. As this tool is often new to users, the use of Skype may be limited without training.

    This course introduces end-users to Skype for Business, teaching them to use the communication tools and facilities that are now so prominent throughout Windows, Microsoft Office and Office 365.

    Course Syllabus

    Your availability, AKA Presence

    Set availability and see others availability (throughout Microsoft Office)
    Change your presence information
    Presence status meanings

    Contacts

    Finding the correct person through Skype for Business
    Build/manage contact list in Skype for Business
    Using groups and frequent contacts
    Viewing full information about a contact

    Instant Messaging (IM)

    How to send/receive instant messages
    Participation in a group IM session
    What happens if you don’t respond to an IM?
    Saving IM conversations
    Using IM rather than phone or email

    Voice Calls

    How to check microphone and speakers
    Making voice calls with Skype for Business
    Accepting or declining calls through Skype for Business
    Locating and calling users from Skype for Business and anywhere in Office
    Intro to audio conferencing
    How to change call settings

    Delegate Management

    Forwarding a call to another person
    How to manage calls for someone else

    Video Calls

    How to check webcam settings
    How to make a video call
    How to change video settings
    One-to-one calls, video conferencing

    Virtual Meetings

    How to schedule or create virtual meetings
    How to organise and run a virtual meeting
    How to connect outside users to a virtual meeting

    Sharing Presentations and Applications

    How to share desktops and applications
    How to use whiteboards, polls, other meeting tools
    How to control virtual meetings and webinars

    Recording

    How to record calls and virtual meetings
    Sharing and managing recordings

    Advanced Skype for Business usage (if technically supported)

    How to use Skype for Business with other devices, including mobile
    How to call outside of your business/organisation

Courses can be delivered at a venue to suit or on your premises. We provide courses for groups of up to 12 people or 1:1 masterclass across Scotland and North of England. Course outlines are listed however if you wish to proceed with training we will discuss your specific requirements in detail prior to the delivery of any course. This will include course duration, timings, on your premises or off-site and agree on a cost-effective solution for you. We can deliver one of courses or regular training. Garland Safety have significant experience in delivering major roll outs of new computer software packages across Scotland including Highlands and Islands.

Let us know your requirements – we have the solution for you!

Contact Us

info@garlandsafety.com

Telephone – 07960170798