ALL Excel Keyboard Shortcut keys

There are so many keyboard shortcut keys in Excel that it is really difficult to remember. Hence I have created a list of all the keyboard shortcut keys with combination of Alt, Ctrl, Shift and other keys. Click on the below link to download free Excel Keyboard shortcut key list. …

ET 500 companies list in Excel

While doing investment in shares we try to perform research on various stocks. We categorize various securities and identify if someone else has already performed it based on certain research. Every year Economic Times performs similar research and identify Top 500 Companies listed on stock exchange. They publish this list …

What is Power Query

What is Power Query (PQ)? Since 2010 Microsoft is on Fast Track to introduce various new features to worlds most favorite software And these features are just not incremental but are truly transforming Excel. Some of the major updates includes: Power Pivot Power Query Power View Power Map To start …

Selecting the data in Excel

What are the three most consuming activities in Excel?  Getting Data  Cleaning Data  Presenting Data Even out of above three activities second one – “Cleaning the data” would take almost 80% of your time. And before actually cleaning the data you would need to SELECT the data. In this article …