Posts

The engine needs powerful thrust for speed, whereas analyst needs a handful of Excel keyboard shortcuts to crunch data and convert that into a useful information. Indeed it’s not always a good idea to work with the mouse for selecting various options. According to thekeycuts average analyst can save 10.79 minutes a day & 47 hours a year by using shortcuts, that sounds a lot isn’t it..? Very often it’s a need for analysts to learn new excel shortcuts to meet the required speed, but the real problem is, how do you remember all the shortcuts..? ...

Can better data let you make better decisions..? Maybe yes, with Excel text formulas you can analyze data effectively. Every day your business will generate millions of lines of data, and most of the times your data will not be in a structured way, even the best technology in the world cannot give you ready-made data to support your decision-making process. I think that is the reason why we’re so heavily dependent on MS Excel from simple to complicated analysis. ...

From a common excel user to advanced user everyone will use sum formula very often. How about same sum formula, with little more advanced features..? Confused..? ok, I’ll put it in simple words. What if you can sum numbers based on your own criteria..? or maybe you want to add multiple criteria’s and then you want to sum for only those. Well, with Excel SUMIFS formula everything is possible. Basics : Excel SUMIFS formula Growing business requirements need more complicated data analysis in almost no time to phase up with the competition. So, as an analyst how does you cater those requirements..? ...

The day when I started with my first paycheck, I’ve been thinking how to save money for the future, but it was always hard for me to do so, because of my spending habits. It was almost a kind of an unsolved puzzle until last month, when I realized that, I have been able to save Rs. 100,000 in a short span of time with simple techniques. According to “The Organization for Economic Cooperation and Development”, most of the Americans save on average only 4.5% of their income, while Europeans save nearly 8% and Australians more than 11%. ...

Do you know even today 7 out of 10 people don’t know about MS Excel Alternatives.! Almost all Universities, Colleges, Schools, Business Houses, Financial institutions, use excel one or the other way. According to Chandoo.org, “about 80% of high paying jobs require advanced Excel skills” MS Excel is the first application that comes to our mind when we talk about Reporting or Analytical related stuff, indeed, it’s very well known fact and widely used spreadsheet application in the industry. ...