by Crispo Mwangi | Aug 17, 2018 | BASIC EXCEL, INTERMEDIATE EXCEL
There are times when you want to look up and retrieve values based on a list. Normal filtering can only take up a maximum of two items and limited criteria conditions. In this article, you shall learn 4 ways to look up items not matching a list. For example, below we...
by Crispo Mwangi | Aug 4, 2018 | ADVANCED EXCEL, INTERMEDIATE EXCEL
Duplicates can be a pain in data analysis leading to the wrong conclusion. This is why knowing how to lookup unique values is very important. This article shows 5 ways to tackle duplicate data menace and create a dynamic lookup table with unique values. The task is to...
by Crispo Mwangi | Feb 8, 2018 | INTERMEDIATE EXCEL
Every organization requires weekly summaries to monitor peak and off-peak periods. This is mostly so when you are in the production section. Excel has a beautiful but overlooked function (WEEKNUM) that returns an integer representing the week in the year (1 to 53)....
by Crispo Mwangi | Jan 20, 2018 | BASIC EXCEL, INTERMEDIATE EXCEL
In the year 1882, a German philosopher, Friedrich Nietzsche made a claim that has revolutionized Philosophical and Theological discussions since then. His Claim–God is Dead. There has been a similar discussion in the Excel world, not about God, but about...
by Crispo Mwangi | Jun 29, 2017 | ADVANCED EXCEL, INTERMEDIATE EXCEL
When is the last time you used the REPT function in Excel? REPT is one of excel’s little-known, overlooked, and underutilized function, yet very useful. Generally, REPT returns a specific text string a specified number of times....
by Crispo Mwangi | Jun 16, 2017 | ADVANCED EXCEL, INTERMEDIATE EXCEL
IF function is one of the most used functions in Excel. In my opinion, it is the foundation of all programming and Excel formulae mastery. However, it is also one of the most misused functions, especially Nested IF. Especially now with Excel 2007 and beyond,...
Recent Comments