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 …

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 …