This one is just for fun but if you have a spare 4 minutes I recommend you grab a cup of coffee, take a break and watch in amazement at this guy’s talent. Nothing useful in this video – but it may just change your mind on whether the drawing tools in Excel could be used for something other than boring boxes! Enjoy! (In case you were wondering – this video covers just over 12 hours work! – some people just have too much time on their hands!)
Left, Mid and Find are functions you need to master if you are going to extract text from cells in Excel.  This is especially useful for things like extracting first names, or address details. In this example you will see how to extract the text before a coma using the Excel FIND and the Excel LEFT statement.  Then it goes on to show you how to use the Excel MID statement.  Watch out for a #Value error using these functions if the text cannot be found – you may need to use an an ISerror() wrapper for the expression.  However [More]
In this video you will learn how to use the AND and OR functions in Excel.  These are usually combined within and IF statement but I like this video because he keeps them as stand alone functions and that this gives you the clearest view of how the AND and OR functions work in Excel. If you have found this useful please leave a comment below or click one of the social buttons on the right hand side.
This short video shows how to create a very simple Excel VBA form and open and close it using VBA routines. I like this video because it is only 3.5 minutes long and it shows you in that time how to do everything you need to start adding VBA User forms to your Spreadsheet. Just a quick note the short cut key talked about in this video is F8 to step through a routine – i.e. every time you press F8 it moves down one line of code. You will soon learn that this is the best way to debug [More]
Pivot tables are one of the most powerful and most underused features in Excel. The interface has been reworked in Excel 2007/2010 and this video show how to create a Pivot table in Excel 2010. What you will see in this video is that pivot tables are quick and easy to do and use no Excel equations at all. I added this video on the because it is only 5 minutes long and it shows two really cool features of pivot tables – the first is that it groups date data by day month year automatically and the second is [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 is a really well presented video that shows you some really cool suggestions for using Excel 2007 and Excel 2010 conditional formatting. In the first example it shows you how to insert an IF and OR statement to control the contents of the cell and then applies conditional formatting to the cell to create the icons. What is great about this video is that it does not stop there. In the second group it shows you how to apply data validation to cells to give a drop down list of values the user is able to select (always cool [More]
This short video shows a clever method for controlling how the bars on your bar charts are stacked. In this video you will learn how to control the bar chart Axis text, adjust the thickness of the bar and how to group data together so sets of data sit side by side. This last item is the real highlight of the video and something I had not seen done before – I hope you find it as useful as I have. This video has been supplied by our friends at www.Myonlinetraininghub.com who have a fantastic set of Excel training videos [More]
This video shows you how you can have more than one type of chart type on a single chart (often called a combination chart).  In the video an example is used to show how to have one data set shown as a bar chart and one set of data as a line chart.  Pretty cool! The trick is to use the second scale option on the graph using the format data series options. The video gives a clear and easy to follow example – which we can probably related to. This video is taken from the missing manual books. If [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]
In this video we look at creating a DO LOOP in Excel VBA.  The DO LOOP arrangement allows the section of code between the DO command and the LOOP command to be repeated until a specified condition is true.  As the majority of VBA code you write will repeat a process for several lines of data getting to grips with this command will help you write clearer code. The example in this video is easy to follow and easy to replicate for yourself – so once you have watched the video have a go at getting it to work for [More]
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.