Events in Guildford:

Pitman Training Guildford
Guildford, UK

Course Description: Word Level 1 (Beginner)
Word processing is the use of computers to create, revise, and save documents for printing and future retrieval. This course is the first in a series of three Microsoft Office Word courses. It will provide you with the basic concepts required to produce basic business documents.

Prerequisites: This course assumes that you are familiar with using personal computers and have used a mouse and keyboard (basic typing skills are recommended). You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Target student: Persons with a basic understanding of Microsoft Windows who need to learn how to use Microsoft® Word to create, edit, format, lay out, and print standard business documents complete with tables and graphics.

Length: One Day

Click back button above to see course dates and fees.

Note that training is also provided at Intermediate and Expert levels.

Course Contents:

Word Level 1 (Beginner)

Lesson 1: Creating a Basic Document

Topic 1A: The Word Environment

Topic 1B: Get Help Using Word

Topic 1C: Enter Text

Topic 1D: Save a New Document

Topic 1E: Preview a Document

Topic 1F: Print a Document

Lesson 2: Editing a Document

Topic 2A: Navigate in a Document

Topic 2B: Insert Text

Topic 2C: Select Text

Topic 2D: Create an AutoText Entry

Topic 2E: Move and Copy Text

Topic 2F: Delete Blocks of Text

Topic 2G: Undo Changes

Topic 2H: Find and Replace Text

Lesson 3: Formatting Text

Topic 3A: Change Font and Size

Topic 3B: Apply Font Styles and Effects

Topic 3C: Change Text Color

Topic 3D: Highlight Text

Topic 3E: Copy Formats

Topic 3F: Clear Formatting

Topic 3G: Find and Replace Text Formatting

Lesson 4: Formatting Paragraphs

Topic 4A: Set Tabs

Topic 4B: Change Paragraph Alignment

Topic 4C: Indent Paragraphs

Topic 4D: Add Borders and Shading

Topic 4E: Apply Styles

Topic 4F: Create Lists

Topic 4G: Change Spacing Between Paragraphs and Lines

Lesson 5: Proofing a Document

Topic 5A: Use the Thesaurus

Topic 5B: Check Spelling and Grammar

Topic 5C: Create a New Default Dictionary

Topic 5D: Check Word Count

Topic 5E: Modify a Document in Print Preview

Lesson 6: Adding Tables

Topic 6A: Create a Table

Topic 6B: Enter Data in a Table

Topic 6C: AutoFormat a Table

Topic 6D: Convert Text into a Table

Lesson 7: Inserting Graphic Elements

Topic 7A: Insert Symbols and Special Characters

Topic 7B: Insert a Clip Art Picture

Topic 7C: Add a Watermark

Lesson 8: Controlling Page Appearance

Topic 8A: Set Page Orientation

Topic 8B: Change Page Margins

Topic 8C: Apply a Page Border

Topic 8D: Add Headers and Footers

Topic 8E: Insert a Page Break
Read more »

Pitman Training Guildford
Guildford, UK

Course Description: Access Level 1 (Beginner)
Most organisations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database and the Microsoft Office Access relational database application and its information management tools.

Prerequisites: Windows Introduction or equivalent knowledge.

Target student: This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day to day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.

Length: One Day

Note that training is also provided at Intermediate and Expert levels

Click back button above to see course dates and fees.

Course Contents:

Access Level 1 (Beginner)

Lesson 1: An Overview of Access

Topic 1A: Understand Relational Databases

Topic 1B: Examine the Access Environment

Topic 1C: Open the Database Environment

Topic 1D: Examine an Access Table

Lesson 2: Managing Data

Topic 2A: Examine an Access Form

Topic 2B: Add and Delete Records

Topic 2C: Sort Records

Topic 2D: Display Recordsets

Topic 2E: Update Records

Topic 2F: Run a Report

Lesson 3: Establishing Table Relationships

Topic 3A: Identify Table Relationships

Topic 3B: Identify Primary and Foreign Keys in the Relationships Window

Topic 3C: Work with Subdatasheets

Lesson 4: Querying the Database

Topic 4A: Create a Select Query

Topic 4B: Add Criteria to a Query

Topic 4C: Add a Calculated Field to a Query

Topic 4D: Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms

Topic 5A: Examine Form Design Guidelines

Topic 5B: Create a Form Using AutoForm

Topic 5C: Create a Form Using the Form Wizard

Topic 5D: Modify the Design of a Form

Lesson 6: Producing Reports

Topic 6A: Create an AutoReport

Topic 6B: Create a Report by Using the Wizard

Topic 6C: Examine a Report in Design View

