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 Both Windows & Linux and a strong focus on Privacy. So, in my search...
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 confidently say I’m somewhere around the intermediate level in terms...
“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...
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...
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...