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 | 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 | 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...
Recent Comments