The more I get into Excel Dashboards the more excited I get. This is a great video that I hope will give you some ideas and techniques to present lots of data on a number of Excel Charts. This video is a little longer than the ones I usually post but it is well worth 15 – 20 minutes of your time. The video looks at a large table of sales data from a number of US states. If you put all the states on a graph at the same time then there is no way you can see any [More]
INDEX and MATCH functions are very useful in Excel when the VLOOKUP function won’t do what you need it to do. This video shows how you can use Match to find a value in a table based on a text string. Once you have position information for the text match you can use the INDEX to return any data from that row or column. This video covers this technique very clearly and shows how you can use two MATCH functions to return the row and column numbers to use in an INDEX statement. We hope you found this video useful. [More]
See how to use the VLOOKUP function to deliver a value to cell – trust us once you know how to do this you will be using it all the time within your worksheets. This is probably the only person in the world who can make you smile while teaching you the VLOOKUP function. This 7 minutes video may save you hours and hours of manually classify data. We hope you enjoy it. Please let us have your comments below or simply click Like or Share above.
This short video shows you what can go wrong with the VLOOKUP formula in Excel. This is a great video as we know that here at ImproveYourExcel the VLOOKUP feature causes users of our site a great deal of problems. Most users give us as they assume the function does not work correctly – where as it is often just one of a few things that go wrong. We hope this video is useful for you – if it is then please like it or share it using the buttons above or leave us a comment below.
This video is a brief tutorial on how to use the vlookup() function in Microsoft Excel. It uses Excel 2007 in this video but everything he talks about will work with Excel 2003 and Excel 2007 and 2010. The tutorial is designed for beginners and works at a nice slow pace.