The Excel Goal Seeking options allow you to play with your data and find out how your parameters need to change to make the result you need. There are two ways to do this in Excel, one is trial and error (this is the most popular way – and the least productive) and the other is to use the Goal Seeking options in Excel. Many users do not even know that this feature exists in excel. The file used in this video can be downloaded from here This video is one of Clayton Lock’s 47 videos – to find out [More]
This is one of Mike Smart’s great Excel videos from his Expert Excel course and it teaches how to use the Excel IF statement in a very clear way. Mike’s course came out top in our recent reviews of Excel video courses and you can get three more free videos from him on our review page You can download the file used in this video from here
I like this video as it talks a little about how to best present lots of data in a pie chart as well as showing you some really cool tips and tricks in making the visual appeal of the pie chart much higher. The video covers how to add labels and when to use exploded pie charts. The link on the video does not download the XLS file that is used to create the pie charts in the video but I have recreated the file and you can download the XLS file from here
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 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 Excel VBA. Mastering the techniques in this video will save you hours and hours The video covers how to use break points in the Visual Basic Editor in Excel to stop code as it is working through. It then goes on to show you how to use the watch function to check the values of any variable at any time in the code. You will also learn [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.
It is vital that you get to grips with Excel Named Ranges if you are to Improve Your Excel Skills. This video is an original Improve Your Excel video and shows 3 great ways to use Excel Named Ranges. It starts by looking at naming cells and using them in equations. Then it looks at naming a group of cells and finally it looks at one of the secrets of Excel named ranges and how to use them with with Data Validation drop down list. This video was recorded a few years ago – but everything shown works with Excel [More]
This video clearly explains how to use two very simple Excel features to produce a very powerful technique. Using the autofilter and status bar is a trick not to be missed and although this video demos the feature in Excel 2003 it works even better in Excel 2007 as the status bar allows you to have multiple statistics visible at the same time. You can download the file used in this video by clicking on this link This is an original Improve Your Excel video and we hope you have enjoyed it. You can download all 47 of the original video series [More]