I don’t believe I don’t have this here yet. This is one of my oldest tricks When we have to do links between two workbooks (One cell in Workbook1 to have value updated from a cell in Workbook2), we usually just do links like this… Go to workbook1, select a cell, type in ‘=’ then go to […]
I have been asked for a while now to just put a simple VLookup function, here it is, I know this might be stupid to post it here, but we need to fill requests from all types of visitors. Vlookup is the most famous function in Excel, some people actually refer to Excel as VLookup. […]
Excel 2010 has a lot of new exciting things, one of them is the ‘Engineering’ category of functions, this was usually a plugin we have to add to get, but in Excel 2010, it is already there. The function ‘Convert’ does what you expect it, converts a number from one metric to another. Of course, […]
