CategoryMS excel

51 Best Excel Tips and Tricks to skyrocket your productivity [2022 update]

5

I went from being a bad excel user to a professional after learning these excel tips and tricks. The good news is I’m going to teach you these tips using simple and real-life examples. There has been so much written about the best excel tips and tricks on the internet, I could literally find 2,23,000 exact matches by the time of writing this article. So, I don’t want to write one more...

Pandas pivot table for excel users

P

If you are an aspiring Data Scientist then the Pandas pivot table is one of the primary tools that you must learn. We all know how to use the excel pivot table. In fact, there are many use cases from summarizing data to performing calculations. But as you know excel pivot table is based on a Graphical User Interface (GUI) so it’s relatively easy to learn and apply. On the contrary Pandas...

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