Social Media

FacebookTwitterLinkedIn

Course Feedback

" John was brilliand, really liked his style" Anna PA

Line Break

"Johns' techniques are his strengths. Our most senior management to the super users all enjoyed and learned loads, I would really recommend him" Raj IT Support

Line Break

" So much energy and knowledge, thanks John" Peter HR Manager.

Line Break

"John got on really well with everyone and we all learned so much, I would really recommend him" Raj IT Support

Line Break

" I wish we did this years ago, great work John" Sarah HR Manager

Line Break

I Currently have special offers in July so contact me to discuss your needs.

Line Break

CALL for the latest dates or to book one of these special offers 07939 083648
or 0208 3500736

Feedback

Here is what some of our previous delegates have said!

"Very helpful, kept it at the pace I found it easiest to work through. Brilliant "

White Line Break

"I Should have done this years ago - John made it really easy to understand. I had one to one coaching and now - Dashboards here I come!!!"

White Line Break

"John was really great. Made everyone feel at ease."

White Line Break

"Really enjoyed the course and learned loads. Can't wait to get back to work and try it out."

White Line Break

Dashboards and Pivot Tables Made Easy!

Who is it for?

This Dashboard and Pivot Table training course is ideal if you need to analyse data or create dashboards in Excel. It will have you up to speed in no time and can be run onsite, on a one to one or classroom basis.

  Download the PDF version hereDownload the PDF version here

Learn how to utilise some of the latest functionality in Excel to easily create Pivot Tables and Dashboards. Monitor your Key Performance Indicators (KPIs) with ease and speed. An understanding of how to use Excel formulas and functions is required.

What is it about?

Microsoft have added some really neat functionality to Excel in recent versions which greatly enhance the visualisation of data. Presentation with dashboards has never been easier. This means you can interrogate data and present it in a user friendly manner quicker than ever before. Create stunning dashboards with Charts, Sparklines and Tables. Then make the whole thing interactive!. Learn how to create Pivot Tables and then slice and dice your way through them to find key performance indicators which drive effective decision making.

What will I get out of it?

• Confidence in utilising the latest features of Excel to summarise data.
• Learn how to setup a Dashboard from scratch by adding charts and tables
• Best practice for workbook construction
• Utilise visualisation techniques to display trends, Group Data and show performance against target
• Create and update Pivot Tables and Pivot Charts including finding top and bottom views
• Add the latest functionality to slice and dice your way through the data.
What will I learn?
• Where to start with dashboards
• Structuring your work
• The anatomy of a chart
• Creating and editing various charts types to effectively present the data.
• Beyond charts other visualisation techniques
• Adding linked tables to your dashboard.
• Effective use of Conditional Formatting.
• Creating and updating Pivot Tables and Pivot Charts.
• Master the conditional formatting features to highlight trends in your data.
• Add interactive controls and create a user interface so others can perform analysis
• How to use the latest COUNT functions introduced in Excel 2007 and 2010 to maximum effect

There will be a workshop session at the end (time permitting) to look at specific needs of each delegate if required.

If you are not sure Contact Us to discuss your requirements and get a completely free quote.