Latest stories

5 Clever Ways to Use Excel Go to Special Command

Excel Go to Special command has a special focus in the industry, do you know why..? As the name suggests, the user can quickly select a cell or a group of cells based on a preferred condition. For example, if you want to quickly see all formula cells in your workbook then your ideal option would be “Go to Special”. It’s not just limited to formulas, you can also use it for...

12 Spectacular Excel Skills Employers Looking for

It was 2010, I was just out of college and searching for my first job, I was scrutinised in an interview to check whether I have required excel skills or not. Thankfully I was fully prepared to answer their questions and got selected for the position. I think it’s most common situation for young & experienced professionals nowadays. Increasing dependency on excel is actually demanding...

The Ultimate Guide to Excel Keyboard Shortcuts

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...

Excel text formulas: 19 profound ways to bend your data

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...

Excel SUMIFS Formula: Your Business Can’t Live Without

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...