by Crispo Mwangi | Jul 1, 2022 | INTERMEDIATE EXCEL
Data validation is very important as it prevents bad data entry and thus saves time in data cleaning. Let us see how to prevent duplicates in data entry. There 4 steps to building a good data validation: Test your validation formula firstSelect the area to apply the...
by Crispo Mwangi | Jun 24, 2022 | INTERMEDIATE EXCEL
Sequential numbers can be used as unique identifiers and an easy way to maintain a count. Below is how to highlight non-sequential numbers in excel. Steps: Select the area to apply Conditional formattingGo to Conditional formatting → New rule ► Use a Formula to...
by Crispo Mwangi | Jun 17, 2022 | BASIC EXCEL
Duplicates can be a mess in data analysis. Here is an easy way to conditionally highlight duplicates in rows The only trick here is knowing how to COUNTIF function to count data using a criteria
by Crispo Mwangi | Jun 10, 2022 | BASIC EXCEL
COUNTIFS is a very important function when you want to count items with criteria. By default, COUNTIFS criteria are related using AND logic. For example, the below function will count all “Furniture” Products whose Sales Currency is “KES” i.e...
by Crispo Mwangi | May 27, 2022 | INTERMEDIATE EXCEL
Learning how to sum the top or bottom n values in excel requires one to first be familiar with the LARGE & SMALL functions. The LARGE function returns the “nth largest” Value in a list…=LARGE( list, n) The SMALL function returns the “nth...
Recent Comments