Pivot tables is the most powerful feature in Excel.  But what do you do if your data has already been turned into a Pivot table when you get it?  The Answer? use Unpivot – the most hidden feature in Excel! I am really impressed that excel can convert a number of hours of work into seconds thru the use of Unpivot. Unpivot is a feature included in Power Query Excel add in.  Power Query Excel add-in lets you discover, combine and refine data.  And since this is an add-in feature, you may need to enable to use this. Or you [More]
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]
This is probably one of the most comprehensive guides to the options available to protect your spreadsheets from accidental (or deliberate) changes. Once you have spent hours making the perfect spreadsheet you will want to protect the equations from being accidentally overwritten, stop the graphs nudged into the wrong place or the adding of elements you do not want. However you still need areas of the spreadsheet to be open so that users can add data and values. Excel has a number of protection options at object, sheet or workbook area and this video shows you how to navigate around [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 panel charts are usually created by taking more than one area chart and lining them up so they look like one chart. In this video you can see how you can set up one of the panels and then use some pretty cool cut and pasting techniques to line the charts up to start to form a panel chart. Once you have one of the charts set up you will see it is easy to copy and change the necessary details for each panel. There is a very cool top at 4 minutes that shows you just how easy [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]
The more I get into Excel Dashboards the more excited I get.  This is a great video that I hope will give you some ideas and techniques to present lots of data on a number of Excel Charts.  This video is a little longer than the ones I usually post but it is well worth 15 – 20 minutes of your time. The video looks at a large table of sales data from a number of US states.  If you put all the states on a graph at the same time then there is no way you can see any [More]
Almost a year ago I purchased this course for myself to help me make better looking spreadsheets and I have used this course more than any other book or course I have ever purchased. I highly recommend you watch the video below as pause it to look closely at some of the spreadsheet they have created. The dynamic spreadsheet are the best and trust me, I can say from experience, they certainly get you noticed at work. What’s more there are only a handful of techniques to master to produce each and everyone of these spreadsheets and Mynda Treacy is [More]
This features used to be very hidden on old version of Excel and used to be called the “camera”. If you are unfamiliar with this feature then you are going to be amazed at how you can can “take a picture” of a set of cells and overlay the picture anywhere on your spreadsheet. But this feature is not just a screen capture as when your original cells update so does your picture! Once you have mastered the technique you have a really powerful tool that you can use to create awesome dashboards. for more inspiration and training for Dashboard [More]
This video shows you how to use the course website for the Excel Dashboard course – a number of users of this website have already signed up and are benefiting from the great teaching methods of Mynda and her team – if you need to create spreadsheets distil a lot of imformation into a single page and add some dynamic features then I recommend that you you read my full review of the course here and claim a 20% discount before the 7th November.
Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.