We are now offering Prince2 Training Courses in Essex including Basildon, Billericay, Braintree, Chelmsford, Colchester, Harlow, Hockley, Rochford and throughout the County. As leading UK specialists in onsite training we can deliver Prince2 Foundation through to Advanced Practioner levels at your own offices, or arrange a convenient local venue.
For more information please call on freefone 0800 2922842 or email email@example.com
We are pleased to announce that we are now able to offer accredited online Prince2 training course for just £75 (excluding examination fees). Online training is available for Prince2 Foundation up to Prince2 Advanced Practitioner and subsequent exams can be taken at a centre local to you. For more information please email firstname.lastname@example.org or call free on 0800 2922842.
The IFERROR is a simple but useful function in Excel 2007 and simplifies the old ISERROR function from earlier versions. Essentially, IFERROR provides an easy means to replacing standard Excel error messages with something more ‘user friendly’. Many Excel users will be familiar with errors such as #DIV/O!, but to others these messages can seem ominous and confusing. Using IFERROR we can customise the output message based upon a particular error and present it in a manner that any inexperienced user will be able to understand.
- First download the Excel 2007 spreadsheet Using IFERROR.
- You can see that in column D we have a couple of #DIV/O! errors where the unit price has been entered as zero. Dividing any value by zero will produce this standard error message.
- Now click in cell D4 then select the Formulas tab.
- Click the Logical button and select IFERROR to launch the function wizard.
- In the Value field we need to enter the formula B4/C4 to calculate the number of units sold.
- Next in the Value if Error field, type a text message which will be displayed in place of the normal #DIV/O! Make this something self-explanatory such as “Check Price”.
- Now click OK and finally copy the function down column D.
This is one of the simplest of all Excel functions, but it can make it much easier for a less-skilled user to work with your spreadsheets.
We cover this and many other time-saving topics on our Microsoft Excel 1 day courses. We specialise in on-site training and can deliver Foundation, Intermediate and Advanced levels of Excel at your own offices anywhere in the UK. For more information email email@example.com or call free on 0800 2922842.
Onsite Excel training still seems to be in high demand. We are currently booking Microsoft Excel Training Courses in Shropshire including Bridgnorth, Ellesmere, Market Drayton, Newport, Shrewsbury & Telford. We supply onsite Microsoft Excel training at Foundation, Intermediate & Advanced levels throughout the UK and we will tailor any course to suit you own requirements at no extra cost.
For more information please email firstname.lastname@example.org or call free on 0800 2922842.
We are curently delivering Prince2 training courses in Lancashire including Blackburn, Blackpool, Bolton, Burnley, Bury, Chorley, Colne, Manchester, Oldham, Preston, Rochdale, Salford & Wigan.
As specialists in onsite training, we can deliver accredited Prince2 Foundation through to Advanced Practioner levels at your own offices anywhere in the UK, with prices from just £795.
For more information please email mailto:email@example.com call free on 0800 2922842.
We are currently booking Microsoft Project training courses in Cambridgeshire including Cambridge & Peterborough. We are qualified to deliver Microsoft Project Training from Foundation right through to Advanced levels onsite at your offices anywhere in Cambridgeshire. Our tutors are all fully qualified trainers with many years of industry experience. Our Microsoft Project trainers also have practical project management experience and understand the issues involved in scheduling and tracking complex projects.
We can deliver Microsoft Project courses at Foundation and Advanced levels for the following daily rates:
- 1 -3 learners: £400
- 4 – 6 learners: £450
- 7 – 10 learners: £500
Our rates are fully inclusive and we do not charge extra for travelling expenses. Please note that we are specialists in onsite training and do not offer public open courses. There are several advantages to the onsite approach:
- Course dates can be arranged to suit your availability.
- Course content can be tailored to suit your personal requirements at no extra cost.
- Training can be more cost effective as your employees have no travelling or accommodation expenses.
Our Microsoft Project courses are 1 day in duration and will train you in the correct Microsoft methods of scheduling and tracking. All Microsoft Project trainees receive a personal training reference manual along with a Course Certificate.
For more information about Microsoft Project training courses please email info@pbatraining or call us free on 0800 2922842.
Microsoft Project has been around for some time now and is considered by many to represent the industry standard scheduling tool. In the right hands it can certainly make the task easier and save both time and money by highlighting possible scheduling problems.
Don’t Get into Bad Habits!
However, our experience of delivering MS Project courses from Foundation to Advanced levels has shown that many people who are self taught frequently mis-use the application through no real fault of their own. It is simply that Microsoft Project isn’t the easiest of programs to understand without guidance and the interface can lead the unwary novice into forming ‘bad habits’ which can seriously undermine the true potential of the application. It’s the old adage that “we don’t know what we don’t know!”
The Most Common Problem
Without doubt, the most common ‘bad habit’ that I see amongst self-taught users is in respect of defining tasks. It is often assumed that because the Task Sheet has columns for start and finish dates, these should be defined when a task is entered. It would seem a logical thing to do and certainly looks as if Microsoft Project requires the information. In fact it is in most cases exactly the wrong thing to do, as setting a task finish date will automatically apply a ‘Finish No Earlier Than’ constraint. Constraints come in 3 forms: Flexible, Semi-Flexible and In-Flexible. A ‘Finish No Earlier Than constraint is semi-flexible which removes some of Microsoft Project’s ability to re-schedule and generate alternative scenarios. What we should in fact be doing, is setting only the duration field and initially allowing all tasks to commence on the project start date. When the tasks are later linked together, the start and finish date will automatically take care of themselves. The big difference now is that all tasks have a start ‘As Soon As Possible’ constraint, which is the most flexible option. Here’s how:
Entering Project Tasks
- First click in the Task Name field on the Task Sheet and enter an appropriate name.
- Next click the Tab key and enter an estimated Duration. Use either the spinner buttons, or simply type the appropriate number of days into the field.
Notice how each task has the project date as it’s start date and the finish date is automatically determined by the task duration. You will also see that the Gantt chart starts to build on the right-hand side. The next step is to link the tasks together:
Linking Project Tasks
- First double-click on second task in your list and the Task Information window will open.
- Next click the Predecessors tab, then select the ID field and type a 1. Click Enter.
- You will see that MS Project automatically enters the Task name and also sets a linkage type of Finish-to-Start. This can be edited to reflect each of 4 different task relationships: Finish-to-Start, Start-to-Start, Finish-to-Finish, Start-to-Finish.
- Finally click OK to Exit the task Information window and repeat for each task. Notice how the Gantt chart updates with each new task relationship.
Clearly there is much more to discuss in respect of task relationships and linkage types, but I hope this short tutorial will at least get you started on the right track to using Microsoft Project. For more information about our 1 day Microsoft Project training courses you can email firstname.lastname@example.org or call us free on 0800 2922842.
I would like to say a big thank you to Renaissance in Southend-on-Sea, Essex for a very warm welcome when we delivered an Intermediate Microsoft Excel course at their offices recently. It was a pleasure to meet and work with the team and I’m very happy to hear that everyone found the training to be beneficial. I would like to say particular thanks to Laura Cowell for providing us with such excellent feedback, which can be seen on our Client Testimonials page.
Demand for spreadsheet training remains as high and we are currently taking bookings for Microsoft Excel Training Courses in Kent including Ashford, Canterbury, Gillingham, Maidstone, Tonbridge, Tunbridge Wells, Sevenoaks & Tenterden. We deliver Microsoft Excel at Foundation, Intermediate & Advanced levels onsite throughout the UK and provide all the necessary training equipment, so that all you need is a suitable office.
For more information please email email@example.com or you can call us on freefone 0800 2922842.
We are back running Microsoft Excel training courses in Suffolk including Bury St Edmunds, Felixstowe, Ipswich, Lowestoft, Mildenhall & Newmarket. We are specialists in onsite computer training and are qualified to deliver Microsoft Excel training at your offices anywhere in the UK. You can see what our clients say about us on the testimonials page. You can also see an overview of our Foundation, Intermediate & Advanced Excel Training Courses on our main website.
For more details call free on 0800 2922842. Alternatively you can email us at firstname.lastname@example.org.