by Crispo Mwangi | Jun 5, 2021 | BASIC EXCEL
Data cleaning takes up to 80% of the time for a data analyst. To save time use the below tricks to find and replace mixed digits and letters in a string Find and Replace ALL Numbers in Excel Given the below data, find and replace all number digits NB: the Trick is...
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 | 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 | Dec 29, 2017 | BASIC EXCEL
When was the last time you used excel tables? Do you know how powerful excel tables are? If you have never or not recently used excel tables, it could be because you have not realized how powerful they are in data analysis. By reading below 7 excel tableās secrets,...
by Crispo Mwangi | Oct 5, 2017 | BASIC EXCEL
The ability to lookup number values in excel is a must-have for all data analysts. Some Excel users just know the basic VLOOKUP function but there are 7 more functions to lookup values. The more lookup function you know the better you become in retrieving numbers like...
by Crispo Mwangi | Feb 3, 2017 | BASIC EXCEL, INTERMEDIATE EXCEL
In the previous article, we looked at 6 ways to find the last or Nth occurrence in a Sorted list in excel. Unsorted list poses a challenge since you need to find the occurrenceĀ using multiple criteria. To show the different methods I have created a list of Customers...
Recent Comments