visit our website www.pbatraining.co.uk

We are taking bookings for in-house Microsoft Excel training courses in Bedfordshire including Ampthill, Bedford, Biggleswade, Dunstable, Luton & Sandy. Arranging an in-house Microsoft Excel training course at your own offices has a number of benefits:

• Cost is significantly lower if you have 2 or more people.
• Delegates don’t have to travel, saving time and money.
• Courses can be tailored to meet your own Company requirements.

Our rates for onsite Microsoft Excel training are as follows:

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

Our training rates include personal Microsoft Excel training manuals and course completion certificates. All prices are + VAT.

You can see what clients say about our training services on the testimonials page – please feel free to contact any of these for their views. If you would like more information about Microsoft Excel training in Bedfordshire or indeed anywhere throughout the UK, you can call us free on 0800 2922842 or email info@pbatraining.co.uk

We are available to deliver Microsoft Office training courses in East & West Sussex including Brighton, Crawley, Eastbourne, East Grinstead, Hailsham, Hastings, Horsham, Midhurst & Worthing. Our Microsoft Office training includes Access, Excel, OneNote, Outlook, PowerPoint, Project, SharePoint & Word. All courses can be delivered at Foundation, Intermediate & Advanced levels and in versions 2003, 2007 & 2010. Prices for on-site training are as follows:

• 1 – 3 course delegates: £400
• 4 – 6 course delegates: £450
• 7 – 10 course delegates: £500

Our daily rates include personal Microsoft Office training manuals & course certificates. All course prices are + VAT.

We provide all the training equipment required including project & screen so that all you need is a suitable office. Laptops are also available at just £15 / day if required.

You may wish to see what our clients say about the service they have received from us on the testimonials page. For further details about our Microsoft Office training courses please email info@pbatraining.co.uk or call us on freefone 0800 2922842.

We’re back onsite delivering Microsoft Excel Training Courses in Northamptonshire including Brackley, Corby, Daventry, Kettering, Northampton, Oundle & Towcester. Demand for training on Microsoft Excel 2010 is increasing and our new Advanced Excel course include training on Slicers & Sparklines. These new features have got everyone talking and look set to become very popular with users as Excel 2010 gains hold. We can also build training on Slicers & Sparklines into our Intermediate course on request. For an overview of all our Excel courses content, including Office 2010, please visit the Microsoft Excel Training page.

Daily rates for onsite Microsoft Excel training are as follows:

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

Our onsite training rates include personal Microsoft Excel training manuals & course certificates. We provide all necessary training equipment including projector and screen so that all you need is a suitable office. We can also provide laptops for up to 10 learners if required.

For more details about Microsoft Excel Training Courses in Northamptonshire or indeed anywhere in the UK, please call free on 0800 2922842 or email info@pbatraining.co.uk.

Overview
Slicers are the new feature in Excel 2010 which has got everyone talking. Essentially Slicers are a user-friendly filtering system which makes PivotTables & PivotCharts easier to work with and now brings a high level of dashboard capability to Excel.




First Create Your PivotTables
The first step in using Slicers is to create your PivotTables & PivotCharts:

1. Select the Insert tab on the Ribbon then click the PivotTable button and choose PivotChart.
2. Next select the data range and choose to create the PivotTable and PivotChart on a new worksheet (once we have created a dashboard we can hide the PivotTable tabs)
3. Now choose the required fields in the Field List to create your PivotTable & Chart.
4. Finally cut and past the PivotChart into a new worksheet. This will form the basis of our ‘Dashboard’.
5. Repeat the above process as necessary to create further PivotCharts and place them on the dashboard.

Each of the PivotCharts on the dashboard can be individually filtered directly using the Field Buttons. However, the slicers we create next will take over this function and provide a higher level of interactivity between PivotCharts. We can therefore remove the Field Buttons, here’s how:

1. Click inside the PivotChart and the PivotChart Tools group will appear on the Ribbon.
2. Next select the Analyze tab and click the Field Buttons menu.
3. Choose Hide All to remove the Field Buttons on the PivotChart.

Creating the Slicer
The next step is to create slicers to add real functionality to the dashboard:

1. First click inside a PivotChart and then select the Insert Slicer button menu. Choose Insert Slicer from drop-down the menu.
2. You will be presented with a dialogue box containing a list of PivotTable fields.
3. Choose appropriate fields to wish to filter then click OK.

How to Use Slicers
The slicer will be created as a box with a number of buttons which enabling filtering. Clicking an individual button will change the PivotChart accordingly. Multiple selections can be made by holding down the CTRL key. The filter can be removed by either clicking the funnel icon or alternatively dragging across all the buttons to select them all.

Enhancing Slicer Functionality
A major advantage of using Slicers is the ability to filter multiple PivotCharts simultaneously, creating true dashboard functionality. Here’s how to link PivotCharts together:

1. First select a Slicer and right-click in the header area (where the Slicer title appears), then choose PivotTable Connections from the menu. Alternatively you can select the Options tab on the Ribbon and choose PivotTable Connections.
2. Next select from available PivotTables those that you wish to connect to the Slicer.
3. Finally click OK to complete the process.

Creating a Dashboard
We now have the basis for a full dashboard system which enables simultaneous filtering of multiple data fields. Simply set up all your PivotCharts on one spreadsheet tab and create Slicers with multiple connections as necessary. Group your Slicers with the PivotCharts and you will have a user-friendly data filtering system. You may find it advantageous to colour code your charts and slicers to match, so that you can filter data more easily:

1. To change you PivotTable colour, first select the Design tab in the PivotChart tools group.
2. You can now select from a range of chart colours in the PivotChart styles gallery.
3. To change Slicer colours, first click a slicer then select the Options / Slicer Tools tab on the Ribbon.
4. A corresponding colour can now be selected from the Slicer Styles gallery.

Summary
Slicers represent a powerful new filtering tool in Excel 2010 which appears set to transform the way that we use PivotTables and PivotCharts.

This week we are delivering Microsoft Project training at Keele University in Staffordshire. We run onsite MS Project courses for 2003, 2007 & 2010 versions at Foundation, Intermediate & Advanced levels. We provide all the necessary training equipment including projector and screen so that all you need is a suitable office. We can also provide laptops for up to 10 learners if required.

As specialists in onsite training, we can deliver Microsoft Project courses at your own offices anywhere within the UK for the folowing rates:

• 1 – 3 delegates – £400
• 4 – 6 delegates – £450
• 7 – 10 delegates – £500

For more details email info@pbatraining.co.uk or call free on 0800 2922842.