Every wondered why Pivot Tables are such a powerful feature of Microsoft Excel or how quickly pivot tables and Pivot Charts can make your data come alive? If so you much watch this video. In it John Michaloudis shows some fantastic techniques for using pivot tables to see data coming to life. In just 3 minutes he creates a number of pivot table charts for a mass of sales data. It is a joy to watch and you may want to grab a pen to make notes as he goes through tons of content in his 3 minute challenge. Watch this [More]
This useful video shows how to use a graphical representation of data in a single cell through the use of Sparklines. I think Sparklines are one of the exciting and cool charting features introduced in Excel 2010. Sparklines allow you to view and analyze data without creating an entire chart. You can quickly and easily spot trends at a glance and add rich visualization capability to tabular data without taking up too much space. We choose this video as it shows how you can create and customize sparklines and how you can highlight certain points like:- High and low points, Negative [More]
Click here to Download the spreadsheet used in this presentation Create an Excel Chart Budget vs Actuals chart using the clear instructions in this video the Queen of Excel Charts Mynda Tracey. The video is divided into two parts – the first showing how to create a Excel Chart Budget vs Actuals chart in Excel 2007/2010 and the second part (starting at around 8 mins) shows how to create the same graph in Excel 2013. The video shows some cool tricks along the way to creating the Excel Chart Budget vs Actuals chart – Including how to cut and paste [More]
Excel 2013 has a neat hidden feature in it that allows you to do some really quick analysis of data and this video walks you through all the options available in the Excel 2013 Quick Analysis feature. I have been using Excel 2013 for about 6 months now and I did not even know about this feature – shame on me! I always love it when Mynda Treacy releases one of her videos for free viewing and this one is no exception. I am a big fan of her work at My Online Training and have taken her Excel Dashboard course in [More]
I hope you enjoy this video – if you are inspired to create better charts then you should check out our recommended Excel Dashboard Course Excel Dashboard course that is currently open for registration again. A funnel chart is often used to show how a process generates results. the most common use for a Funnel Chart would be to show how users convert on your website, from visitors to leads to sales. This video clearly shows how to create a funnel chart in the first 4 minutes but what I really like about this example is it shows you just how configurable [More]
We love the videos produced by MyOnlineTrainingHub as they are always really clear and easy to follow. This one shows an advance charting method to show Quintile Charts for a real life case study of English Schools. If you are not sure what a Quintile chart is (like us before we watched the video) then the easiest way to find out is to simply watch the video.
This great video shows you how to liven up a chart within your Excel worksheet by adding an image in the background of the chart. It is amazing what a difference adding an image to the back of a chart can make. One minute a boring bar chart the next minute it looks very professional. You do have to watch out for images that clash with your charts – you want the viewer to focus on the data not the image at the end of the day.
Speedometer charts are a great way to add style to an Executive report or dashboard in Excel. There is no direct option to create speedometer charts in Excel but with a few clever tricks you can create all sorts of effects with Excel charts. This video shows several of these tricks and as you will see the outcome is quite simple but at the same time very clever. This Video is for Excel 2010 only.