Microsoft Project Training Courses Leeds West Yorkshire

Microsoft Project Training Courses.We are currently delivering Microsoft Project training courses in Leeds, West Yorkshire. Arranging training at your own offices is very often more cost effective than sending employees on public open courses. Keeping in mind that the average open course is in the order of £280 + VAT per delegate, here are our onsite training daily rates:

  • 1 – 3 learners: £450
  • 4 – 6 learners: £500
  • 7 – 10 learners: £550

Please note that these rates are per group and not per person. Therefore for a group of 10 delegates the cost is just £55 per person. Our onsite training rate includes individual Microsoft Project training manuals, sample files & course certificates. Here is a brief overview of our onsite Microsoft Project training courses content:

Foundation Microsoft Project

  • Introduction to the main MS Project Views
  • How MS Project creates the Gantt Chart
  • Creating & defining a new project
  • Defining project working times
  • Creating custom calendars
  • Entering and outlining project tasks
  • Understanding task linkage types
  • How to link tasks correctly
  • Setting milestones & deadlines
  • Setting lag and lead time
  • Entering & assigning resources
  • How to resolve overallocated resources
  • Setting the baseline & interim plans
  • Tracking and updating the project

Advanced Microsoft Project

  • Understanding the critical path in MS Project
  • Correctly applying task constraints
  • Creating individual task calendars
  • Working with multiple pay rates
  • Applying custom calendars& work times
  • Entering material resource consumption rates
  • Interrupting work & rescheduling tasks
  • Setting up recurring tasks
  • Working with resource availability
  • Leveling overallocated resources
  • Grouping data by custom selection
  • Applying & working with a budget in MS Project
  • Creating detailed visual reports in Excel

We can deliver both courses in MS Project 2003, 2007 & 2010 versions.  You can see what our clients have to say about our training on the testimonials page.

For more information about Microsoft Project training courses in Leeds or indeed at your offices anywhere in the UK, please call free on 0800 2922842 or email

Microsoft Excel 2010 Sparklines Tutorial

Sparklines are one of a number of features which are new to Excel 2010. Essentially they are small single-cell graphs and represent a great new way to visually interpret data. In the following tutorial we will take a simple step-by-step approach to creating a sparkline:

Creating Sparklines

  1. First download and open the spreadsheet Clothing Sales.
  2. Next activate the Insert tab on the Ribbon and click the Line tool in the Sparklines group.
  3. Now, with the cursor in the Data Range field, click and drag to select the cell range B6:E6.
  4. Next tab to the Location Range Field and click in cell F6.
  5. Now click OK and the Sparkline will be inserted into cell F6.
  6. To change between Line, Column & Win / Loss graph types, just click the appropriate tool in the Type group.

Microsoft Excel Training Courses.

Sparklines can be placed anywhere within the spreadsheet, and do not have to be on the same row or in the same column. In this way, Sparklines can be grouped together to show changes in a wide range of data at a glance

Copying Sparklines
Sparklines behave like any other formula in that they can be copied down a column or across a row to chart multiple data ranges. Just create your first Sparkline, then click the AutoFill handle (the small black square situated in the bottom right hand corner of each cell) and drag down a column or across a row. Additional Sparklines will automatically be created which will represent data ranges in relevant rows or columns.

Customising Sparklines
The default setting tends to produce Sparklines which can be somewhat lacking in detail and clarity. The Show group of tools contains a number of  options which produce highlight points on the Sparkline graph:

  • First Point
  • Last Point
  • High Point
  • Low Point
  • Negative Points

The Style gallery contains a number of pre-set designs for each Sparkline type. Sparklines can also be customised using the Sparkline Colour & Marker Colour options.

As a final note, Sparklines are by definition small, which can sometimes be a problem.  It’s worth remembering therefore that they can be made larger and thereby easier to view by increasing both column width and row depth.

Microsoft Excel Training Courses Manchester

Microsoft Excel Training Courses in Manchester.We have the following public open Microsoft Excel training courses in Manchester at Foundation, Intermediate & Advanced levels:

Microsoft Excel 2007 Level 1
Friday 3 June 2011

Microsoft Excel 2007 Level 2
Monday 6 June 2011

Microsoft Excel 2007 Level3
Friday 13 May 2011

Microsoft Excel 2010 Level 1
Tuesday 19 April 2011

Microsoft Excel 2010 Level 2
Friday 27 May 2011

Microsoft Excel 2010 Level 3
Wednesday 22 June 2011

For full details of our public open Microsoft Excel training courses in Manchester please email or call us free on 0800 2922842. We can also deliver Microsoft Excel training onsite at your own offices anywhere within the UK from just £400 per delegate group. Please contact us for more details.

Microsoft Exchange Server 2010 Training Course Manchester

Microsoft Exchange Server Training Courses.We have a Microsoft Exchange Server 2010 training course in Manchester running on 16/05/2011.  This is a comprehensive 5 day course which covers the following topics in detail:

  • Installation & deployment of Exchange Server 2010.
  • Configuring Mailbox servers & components.
  • Configuring Client Access server role in Exchange Server 2010
  • Configuring message transport
  • Configuring Exchange Server permissions and security for internal and external access
  • Monitoring & maintaining the messaging system
  • Configure the Unified Messaging Server role and Unified Messaging components.
  • Managing the transition of Exchange Server 2003 or Exchange Server 2007 to Exchange Server 2010
  • Planning & implementing disaster recovery solutions

Delegates for this course should have an understanding of networking technologies, including Domain Name System (DNS) and firewall technologies. Experience with Microsoft® Windows Server 2003 and Microsoft Windows Server 2008 operating systems is also required.

To book a place on this Microsoft Exchange Server 2010 training course in Manchester please call 0800 2922842 or email