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 use the function properly: It is not a document, so it will not populate among Excel Date...
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, criterion) For example, in the image below, we are counting if the currencies appear in our...
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 awarded only salaries within their job grade scale? Here are the 4 steps: Select the Salary...
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 and select the in-built rule of highlighting duplicate rules. WRONG! Hardly did I know...
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 below video explains the steps Note: ⭐ It is possible to create an array of Date and Time...
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 columns in curly braces. NB: You can insert the column numbers in any order. For example,...
Recent Comments