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 on the dropdown. ...

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, Vlookup is not just a formula but it’s a kind of skill to crunch numbers or to speed up your data analysis process. ...

This tutorial is all about how to use SUMIF or SUMIFS formula in google sheets. Personally, I use Excel Sumifs formula all the time but the question is do we have a similar function in google sheets as well. Let’s find out. How to use Sumifs in Google sheets If you already know how to use sumif formula in excel then I think this will be a cakewalk. If not then no worries, I’ll walk you through. ...

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 want to insert ...

Yes…you can count unique vales using a formula. This is often comes handy when you are looking for unique sales rep names in your commission file. Or maybe while reviewing sales file with large number of products. Count unique vales using a formula: For this tutorial I’m going to use Excel COUNTIFS formula hence it’s important to understand this formula first. How does COUNTIFS work: COUNTIFS is a derivative of COUNT/COUNTA function. ...

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 alternatives to MS Office‘, ‘list of free substitutes to excel’ etc… ...

How do I reduce excel file size? The most often asked question. Well, in this step by step tutorial I’ll walk you through various best practices to reduce excel file size and how to optimize excel workbook to work better. #1 Save your workbooks in a Binary format This is my favorite tip and it always works great. I have been recommending this tip since I started writing this blog. ...

Let me get it right.. This is not my regular excel tutorial instead this is a FastComet hosting review — “and of course this is not a paid review – in fact, this website is also hosted with them” In general, this is how it starts… One fine day you come up with an idea to open a website/blog and write about your favourite topic. Then, the process starts like this. ...

Pivot tables are great for summarizing and analyzing data. I use it very often and I believe you too. But there is a small problem… …i.e. pivot tables do not show repeated column labels or content. Meaning – we need to fill blanks in pivot table to do v-lookup Ok..its difficult explain so here is an example. In my above example, the region “East” has appeared once and similarly other regions as well. ...

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 Seek in excel. ...