This video demonstrates how to perform fuzzy or partial match lookups in Excel. There are two scenarios where you might need to use a partial match: When the lookup value is partial When the lookup table contains partial strings. The video covers both scenarios. In Office 365 we can use XLOOKUP and…
Read MoreMonth: September 2020
MS Project Training Yorkshire | Live Online
Project Training | Live Online | Virtual Classroom
Private in-house training - all delegates on the course are from the same company
Publicly scheduled courses - join a course open to the public
Established in 2005, Blue Pecan provides live online Microsoft Project training courses in a virtual classroom. The training can be delivered as private in-house courses or we have a range of scheduled courses open to the public.
Live Online Courses - Microsoft Project courses can be delivered online with a live tutor via Zoom, Microsoft Teams or Webex video conferencing software.
Closed, Private MS Project Training for Businesses
If you are a business enquiring about private, tailored Microsoft Project training for your staff, please see our MS Project remote training information page which will explain all you need to know about our virtual MS Project classroom.
Open, Scheduled MS Project Courses for Individuals
If you are an individual looking to join a remote scheduled MS Project course, please see our scheduled MS Project training page here.
We offer online Microsoft Project training to businesses and individuals across Yorkshire including Leeds, Sheffield, Bradford, Kingston upon Hull, York, Huddersfield, Middlesbrough, Doncaster, Rotherham, Halifax, Barnsley, Wakefield, Harrogate, Keighley, Dewsbury, Scarborough, Batley, Castleford and Redcar.
Our Microsoft Project training course is compatible with Project 2016, 2013, 2010, & 2007.
Pricing
Publicly scheduled courses
From £175 inc vat – price per person / delegate per day course
In-house training prices
Half-day session: 09:30 to 16:00 or 13:00 to 16:00 or to suit
Full-day session: 09:30 to 16:00 or to suit
| No. of Delegates | Onsite Full-day | Online Per Hour | Online Half-day | Online Full-day |
|---|---|---|---|---|
| 1 | £360 | £85 | £195 | £350 |
| 2 - 4 | £495 | £150 | £295 | £485 |
| 5 - 8 | £595 | £175 | £450 | £575 |
| 9 - 10 | £650 | £200 | £495 | £625 |
| Additional delegates | +£20 | +£5 | +£10 | +£15 |
All prices are excluding VAT.
Onsite training travel expenses included for Sussex, Surrey, Hampshire, Berkshire, Buckinghamshire, Kent, Oxfordshire, London and most Essex, Dorset, Wiltshire, Somerset and Hertfordshire locations. Please enquire.
Project Course Outline
Our one day Microsoft Project training course gives you a great overview of this popular project management software. The course aims to give delegates the knowledge needed to set and and link tasks; assign resources to tasks; set baselines and track progress and then create useful reports and outputs based on the values that have been gathered. Download our Microsoft Project outline in pdf format here.
Customising the Project Interface
- Customising the Quick Access Toolbar
- Customising the Ribbon
- Exporting/importing your customisations
Configuring Your Project
- Setting the project start date
- Setting up working times for the project
- Adding bank holidays and other shut-down periods
- Saving customisations to the global template
- Auto scheduling vs Manual scheduling tasks
Entering Tasks
- Task durations
- Setting the default unit for durations
- Deleting tasks
- Inserting tasks
- Moving tasks
- Creating milestone tasks
Linking Tasks
- Creating links using the predecessors column
- Creating links using the Task Information dialogue box
- Creating links using the “link tasks” button
- Dragging and dropping links in the Gantt chart
- Relationship types
- Finish to start relationships
- Start to start relationships
- Finish to finish relationships
- Start to finish relationships
- Applying lag and lead to task relationships
- Task Path Highlighter
Task Constraints
- Constraint types
- Understanding the Planning Wizard in relation to constraints
Subtasks
- Indenting tasks to create subtasks
- Collapsing and Expanding Summary Tasks
- Outline numbering
- Work Breakdown Structure
- The Project Summary Task
The Critical Path
- Formatting your Gantt chart to show the critical path
- Understanding the critical path
Navigation
- Using the “Go to” dialogue box
- Scroll to task
- Zoom options
- Formatting the Gantt chart timescale
Resources
- Resource types
- Work resources
- Material resources
- Cost resources
- Understanding the resource sheet columns – material, max units, rate, accrue at, base calendar
- Editing resource calendars – adding holidays, customising work times
- Assigning resources to tasks
- Understanding the “Work” value
- Levelling resources
- Budget resources
Setting a baseline
- How to set a baseline
- Viewing the baseline in the Tracking Gantt
- Viewing baseline values in tables
Tracking Progress on Your Project
- Marking a task as on track
- Moving incomplete parts of a task to a new date
- Updating task start and finish dates as well as percentage complete
- Setting a Status Date
- Tracking progress in the Resource Usage view
More on Project
- Hyperlinking to supporting documents
- Using text styles format your task list
- Formatting the Gantt chart with bar styles
- Formatting Gantt chart gridlines
- Sorting the task list
- Filtering data in different Project view
- Grouping data
- Creating reports
- Printing the Gantt chart
- Sharing resources across multiple projects
- Combing multiple projects into one Gantt chart
MS Project Training Worcestershire | Live Online
Project Training | Live Online | Virtual Classroom
Private in-house training - all delegates on the course are from the same company
Publicly scheduled courses - join a course open to the public
Established in 2005, Blue Pecan provides live online Microsoft Project training courses in a virtual classroom. The training can be delivered as private in-house courses or we have a range of scheduled courses open to the public.
Live Online Courses - Microsoft Project courses can be delivered online with a live tutor via Zoom, Microsoft Teams or Webex video conferencing software.
Closed, Private MS Project Training for Businesses
If you are a business enquiring about private, tailored Microsoft Project training for your staff, please see our MS Project remote training information page which will explain all you need to know about our virtual MS Project classroom.
Open, Scheduled MS Project Courses for Individuals
If you are an individual looking to join a remote scheduled MS Project course, please see our scheduled MS Project training page here.
We offer online Microsoft Project training to businesses and individuals across Worcestershire including Worcester, Redditch, Kidderminster, Malvern, Bromsgrove, Evesham, Droitwich, Stourport-on-Severn, Catshill, Bewdley & Pershore.
Our Microsoft Project training course is compatible with Project 2016, 2013, 2010, & 2007.
Pricing
Publicly scheduled courses
From £175 inc vat – price per person / delegate per day course
In-house training prices
Half-day session: 09:30 to 16:00 or 13:00 to 16:00 or to suit
Full-day session: 09:30 to 16:00 or to suit
| No. of Delegates | Onsite Full-day | Online Per Hour | Online Half-day | Online Full-day |
|---|---|---|---|---|
| 1 | £360 | £85 | £195 | £350 |
| 2 - 4 | £495 | £150 | £295 | £485 |
| 5 - 8 | £595 | £175 | £450 | £575 |
| 9 - 10 | £650 | £200 | £495 | £625 |
| Additional delegates | +£20 | +£5 | +£10 | +£15 |
All prices are excluding VAT.
Onsite training travel expenses included for Sussex, Surrey, Hampshire, Berkshire, Buckinghamshire, Kent, Oxfordshire, London and most Essex, Dorset, Wiltshire, Somerset and Hertfordshire locations. Please enquire.
Project Course Outline
Our one day Microsoft Project training course gives you a great overview of this popular project management software. The course aims to give delegates the knowledge needed to set and and link tasks; assign resources to tasks; set baselines and track progress and then create useful reports and outputs based on the values that have been gathered. Download our Microsoft Project outline in pdf format here.
Customising the Project Interface
- Customising the Quick Access Toolbar
- Customising the Ribbon
- Exporting/importing your customisations
Configuring Your Project
- Setting the project start date
- Setting up working times for the project
- Adding bank holidays and other shut-down periods
- Saving customisations to the global template
- Auto scheduling vs Manual scheduling tasks
Entering Tasks
- Task durations
- Setting the default unit for durations
- Deleting tasks
- Inserting tasks
- Moving tasks
- Creating milestone tasks
Linking Tasks
- Creating links using the predecessors column
- Creating links using the Task Information dialogue box
- Creating links using the “link tasks” button
- Dragging and dropping links in the Gantt chart
- Relationship types
- Finish to start relationships
- Start to start relationships
- Finish to finish relationships
- Start to finish relationships
- Applying lag and lead to task relationships
- Task Path Highlighter
Task Constraints
- Constraint types
- Understanding the Planning Wizard in relation to constraints
Subtasks
- Indenting tasks to create subtasks
- Collapsing and Expanding Summary Tasks
- Outline numbering
- Work Breakdown Structure
- The Project Summary Task
The Critical Path
- Formatting your Gantt chart to show the critical path
- Understanding the critical path
Navigation
- Using the “Go to” dialogue box
- Scroll to task
- Zoom options
- Formatting the Gantt chart timescale
Resources
- Resource types
- Work resources
- Material resources
- Cost resources
- Understanding the resource sheet columns – material, max units, rate, accrue at, base calendar
- Editing resource calendars – adding holidays, customising work times
- Assigning resources to tasks
- Understanding the “Work” value
- Levelling resources
- Budget resources
Setting a baseline
- How to set a baseline
- Viewing the baseline in the Tracking Gantt
- Viewing baseline values in tables
Tracking Progress on Your Project
- Marking a task as on track
- Moving incomplete parts of a task to a new date
- Updating task start and finish dates as well as percentage complete
- Setting a Status Date
- Tracking progress in the Resource Usage view
More on Project
- Hyperlinking to supporting documents
- Using text styles format your task list
- Formatting the Gantt chart with bar styles
- Formatting Gantt chart gridlines
- Sorting the task list
- Filtering data in different Project view
- Grouping data
- Creating reports
- Printing the Gantt chart
- Sharing resources across multiple projects
- Combing multiple projects into one Gantt chart