Best & Worst case chart in excel

Very often we use Best-case and Worst-case scenarios to explain uncertainty. If you are into Sales or Revenue forecasting then you should be familiar with these terms. To understand further you can read the scenario planning article here. In this tutorial, I’ll show you how to create a nice little Best case and Worst case chart in excel to explain the underlying uncertainty. Excel chart for best & worst case If you know how to create a Line chart in excel then it will be very quick and easy....

April 18, 2022 · Sudheer Tammini

Excel SUMIFS formula with multiple criteria in the same column

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

February 21, 2022 · Sudheer Tammini

51 Best Excel Tips and Tricks to skyrocket your productivity [2022 update]

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

December 12, 2021 · Sudheer Tammini

10 Reasons for Excel Formulas not Working [and How to Fix Them]

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

May 2, 2021 · Sudheer Tammini

Excel Vlookup Tutorial for Humans [updated for 2021]

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

December 14, 2020 · Sudheer Tammini