democratizing data and analytics
You must have come across a number of situations when you were trying to explain a formula that you have written in Excel and the result of the formula. This kind of situation basically demands both the formula expression and the formula result to be displayed simultaneously. For example, from the below screenshot, if you... Continue Reading →
We all now know that VLOOKUP has one major constraint that the column in the lookup table from where the lookup value is to be searched should be the first column in the lookup table. Here is a tricky way that you can use to overcome this constraint. The trick is, if we can build... Continue Reading →
Hi.. Here I have composed a comprehensive listing of keyboard shortcuts for Microsoft Office Excel 2010 in downloadable PDF format. Please do share the keyboard shortcuts if you know any that are missing in this list and help improve this listing. Do share your comments or suggestions, if any.. [office src="https://onedrive.live.com/embed?cid=0176F69A8A420BD0&resid=176F69A8A420BD0%211277&authkey=AKVSXsv9GTxdLV4&em=2" width="476" height="288"] Happy time... Continue Reading →
