by Crispo Mwangi | Jun 28, 2024 | BASIC EXCEL
Excel sorts data from top to bottom by default, but there is an easy way to sort it from right to left. For example, how do you alphabetically sort the below sets of meals from right to left? Here are the steps to follow: Select all the data, including the column...
by Crispo Mwangi | Mar 15, 2024 | BASIC EXCEL
There are three unforgettable pains; these are pains you feel both psychologically and physically—toothache, childbirth and losing your Excel data. Data loss looms ominously in the fast-paced world of data management and analytics, where Excel is the backbone for...
by Crispo Mwangi | Jun 2, 2023 | BASIC EXCEL
Invisible characters are a great threat to accurate results when working with texts. Trim functions work well to remove Char(32) [spaces] but not Char(160) [non-break space] characters. The solution to cleaning non-break spaces is using the SUBSTITUTE function....
by Crispo Mwangi | May 23, 2023 | BASIC EXCEL
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: DOWNLOAD...
by Crispo Mwangi | Nov 9, 2022 | BASIC EXCEL
Unlike the OR function which returns TRUE if only 1 condition is TRUE, the XOR function returns TRUE if the number of TRUE conditions is ODD and FALSE if the number of TRUE Conditions is EVEN. Like the OR Function, at least one of the test conditions must evaluate to...
by Crispo Mwangi | Nov 4, 2022 | BASIC EXCEL
When testing for multiple conditions, OR logic is used to determine if ANY condition in the test is TRUE. The only time OR function evaluates to FALSE is if all conditions in a test are false =OR( 2>5, 6>5 ) will evaluate to TRUE though the first logical test...
Recent Comments