Excel Formulas

Very often, you will have to construct an excel SUMIFS formula with multiple criteria based on the same column values. Which is equivalent to the SUMIFS formula with multiple OR conditions. I guess you may have tried it…but find it difficult to achieve. Because the Excel SUMIFS formula does not have any such option. So let me explain how to achieve this using a few tricks. Excel SUMIFS with multiple criteria If you are reading this article then I’d assume you already know how to use SUMFIS in general, if not then here is my SUMIFS tutorial. ...

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 article with all the garbage. ...

“Oh My God” excel formulas not working in my report. Sounds familiar right? If so, don’t worry, you are just one among many excel users who face this problem very often. Just think about it. You have built an excel model for Sales Forecast using various logics with fairly complicated formulas. [‘IF’ formulas with 64 conditions – just kidding] And when you try to use that model, you see some of your formulas either not working or looks broken. ...

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

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

People who use Pivot Tables regularly knows this issue very well. ….i.e. manually refreshing pivot tables in your workbooks. It’s perfectly alright to use the manual method if you have one or two pivot tables in your reports. …but what if you have 5 to 10 pivot tables and then you will need to refresh all of them regularly..? Well.. that’s a boring job. So with that in mind, I have written this tutorial to help you build your own Pivot table refresh macro to automate the process. ...

There are a lot of issues in Excel. The most annoying one is “Excel cannot create or use the data range too complex”. I’m sure, by referring above sentence you will not be able to figure out route cause of the problem. Then, what will you do? You will google it… ….there will be some workaround and the problem is solved [tempreoraly]. Some other day again same problem and same googling. ...

In this step-by-step tutorial, we are going to take a look at how to split first and last name in excel with detailed examples. Data mining is cumbersome work! You need to have a better understanding of various excel text formulas and tools like the Text to Columns to deal with the situation. If you happen to be the one who lacks these skills, then no worries, you’ll certainly have a better understanding after reading this tutorial. ...

The term speedometer is very well known in the automobile industry, however in today’s tutorial, we are going to take a look at how to create Speedometer Chart using google sheets. Creating visually appealing presentations is a key to a successful business meeting. Indeed, traditional excel charts will certainly boost your confidence but that’s not enough. In a world increasingly saturated with data and information, visualizations are a potent way to break through the clutter, tell your story, and persuade people to action, says Adam Singer – Analytics Advocate at Google. ...