Office 2010 Training (1-2-1 or to Groups)

Who is the course for?

Basic Course – Aimed at those with little or no knowledge.

Intermediate Course – Delegates with some knowledge or those using an application on a day to day basis.

Advanced – For those with a wide knowledge of the application but needing more hints/tips.

What will I study?

Introductory Level (Delivered 1-2-1 or Tailored to Groups)

Word Basic Editing Helpful Word Features Formatting Text Working with Graphics Formatting Paragraphs and Documents Increasing Efficiency Using Word Working with Documents PowerPoint Creating/Enhancing PowerPoint Presentations Working with Visual Elements Backgrounds Images Styles Expanding on PowerPoint Basics Excel Changing the Appearance of a Worksheet Worksheet Charts Organising Worksheet Formulas Working with Multiple Worksheets Function Formulas Making the Worksheet Useful

Introductory – Intermediate Level (Delivered 1-2-1 or tailored to Groups)

Access Manipulating Data Reports and Macros Automatically Creating and Modifying Forms Integrating Access Manually Creating and Modifying Forms Finding and Ordering Data Filtering Basic Queries Advanced Queries

Intermediate – Advanced Level (Delivered 1-2-1/or tailored to Groups)

Word Working with tables Use of Auto-text Using styles Drawing Working with large documents Working with Columns Advanced Working with tables Form design Advanced Drawing Using advanced styles – VBA Macro Scripts Using formula in forms Use of various tools Excel Multiple sheets and worksheets Customising charts 3D Formulas Taking charts further Advanced formatting Drawing in Excel Advanced formulas Nested Functions Lookups Advanced 3D Formulas Excel as a database Pivot tables Bespoke modelling, macros What if’s & Goal Seeking PowerPoint Enhancing existing PowerPoint Presentations Expanding on PowerPoint Basics Modify Backgrounds Editing Images Understanding Styles Understanding Visual Elements Tailoring PowerPoint to your company’s needs Creating successful business presentations Hiding elements Theory behind public speaking Using your own Images Packaging PowerPoint

We also deliver Outlook training from basic through to intermediate and advanced levels. These courses can only be delivered on site at a company premises as our student network does not allow for some of the options to be included within the course: Topics include:

Send a Simple Message Print a Message Reading Messages, Reply to and Forward a Message Delete a Message Address & format a Message Check Spelling and Grammar Attach a file Open and Save an Attachment Flag a Message Organise content with folders Add Sort and Find a Contact Find the Geographical Location of a Contact Explore the Outlook Calendar & Schedule an Appointment Manage Contacts Assign Categories and Edit Appointments Create Edit and Update a Task Create & Edit a Note Set Word Days and Times on Calendar Display an Additional Time Zone Set Availability Options Modify Message Settings Modify Delivery Options Change the Message Format Create a Distribution List Notify Others That You Will Be Out of the Office Insert a Hyperlink Automatically Record a Journal entry Manually Record a Journal Entry Modify a Journal Entry Assign a Task Reply to a Task Request Send a Task Update Track Assigned Tasks Customise the Toolbar Create a New Toolbar Organise Messages & Manage Junk Mail Customise the Menu Bar Find Outlook Items Using Multiple Criteria Customise the Quick Access Toolbar Find & Filter Messages Customise the To-Do Bar Sort Messages Using Multiple Criteria Create a Folder Home Page

Please note that we offer these courses on Versions 2003 and 2007 and 2010, therefore please ensure that you state, upon booking, which version you require.

How will the course be delivered?

These courses will now be delivered by either 1-2-1 training or to groups on a tailored basis.

1-2-1 Training – This intensive training can be delivered on site at a company (if applicable) or at college. A tutor would be assigned to deliver 1.5 hours of training on a particular subject to 1 person at one time. The cost for this is £60 per hour and we would normally suggest that 1.5 hours of training would suffice per subject (at a total fee of £90).

Groups or Bespoke/Tailored Courses – these can be delivered either on site at college or on your premises (if applicable) if you have a training room, at dates and times to suit yourselves, I can quote you for this type of training dependent on your needs as and when required. The beauty of this type of course is that it can be specifically tailored to your/your colleagues exacting needs, ensuring that they receive the full benefit and impact required from the course to assist them in their employment.

Course Entry Criteria

No specific entry criteria for this course. All welcome.

The college operates a no refunds policy as detailed below. Cancellations and transfer requests are subject to the following conditions:

• More than 4 weeks notice – no charge
• 4 weeks notice – 30% of the cost
• 2-3 weeks notice – 50% of the cost
• 1-2 weeks notice – 75% of the cost
• Less than 1 weeks notice – 100% of the cost

All cancellations must be made in writing and are subject to a £10 administration charge. The full fee’s policy is available on request.

What will I get at the end of the course?

You will receive a Blackburn College Certificate of attendance upon successful completion of the training.

What can I do next?

Why not consider our other IT training courses on our website?

How much does it cost?

1-2-1 Intensive Training Courses are priced at £60 per hour (i.e. £90 per 1.5 hours) per level per delegate.

Group delivery – Prices will be quoted on an individual basis and therefore please contact us on 01254 292500 to discuss this method of delivery further.

(Prices are subject to change)