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 →Category: Excel Formulas
Check out the formulas I use for my excel files.
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 →
Excel Sumif , Sumifs
Excel Sumif and Sumifs are a must function for any Excel user. If you want to sum cells in a […]
Read more →
Excel Left
I want to share with you Excel’s Left function. I use Left very often, it’s a very simple function that […]
Read more →
Excel Find
I want to share with you Excel’s Find function. I use find very often, it’s a very simple function that […]
Read more →