CrispExcel Training & Consulting

How to Sort Data from Right to Left?

Excel sorts data from top to bottom by default, but there is an easy way to sort it from right to left.

How to return Multiple Items using DATEDIF?

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... Read More INTERMEDIATE EXCELJul 7, 2023 Crispo Mwangi0

How to SUM Data Per Week Using Pivot Table?

If you love low-code solutions then sum data per week using a pivot table is the way to go. The only trick here is to remember, Pivot tables lack the Week grouping. A way around this issue is to group 7 days together. See the below Video for steps to follow:... Read More BASIC EXCELMay 23, 2023 Crispo Mwangi0

How to Lookup Items in a List?

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... Read More INTERMEDIATE EXCELMay 12, 2023 Crispo Mwangi0

How to SUMIF Data Ignoring Hidden Rows in Excel?

SUMIF Data Ignoring Hidden Rows in Excel is not as simple as other types of summation using criteria. This is because the SUMIF function does not ignore hidden rows. The solution comes from using a combination of SUBTOTAL & OFFSET functions to return only... Read More ADVANCED EXCELMar 8, 2023 Crispo Mwangi0