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...
How to fill blanks in Pivot Table [Excel Quick Tip]
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...
How to Solve Your Real Problems With Excel Goal Seek
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...
How to Create Appealing Excel Data Validation Drop Down List
If you haven’t used excel data validation drop down list in your reports then you are mostly missing something “really big”. The combination of well-structured drop down list and formulas like Indirect, Sumifs & Vlookup are the deadly combinations for Excel dashboards. So, in this step by step tutorial, I’m going to cover how to create drop down list in excel. We will...