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.
This video is taken from the Excel Dashboard course run by Mytraininghub – read my full review of this course here The video shows how you can add text labels to the title of a graph so that when the data the graph is plotting changes the title keeps in sync with the data. It is a surprisingly simply idea and as you will see from the video it is easy to do and the presenter explains it very clearly.
If you are going to create Excel Dashboards you will need to fully understand how the Excel Offset command works. The video looks at ways that the command can be used to return values from a list of data based on other values in the spreadsheet. This is commonly used on graphs that allow you to set a date range to plot dynamically. This is one of the original Improve Your Excel videos and you can download the XLS file used in this video by clicking here. To download 47 videos just like this one together with the files used [More]
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.
This video shows you how to create a frequency distribution chart using an array formula. there are a number of ways to create a frequency distribution chart in Excel, you can use a pivot chart, create a set of equations using countif or the method contained within this video. You need to pay special attention at the part when the formula is copied down – the Ctrl Shift Enter combination is vital when you copy the equation.