Prince2 Conversion Training Courses
Leeds – 26/05/2011: was £595 now £545
Chester – 26/05/2011: was £595 now £545
There are only a few places left on these Prince2 Conversion training courses – email firstname.lastname@example.org or call 0800 2922842 to book you place now.
Configuring & Troubleshooting Windows Server 2008 Active Directory Domain (M/S 6425)
13th June & 4th July 2011 Manchester – 5 days: was £600 now £525
Installing & Configuring Windows 7 Client (M/S 6292)
31st May 2011 – Liverpool 3 days: was £395 now £345
8th August 2011 – Manchester 3 days: was £395 now £345
Configuring & Managing Microsoft SharePoint 2010 (M/S 10174)
20th June 2011 – Liverpool 5 days: was £600 now £525
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 email@example.com
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 firstname.lastname@example.org 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 email@example.com.
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:
- Select the Insert tab on the Ribbon then click the PivotTable button and choose PivotChart.
- 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)
- Now choose the required fields in the Field List to create your PivotTable & Chart.
- Finally cut and past the PivotChart into a new worksheet. This will form the basis of our ‘Dashboard’.
- 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:
- Click inside the PivotChart and the PivotChart Tools group will appear on the Ribbon.
- Next select the Analyze tab and click the Field Buttons menu.
- 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:
- First click inside a PivotChart and then select the Insert Slicer button menu. Choose Insert Slicer from drop-down the menu.
- You will be presented with a dialogue box containing a list of PivotTable fields.
- 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:
- 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.
- Next select from available PivotTables those that you wish to connect to the Slicer.
- 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:
- To change you PivotTable colour, first select the Design tab in the PivotChart tools group.
- You can now select from a range of chart colours in the PivotChart styles gallery.
- To change Slicer colours, first click a slicer then select the Options / Slicer Tools tab on the Ribbon.
- A corresponding colour can now be selected from the Slicer Styles gallery.
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 firstname.lastname@example.org or call free on 0800 2922842.
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 £280 + VAT per delegate, here are our onsite training daily rates:
- 1 – 3 learners: £450
- 4 – 6 learners: £500
- 7 – 10 learners: £550
Please note that these rates are per group and not per person. Therefore for a group of 10 delegates the cost is just £55 per person. 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 email@example.com
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:
- 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.
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
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.
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.
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 firstname.lastname@example.org 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.