by Crispo Mwangi | Jul 7, 2023 | INTERMEDIATE EXCEL
The DATEDIF function is a must-learn function if you want to do date calculations. Generally, it is used to get the difference between two dates. Here is what you need to know to...
by Crispo Mwangi | May 12, 2023 | INTERMEDIATE EXCEL
Looking up items in a list is easy when we use the COUNTIF function. COUNTIF function returns a count of number of times a criterion appears in a dataset. =COUNTIF(dataset,...
by Crispo Mwangi | Feb 9, 2023 | INTERMEDIATE EXCEL
Analysts spend between 60% to 80% cleaning data. Here is how to cut that time by using the SUMIFS function in Data Validation. Given the below data, how do you ensure staff is...
by Crispo Mwangi | Jan 20, 2023 | INTERMEDIATE EXCEL
A friend recently asked me, “How do I condition format duplicates for Long Numbers formatted as text?” I thought…that is easy! Just go to condition formatting...
by Crispo Mwangi | Jan 8, 2023 | INTERMEDIATE EXCEL
Reverse lookup of numbers is easier than that of texts. Reverse Lookup Numbers For example, how do you look up the appointment date and time for a patient in the below data? The...
by Crispo Mwangi | Dec 30, 2022 | INTERMEDIATE EXCEL
By default, VLOOKUP is set to return a Single column but with a small tweak, it can return multiple columns. =VLOOKUP(G2,B2:E24,{3,4},FALSE) The only trick is to put the multiple...
Recent Comments