Topic 6D: Add a Calculated Field to a Report

Topic 6E: Modify the Format Properties of a Control

Topic 6F: AutoFormat a Report

Topic 6G: Adjust the Width of a Report
Read more »

Pitman Training Guildford
Guildford, UK

Course Description: PowerPoint Level 1 (Beginner)
In the past, you have used paper-based overhead systems to give presentations. Now, you want to upgrade those presentations to an electronic format. You can use Microsoft Office PowerPoint to give electronic presentations.

Prerequisites: Windows Introduction or equivalent knowledge.

Target student: This course is designed for students who are interested in learning the fundamentals needed to create and modify basic Microsoft PowerPoint presentations.

Length: One Day

Note that we also a follow up course at Expert level.

Course Contents:

PowerPoint Level 1 (Beginner)

Lesson 1: An Orientation to PowerPoint

Topic 1A: The PowerPoint Environment

Topic 1B: Orientation to Views

Topic 1C: Navigate Through a Presentation

Topic 1D: Edit Slide Text

Topic 1E: Save the Presentation

Topic 1F: Run a Slide Show

Lesson 2: Beginning a Presentation

Topic 2A: Create a New Presentation

Topic 2B: Change Background Color

Topic 2C: Add Slides to a Presentation

Topic 2D: Enter Text

Topic 2E: Create a Presentation from a Microsoft Word Outline

Lesson 3: Formatting Text Slides

Topic 3A: Apply Character Formats

Topic 3B: Align Text

Topic 3C: Change Line Spacing

Topic 3D: Change Indents

Lesson 4: Adding Tables to a Presentation

Topic 4A: Create a Table

Topic 4B: Format Tables

Topic 4C: Insert a Table from Microsoft Word

Lesson 5: Charting Data

Topic 5A: Create a Column Chart

Topic 5B: Edit Chart Data

Topic 5C: Change Chart Type

Topic 5D: Insert a Chart from Microsoft Excel

Lesson 6: Modifying Objects

Topic 6A: Resize Objects

Topic 6B: Copy and Duplicate Objects

Topic 6C: Move Objects

Topic 6D: Changing Object Orientation

Topic 6E: Format Objects

Topic 6F: Group and Ungroup Objects

Topic 6G: Change the Order of Objects

Lesson 7: Adding Images to a Presentation

Topic 7A: Add Clip Art

Topic 7B: Add a Picture from a File

Topic 7C: Draw Lines and Shapes

Topic 7D: Insert WordArt

Lesson 8: Preparing to Deliver a Presentation

Topic 8A: Spell Check

Topic 8B: Arrange Slides

Topic 8C: Add Transitions

Topic 8D: Create Speaker Notes

Topic 8E: Send a Presentation to Microsoft Word

Topic 8F: Print the Presentation

Topic 8G: Package a Presentation for CD
Read more »

Pitman Training Guildford
Guildford, UK
Microsoft Project Level 2 is the second course in the Microsoft Project series. In Microsoft Project Level 1 , you used your project management skills to create a complete project plan. This course will build upon that knowledge, and give you the opportunity to work with a project plan once it has entered the project implementation phase.

Prerequisites: Students enrolling in this class should have an understanding of project management concepts. Knowledge of a Windows operating system. Microsoft Project Level 1 – Creating a project.

Benefits: You will exchange project plan data with other applications, update project plans, create custom reports, and reuse project plan information.

Target student: This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage those project plans. It is also intended for a person who has a basic understanding of Microsoft Project.

Length: One Day

Course Contents:

Project Level 2 – Managing a Project

Lesson 1: Calendars

A detailed review of both Project and Resource Calendars to show how to maximise resource availability within your projects.

Lesson 2: Project Consolidation
The concept of project consolidation where several projects may be required to be inserted into one overall project.

Lesson 3: Sharing Resources
The concept of one pool of resources being assigned to multiple projects.

Lesson 4: Base Planning and Tracking
Comparing actual progress with original project plan

Lesson 5: Printing & Reports

Printing, reporting and the customisation of reports.

Lesson 6: Functionality

Recurring tasks

Task splitting

Network diagram

Customise the Gantt chart

Sorting projects

Customise toolbars

Custom fields

Create new views

Create new tables

Create new filters

Create a corporate Global file
Read more »

Pitman Training Guildford,
Guildford, UK

Excel 2003 Level 1

Lesson 1: Getting Started with Excel
Topic 1A: An Overview of Excel, Topic 1B: Navigate in Excel, Topic 1C: Select Data, Topic 1D: Enter Data, Topic 1E: Save a Workbook, Topic 1F: Obtain Help Read more »