Grade Estimator
Grade Estimator excel file for your class tracking I want to share with you a template for building a gradebook […]
Read more →
ROI Estimator
ROI Estimator example for the real estate business I want to share with you a ROI estimator built for the […]
Read more →
Expense Splitter
This happens to all of us. You are invented to a barbeque and someone buys the meat, another the beer […]
Read more →
Recruitment Dashboard
Have you ever wanted to track your HR recruitment performance? If you did, this post is for you! I will […]
Read more →
Median and Outliers for big Data
I helped someone out with trying to find the Median and excluding the outliers. He had ~14K lines of data, […]
Read more →
Excel Hlookup
Excel Hlookup, it’s Vlookup’s forgotten brother or sister (depends who is asking). It’s not as popular as Vlookup but it’s […]
Read more →
Excel Vlookup
Excel Vlookup, it’s a classic and an Excel blog would not be complete without. So I will share with you […]
Read more →
Excel dates – what to do when the data is not a date…
This happens to me a lot. I open a database and find out that the data under the column Date […]
Read more →
Excel Averageif, Averageifs
Excel Averageif & Averageifs are a very useful function in case you want to quickly change the conditions of what […]
Read more →
Excel Countif , Countifs
Excel Countif and Countifs are a must function for any Excel user. If you want to count the number of […]
Read more →