Excel Tips and Tricks

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

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

If you are an aspiring Data Scientist then the Pandas pivot table is one of the primary tools that you must learn. We all know how to use the excel pivot table. In fact, there are many use cases from summarizing data to performing calculations. But as you know excel pivot table is based on a Graphical User Interface (GUI) so it’s relatively easy to learn and apply. On the contrary Pandas pivot table is based on python code so it can be overwhelming for beginners and often your excel pivot table understanding will interfere. ...

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

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

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

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