Probability and Proportion are not the same. Although they appear to be the same however there is a very thin line between these two concepts. Let me explain! Probability vs Proportion What is probability? Wikipedia definition “Numerical descriptions of how likely an event is to occur or how likely the proportion is ture” Simply put, […] Source ..read more

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 […] Source ..read more

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 […] The post Excel SUMIFS formula with multiple criteria in the same column appeared first on My Experiments with data ..read more

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 […] The post Pandas pivot table for excel users appeared first on My Experiments with data ..read more

I have been looking for the best Evernote alternative for a very long time. I have tried OneNote, SimpleNote, Notion, Dropbox paper etc. but nothing worked for me. So my search continued, but this time I was looking for open-source alternatives. My main criteria were, there should be an Android app, a Desktop app for […] The post Joplin – The best Evernote alternative for 2021 and beyond appeared first on My Experiments with data ..read more

Yes, the headline is correct, this tutorial is about employee attrition prediction using ML algorithms. A person like me who mostly writes tutorials on Excel and Finance has taken up this challenge to learn Data Science a few months back. (Please note I’m a finance professional with no IT background ) And today I can […] The post Employee Attrition Prediction using Machine Learning appeared first on My Experiments with data ..read more

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 […] The post Slicer in Excel – A better way to filter your data appeared first on My Experiments with data ..read more

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 […] The post Excel Vlookup Tutorial for Humans [updated for 2021] appeared first on settingbox.com - Excel Tips & Tricks to analyse your data ..read more

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 […] The post Sumifs Google Sheets – A detailed walkthrough & video tutorial appeared first on settingbox.com - Excel Tips & Tricks to analyse your data ..read more

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 […] The post Excel Sparklines – Add Thrust to your Analytical skills appeared first on settingbox.com - Excel Tips & Tricks to analyse your data ..read more