TagExcel formulas

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

Sumifs Google Sheets – A detailed walkthrough & video tutorial

S

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

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