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]
Simple shortcuts likes the ones shown on this video can save lots of time each day. How many times do you cut and paste data around Excel? If you are like me then I guess your answer is “I cut and paste in Excel all the time”. If so then you should watch this video as it shows you two cool tricks for cutting and pasting data in Excel and will introduce you to two really cool shortcut keys. Very simple video and really well explained
Adding a User Form into an Excel Spreadsheet can really start to transform how your spreadsheet works. It is not as difficult as it may first appear and this video will walk you through the process of adding a form, changing the properties of the form and the way it looks. It then goes on to add a text field and button to the form. Make sure you listen to the advice on naming buttons – this is a really good habit to get into. Finally this video adds VBA code to the button to populate the text box on [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]
I use the TEXT function in Excel a lot to add numbers and dates into paragraph text. It is a little know technique and I often see people using cells instead and that quickly turns into a formatting nightmare. This video clearly shows how to use the TEXT Excel function and how to use it to embed data into paragraph text. Enjoy and try this out for yourself.
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.
With the job of reviewing videos for this site there are times when you have a “I did not know Excel could do that” moments. This is one of these moments as the video below shows you a right click menu for comments that I did not know existed. By default Excel will put Yellow Comment boxes up – but now with the information in this video you can have red, amber, green (or indeed any other color) to show how important the notes are in each Excel Comment Box. Very simple when you know how – but if you [More]