TagMS Excel Tips

Excel Vlookup Tutorial for Humans [updated for 2021]

E

In this tutorial we will learn how to use VLOOKUP formula in Excel to get things done effectively. In case, If you don’t know what is VLOOKUP then no worries….you are in a right place. I’ll start with basics and then gradually walk you through all real-world use cases. Lets kickstart this Excel VLOOKUP tutorial and get most out of this. Why should you learn Vlookup? Trust me...

Excel Sparklines – Add Thrust to your Analytical skills

E

Excel Sparklines is an excellent feature but unfortunately, not many people know how to use it. In this detailed tutorial, I’ll walk you through how you can use Excel sparklines to analyze your data quickly and effectively. How to insert Sparklines in Excel Step 1 : In excel 2016 click on Insert –> go to ‘Sparklines’ section Step 2 : Clink on the type of chart that you...

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