Joplin - The best Evernote alternative for 2021 and beyond

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 process, I have come across Joplin....

July 6, 2021 · Sudheer Tammini

Employee Attrition Prediction using Machine Learning

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 of my data science/ML skills....

May 24, 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

Slicer in Excel - A better way to filter your data

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

March 8, 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