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 …

Benford’s Law

It’s all numbers everywhere and most of us in the auditing environment are trying to make sense out of numbers only. “Accounts are just presentation of Business numbers”. While trying to make sense / auditing these numbers there are various models / methods/ procedures we perform. Benford’s Law has got …

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 …