Excel Power Query is free and can be installed for Excel 2013 or Excel 2010. It is the golden nugget of hidden Excel features, so hidden in fact that many people have never even seen it. This video is created by Mynda Treacy, Microsoft Excel MVP, who in my opinion is the Queen of Excel Dashboards. In it she shows just two of the uses of this very powerful tool and shows you the complete power of reusing power query functions. Power Queries are like VBA but easy to create and just a powerful when working with datasets. Mynda is [More]
Three simple, but very useful, Excel functions are illustrated here. ¬†Upper, Lower and Proper (making the first letter in a word a capital letter). This is very useful especially when working with lists of people’s names.  
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.
Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.