CategoryMS excel

Slicer in Excel – A better way to filter your data

S

Almost everyone knows how to use filters in excel but very few know that there is visual filter called ‘slicer in excel’. Without any doubts filters are most commonly used functionality in excel to slice and dice data. Its very useful and easy to use when you have multiple columns. But given that filters work based on dropdowns the selections are hidden and only visible when you click...

LibreOffice Calc: The finest alternative to MS Excel

L

There is an MS excel alternative… …Its very nice, powerful, and moreover its free Just a few days back I had some issues with my office installation. I have tried uninstalling and reinstalling but didn’t work. I was so frustrated so desperately started looking for an excel alternative (you can understand my frustration) Just started googling with a search phrase ‘best...

51 Best Excel Tips and Tricks = Professional In Excel [Free Ebook]

5

This is the largest collection of best excel tips and tricks on the web. I know, you have got a lot of advice out there about various excel tips and tricks, but you still tend to crave for more, aren’t you? “Excel Tips” The reason is very simple. Microsoft excel is not just a piece of software, it’s a skill. Burning Glass research suggests that “nearly 8 in 10 middle...

How to Solve Your Real Problems With Excel Goal Seek

H

We want to generate $1m Revenue in 2018 said by CEO. Well, that’s ambitious goal… Considering our current year Revenue is at $0.7m but how do we achieve that..? let’s see if we can use Excel Goal Seek to put some foundations. By the way, we are into Chocolate business. I’ll walk you through step by step on building various models to achieve 1m revenue target by using Goal...