We are running Microsoft Excel Training Course in Cheshire including Chester, Crewe, Nantwich, Sandbach, Warrington & Widnes throughout June and July. Increasing your staff’s knowledge on Excel can make a big difference to productivity and our Foundation, Intermediate & Advanced training courses will give them approved, structured learning. For more details about our 1 day on-site Microsoft Excel courses please call freefone 0800 2922842 or email info@pbatraining.co.uk.
Author: Paul
Microsoft Project Courses Derbyshire
Throughout June we are booking Foundation & Advanced Microsoft Project training courses in Derbyshire including Alfreton, Bakewell, Buxton, Chesterfield, Matlock & Ripley. We are specialists in on-site IT training and are qualified to deliver Microsoft Project training at your offices anywhere in the UK. Our daily rates are very competitive and we do not charge travelling or other hidden expenses.
Microsoft Foundation & Advanced Project Daily Rates
- 1-3 people £400
- 4-6 people £450
- 7-10 people £500
The Foundation Microsoft Project syllabus includes the following areas:
- 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 training includes:
- 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
For more information about any these or any of our IT courses, please call freefone 0800 2922842 or email info@pbatraining.co.uk
Microsoft Project Training Yorkshire
We are currently taking bookings for on-site Microsoft Project training courses in Yorkshire including Barnsley, Bradford, Dewsbury, Doncaster, Goole, Harrogate, Halifax, Leeds, Sheffield, York & throughout the region. Microsoft Project training starts at Foundation level, ideal for those new to the application or for existing users who would benefit from a structured course to ‘fill in the gaps’. We also deliver MS Project at Intermediate & Advanced levels for more experienced users wishing to get the most out of the software. For more details call freefone 0800 2922842 or email info@pbatraining.co.uk
Microsoft Project Training East Sussex
June sees us delivering more on-site Foundation & Advanced Microsoft Project training courses in East Sussex including Brighton, Crowborough, Eastbourne, Hastings, Lewes & Newhaven. For details of each course syllabus please visit our training courses page. For more details call free on 0800 2922842 or email info@pbatraining.co.uk
Microsoft Project Training Buckinghamshire
We are running Microsoft Project Training Courses in Buckinghamshire including Aylesbury, Bletchley, Buckingham, High Wycombe, Milton Keynes, Newport Pagnell, Wendover & Winslow. Microsoft Project has become the industry standard application for Project management and we are qualified to deliver all levels from Foundation through to Advanced. Please email info@pbatraining.co.uk or call freefone 0800 2922842 for more details about MS Project training courses.
Microsoft Word Training Courses Surrey
We are delivering Foundation & Advanced Microsoft Word Training Courses in Surrey throughout 2010 including Byfleet, Crowhurst, Godalming, Guildford, Horley, Leatherhead, Redhill, Reigate & Weybridge.
The Foundation course is ideal for those who have little or no previous experience of using Microsoft Word and includes the following topics:
- Introduction to word processing.
- Overview of Microsoft Word’s menus & toolbars.
- Entering & formatting text.
- Saving & printing MS Word documents.
View the full Foundation Microsoft Word course content…
The Advanced course will suit experienced users who wish to become more profficient and effective at laying out professional-looking documents and includes the following topics:
- Creating & applying styles.
- Structuring a document with Levels.
- Creating a table of contents.
- How to create protected forms.
- Importing and editing photos & graphics.
View the full Advanced Microsoft Word course content…
For more information about our Microsoft Word training courses email info@pbatraining.co.uk or call us free on 0800 2922842.
Microsoft Excel Training Berkshire
We are currently delivering Microsoft Excel Training Courses in Berkshire including Basildon, Bracknell, Reading, Slough, Wickham & Wokingham. We are specialists in on-site training and qualified to deliver Excel at Foundation, Intermediate & Advanced levels. For an overview of our Excel course content please visit the training courses page at our website. For more information email info@pbatraining.co.uk or call us free on 0800 2922842.
Constructing Simple Formulas in Microsoft Excel
Formulas in Excel perform calculations such as addition, subtraction and multiplication. They use the familiar arithmetic operators (+, – etc) however, formulas in Excel always begin with an equals sign (=).
Arithmetic Operators in Excel
+ Addition
– Subtraction
* Multiplication
/ Division
% Percent
Formula Construction
An example of a formula in Excel might be =2+2, which of course will return the answer 4. However, this would be a very restricted formula as it only returns one possible value. In practice, when we input formulas into an Excel spreadsheet we substitute raw data for cell references.
So an example formula might be =A1+B1. If the values in A1 and B1 are both 2 then the formula will return the answer 4 as before. However, we can now change the values in cells A1 and B1 and get different results without having to edit the formula.
As a general rule, we should try never to insert raw data into Excel formulas; it is almost always better to reference cells instead.
Here are some examples of Excel formulas:
- Subtract B1 from A1: =A1-B1
- Multiply A1 and B1: =A1*B1
- Divide A1 and B1: = A1/B1
Editing Formulas
Formulas can be edited in the cell by double-clicking with the mouse. They can also be edited in the formula bar by selecting the cell, then clicking inside the formula bar.
Combining Arithmetic Operators
If we wish to combine operators in the same formula it is sometimes necessary to separate them with brackets. this is especially true if we mix multiple & divide with addition and subtraction. This is because the operators of multiply and divide take precedence. Consider the following example:
We wish to add A1 and B1 then multiply the result by 20%. If we enter =A1+B1*20% we get the result 2.4. But this is incorrect, we should get 0.8.
The reason we don’t is that because multiplication takes precedence over addition, Excel will first multiply B1 by 20% and then add A1 to the product. In order to add A1+B1 first we need to wrap them in brackets, so our formula becomes =(A1+B1)*20%. This gives the correct result of 0.8.
Self-Test Exercise
- First enter the data shown into cells A1 and B1.
- Next add, subtract, multiply & divide the data in separate cells in column C.
- Finally, in C5 add the data and calculate 10% of the product.
Attending a Microsoft Excel Training Course
Our 1 day Foundation Microsoft Excel course covers formulas and many other essential skills. It is suitable for people with no previous experience of using Excel and also those self-taught users who would benefit from a structured training course to ‘fill in the gaps’ and extend their working knowledge of the application. We run onsite Microsoft Excel training courses throughout the UK, please call free on 0800 2922842 to discuss your IT training needs. Alternatively you can email us on info@pbatraining.co.uk.
2 Ways That Advanced Word Training Can Save You Money
Throughout 2009 our most popular courses have been Advanced Microsoft Excel, with Microsoft Project following a close second. Advanced Word is quite a way down the list and Foundation Word courses are near the bottom. Part of the reason for this is that Microsoft have done a pretty good job of making Microsoft Word very easy to use at a basic level and many people feel confident in their ability to teach themselves. However, there is a fundamental problem here best summed up by the old adage:“you don’t know what you don’t know.” In other words, you cannot teach yourself about features which you don’t know exist!
This is a pity as it means that many people are not getting the most out of the software for which they have invested a considerable amount of money. Many of the little know features can save considerable time on tasks, precisely the areas we should be learning about in order to be most productive.
What features am I referring to? Well, few people are really taking advantage of styles, which is one of the most powerful Microsoft Word tools you can use. A style is essentially a collection of formatting attributes which are named and saved. Styles have been around since the earliest incarnations of Word, but Microsoft Word 2007 really pushes the boat out with a large gallery of pre-defined styles on the ‘home’ ribbon. The big advantage to using styles over simple text formatting is the facility to modify them and in so doing, automatically update every instance where it has been used throughout the document.
Another underused feature of Microsoft Word is the Level. Levels give a document structure which can be used to drive other tools such as the Table of Contents generator. This feature alone saves me countless hours when writing training courses, yet few people take advantage of it.
These features and many more are covered in our 1 day Advanced Word training course. If you would like more information please call 07833 543272 or email paul@pbatraining.co.uk
Laptops Now Provided for Onsite Computer Training
We are pleased to announce that we are now able to provide laptops for onsite computer training. For a daily onsite rate of £400 we can and train up to 10 employees in any suitable sized office. This includes all the Microsoft Office suite of applications including Access, Excel, Project & Word. Email info@pbatraining.co.uk or telephone 07833 543272 for more details.