by Crispo Mwangi | Dec 26, 2021 | ADVANCED EXCEL
Though not a popular dynamic array function, there are many ways to use the RANDARRAY function in Excel. How come the RANDARRAY function did not and does not get as much fuss. Is it important to learn it? Even when the excel experts were asked to vote for their...
by Crispo Mwangi | Oct 29, 2021 | INTERMEDIATE EXCEL
Knowing how to Analyse Multiple Choice Survey Data In Excel is a must-have skill since Multiple choice questions are the most popular questions. For example, a Bank has requested it, customers, to rate 3 of its department’s services from Very Unsatisfied (-100%)...
by Crispo Mwangi | Oct 16, 2021 | ADVANCED EXCEL
Apart from XLOOKUP, the other dynamic array function that gets too much publicity is FILTER Function. 29 Excel Experts ranks it as the 3rd most important function to learn. Why all the fuss with the FILTER function? Is it the future of Lookup functions? Here are 24...
by Crispo Mwangi | Jun 5, 2021 | BASIC EXCEL
Data cleaning takes up to 80% of the time for a data analyst. To save time use the below tricks to find and replace mixed digits and letters in a string Find and Replace ALL Numbers in Excel Given the below data, find and replace all number digits NB: the Trick is...
by Crispo Mwangi | May 27, 2021 | INTERMEDIATE EXCEL
Assume you have below data and you need to get the last name as Surname & the rest as Other Names. If only One name exists extract it as the Surname. Here are the Steps to follow: Find the position of the last word in the name.To do this you need to count the...
Recent Comments