by Crispo Mwangi | Sep 2, 2022 | INTERMEDIATE EXCEL
The first step to conditional formatting a date or time in a DateTime is understanding how Excel stores dates and times. Date is stored as an integer with 1/1/1900 = 1 therefore 9/2/2022 is stored as â–º 44806 Time is stored as a fraction of 24 hours therefore 4:30:00...
by Crispo Mwangi | Aug 16, 2022 | HR, INTERMEDIATE EXCEL
Benjamin Franklin once said, “in this world, nothing can be said to be certain, except death and taxes”. There is nothing else as certain as these two, (except Failure), yet there are many who are not prepared for them. The question is, given below Tax...
by Crispo Mwangi | Jul 15, 2022 | INTERMEDIATE EXCEL
Extracting numbers from a string in excel is a must-have skill in data cleaning. There are different methods of this extraction depending on the position of the numbers. Extracting numbers at the end of a string Scenario 1: There is a separator between text and...
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 | 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