democratizing data and analytics
Scenario: Here is a scenario that I have come across recently in Excel. I have the data in column that is split across multiple lines in each cell, more technically speaking, separated by carriage returns. i.e., the text in the cell is separated by pressing ALT + ENTER. see the below screenshot: Challenge: Now the... Continue Reading →
Here I came across a scenario of Microsoft Excel behaving strange, when trying to find and replace asterisk character (*) with another character. Scenario: Here is a list of data in an excel worksheet containing some fictitious data of names and salaries of a few employees. You can see that some of the names are containing an asterisk... 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 →
