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 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.
This is one of the longest videos on the site but it shows one of the most useful in showing you how you can make charts in Excel to be dynamic. The video contains a lot of information and it uses excel scroll bars to make a slider on the spreadsheet, then it shows how to use Vlookup to take the value from the slider and look up the values to be plotted. Finally it shows a small VBA routine that shows you how to animate the graph at the click of a button.
I have added this video to inspire you to great things rather than teach you how to do a specific task. This is well work watching if you have heard people use the phrase Excel Dashboard but do not fully understand what it means. Unfortunately there is no sound with this video – but I hope it gets you thinking what you could do using some of the Excel dashboard techniques on this site. Please let me me know in the comment box if this has inspired you …. Almost everything you see here (except the animation) can be done without [More]
This video is one of Clayton Lock’s original videos and you can download the file used in this video. This video covers vital learning for anyone who wants to get started with creating VBA functions in Excel. It starts by showing you how to create a simply Excel VBA function to display “hello world” on the screen and then goes on to show you how to do something far more useful with a function and return values to the cell that had the equation. This is longer than most videos on the site but I recommend you watch it all [More]
This short video shows how to use the INDIRECT command in Excel to change the contents of a drop down list dynamically. This is an original Improve You Excel video that was originally recorded in Excecl 2003 but will work just as well in Excel 2007 and Excel 2010. The file used in this video can be download here I would love to hear what you think of this video – so please leave comments in the box below of use one of the social buttons on the right to register a positive vote for this video.
This video introduces you to the OFFSET command in Excel. 99% of people have not heard of the OFFSET command and the other 1% are often left wondering what you can do with such an odd function. Smart tables and graphs are the OFFSET command best uses and this video shows an excellent use of the command linked to a scroll bar on the spreadsheet. We have tagged this video as advanced as there are some concepts in here that may confuse beginners but I would recommend you go ahead and watch just to get an idea of what Excel [More]