Due to our expanding client base we are looking for freelance trainers in all regions throughout the UK. Suitable associates will have industry experience as well as a training / teaching qualification. Relevant technical qualifications and / or certification are also required. We are looking for trainers to deliver 1 day courses on the following applications:
- Microsoft Office: including Access, Excel, Outlook, PowerPoint, Project, Publisher, Visio & Word
We are looking for freelance trainers to cover all regions of the UK including England, Ireland, Scotland & Wales.
If you are interested in joining our growing team of associate trainers, please email firstname.lastname@example.org and include your current CV.
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.
Throughout August we are offering a £50 discount on all Microsoft 1 day training courses. This offer includes Microsoft Access, Excel, PowerPoint, Project, Publisher & Word. We have a few days left but availability is going fast. Contact us now on 0800 2922842 or email email@example.com to book your discounted Microsoft training course.
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 firstname.lastname@example.org
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 email@example.com or telephone 07833 543272 for more details.
2009 has been a difficult year for many and training is often one of the first casualties when budgets are tight. With this in mind we will be making training more affordable in the New Year by offering all our IT courses at half price throughout January. This offer includes all the Microsoft Office applications including Project, Excel, Word, Access and PowerPoint as well as our popular Email Marketing and Search Engine Optimisation programmes.
Please email me directly on firstname.lastname@example.org or phone 07833 543272 for a no-obligation quote. I would like to wish all our clients a very happy and prosperous New Year and look forward to being of service to you in 2010.
In response to a growing number of clients’ needs, we have updated our Advanced MS Project course to include further training on issues such as resolving over allocation, resource levelling, applying budgets, grouping data and producing detailed visual reports in Excel. For more details please visit the website at https://www.pbatraining.co.uk/computer-training-courses.html or phone 07833 543272
Project managers, here is an excellent opportunity to learn how to use the powerful Microsoft Project application. More and more project managers are realising that they can save time and get the job done more efficiently using this industry standard software. MS Project 1 day courses frequently cost £300 or more; we are currently offering expert tuition for just £125 including lunch and all day refreshments. For more details please the visit the Microsoft Project Training section of our website. Alternatively email email@example.com or phone 07833 543272.
We have scheduled an Advanced Microsft Word course for Tuesday 8 December 09. During this 1 day practical workshop you will learn how to properly structure a document using styles and levels, how to build a table of contents and index, how to insert bookmarks and cross references, how to create editable forms amd also how to save time with macros. Course fee is £125 including lunch and all day refeshments. For more details please visit the Microsoft Project Training page on our website. Alternatively email firstname.lastname@example.org or phone 07833 543272.
We are running a 1 day Foundation Excel course on Friday 4th December 09 in Scunthorpe, North Lincolnshire. There are still a couple of places available, email email@example.com or phone 07833 543272 to reserve your place.