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]
This video helps you be more familiar with your new Excel 2010 environment by teaching you how to customize the way the environment works – including extensive coverage on how the ribbon can be fully customised in Excel 2010.
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.
Protecting your worksheet and formulas is important if you are going send other users your spreadsheet to use. Chances are they may change one of your award winning equations either on purpose or by mistake. That makes the QA of the worksheet difficult to gauge and can be a nightmare for you to unravel later. This is a great video – the first two minutes show you some pretty cool skills on making a dummy dataset (RANDBETWEEN is a new one for me) and it is worth watching what he does here some great tips. After this the video [More]
A nested IF statement is an IF statement that sits inside of another IF statement and this video shows you how to created a nested IF statement. I have to be honest here – in this video you will learn how to use the insert Function dialogue to insert nested functions and I did not know you could do. In fact over the 5 years I have been teaching Excel to my classes I have told them this is not possible! Opps I had better change that! It just goes to show you that no matter how long you have been using [More]
This video shows you all the options for adding a hyperlink to your spreadsheet. I like this video because it covers everything you may want to do with simple hyperlinks in just one video. The video starts with linking to a webpage, then shows you how to link to a different sheet or cell within the same file and then how to link to a different file or word document. Watch out for the navigation tip at around 5.40 – I never knew you could do that! If you have found this video useful please let me know using the [More]
This is a simple and short video that shows you how to turn off the automatic hyperlinking options in Excel. This option is the one that turns a web address or email address into a clickable link. Sometimes this is useful but it can also get very annoying if you do not want the link to appear underlined and coloured when you print the sheet out.