Paul Brown Associates Training Consultants Blog » 2011

Archive for March, 2011

Published by admin on 27 Mar 2011

Microsoft Project Training Courses Leeds West Yorkshire

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 £200 per delegate, here are our onsite training daily rates:

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

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 info@pbatraining.co.uk

Microsoft Project Courses

Published by admin on 26 Mar 2011

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

First download and open the spreadsheet Clothing Sales.
Next activate the Insert tab on the Ribbon and click the Line tool in the Sparklines group.
Now, with the cursor in the Data Range field, click and drag to select the cell range B6:E6.
Next tab to the Location Range Field and click in cell F6.
Now click OK and the Sparkline will be inserted into cell F6.
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 Office Tutorials

Published by admin on 16 Mar 2011

Microsoft Excel Training Courses 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 info@pbatraining.co.uk 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 Excel Courses

Published by admin on 06 Mar 2011

Microsoft Exchange Server 2010 Training Course Manchester

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 info@pbatraining.co.uk.

Microsoft Exchange Server

Training Newsletter

Discount offers and latest course info straight to your email
Name:

Email:
Contents
What Our Clients Say

"A big thank-you for the Microsoft Excel and Word courses you recently delivered to a group of Managers studying for a degree in World Class Manufacturing. Initially this course was planned for two sessions however your enthusiasm, knowledge and teaching style resulted in a unanimous decision to invite you back for a third session.

I would not hesitate in recommending your services and on behalf of the group, thank you for raising our competence levels in Microsoft Excel and Word."
Steven Smith
Shift Manager
Corus UK

“Paul, thank you so much for the recent MS Project training courses that you delivered to The Danwood Group Ltd. The feedback from my colleagues has been truly superb; in their own words: “…enthusiastic, knowledgeable, professional, friendly, adaptable, helpful, the best trainer...”! Wow, praise indeed.

Initially, I’d researched fairly extensively for an MS Project training provider. And, right from our first meeting I knew I’d found exactly what I was looking for. The quality of your training, as well as your ability to so easily accommodate a wide range of experience in a single course, speaks volumes – even those with considerable previous knowledge learnt a huge amount.

All the course delegates, beginner and experienced alike, are now fully confident with MS Project and eager to put their new found skills to best use. I’m delighted at the outcome, and would unreservedly recommend you for MS Project training. Thank you, Paul."
Andy Cleminson
Project Manager
The Danwood Group Ltd

"Paul delivered several Microsoft Excel one day training courses, at varying levels to a variety of our personnel ranging from operational firefighters to office based staff.

The feedback from those attending the courses was extremely positive. All delegates greatly enjoyed the sessions and felt that they had gained much from their attendance. They also felt that the delivery of the training was matched to their needs and that the manner and level of instruction encouraged them to take part and fully enjoy the session."
Leslie Butcher
L & D Co-Ordinator
Humberside Fire & Rescue

"Thank you for the Intermediate / Advanced Excel courses that you carried out on-site at E.ON UK. The training was for a group of 4 and was delivered friendly and efficiently, well organised and very well adapted to each individual needs.

I would certainly recommend Paul Brown Associates to anyone wanting Microsoft training and will be using you again in the not too distance future."
Sally Brown
Plant Co-Ordinator
Killingholme Power Station
E.ON UK

"I would recommend Paul Brown Associates to anyone who needs outstanding IT and soft skills training. They have made business software training a great success at Kingsway Consulting. I have had personal feedback from many of our clients and all express a high level of satisfaction.

Paul has a unique style which enables him to communicate technical content in a manner which everyone can understand and enjoy. He clearly enjoys his work and it's Paul's enthusiasm and passion which drives this style.

In my experience, a high level of IT knowledge and excellent personal and communication skills don't often go hand in hand. Paul manages to combine both of these to considerable effect, making him a valuable training asset."
Colin Guthrie
Senior Business Manager
Kingsway Consulting Ltd

"Paul carried out an Intermediate Excel course on site at Entre-Prises UK for a group of 10 people at varying ability levels. He delivered the training course at a speed that suited all of the individuals involved. He was very friendly and the course ran very smoothly, all of the staff involved gained a significant amount from the course. I would not hesitate to contact Paul in the future with regards to any further training requirements".
Diane Foxton
HR Manager
Entre-Prises (UK) Ltd

“Thank you for recently providing an Excel Intermediate one-day training course at Renaissance Southend. I have had extremely good feedback from the members of staff who attended the training, and they were particularly pleased with how much was covered and the structure of the training. We had different levels of expertise in the group but we thought you reacted well to judging what level we were all comfortable with and even our most experienced user went away with a lot of new knowledge. We all felt we gained a substantial amount from the training and we look forward to putting our new skills to use.

Personally, I found Paul to have a professional yet friendly approach that created a nice learning environment for the day, and where people felt happy to ask questions if they were unsure at any point. Arranging the training was also very easy and hassle-free and the equipment he supplied was of a high quality. I feel a lot more confident in my Excel skills now and without hesitation would recommend Paul Brown Associates to colleagues or other organisations we deal with.”
Laura Cowell
Programme Team Assistant
Renaissance Southend

"The course has been of a high quality dealing with the practical use of differing techniques and complex formula used to streamline and work more intelligently on a daily basis. The trainer was knowledgeable, personable and enthusiastic and demonstrated the rare ability to meet the needs of delegates with differing levels of need and differing expectation.

I can unreservedly recommend Paul from PBA Training to others wishing to improve any aspect of the Microsoft Office software family."
Ros Bayley
Branch Manager, Reigate
OAMPS Insurance Brokers
Categories
Archives

visit our website www.pbatraining.co.uk

Archive for March, 2011

Microsoft Project Training Courses Leeds West Yorkshire

Foundation Microsoft Project

Advanced Microsoft Project

Microsoft Excel 2010 Sparklines Tutorial

Microsoft Excel Training Courses Manchester

Microsoft Exchange Server 2010 Training Course Manchester

Training Newsletter

Contents

What Our Clients Say

Categories

Archives