by Crispo Mwangi | Apr 28, 2022 | ADVANCED EXCEL
Having a dynamic training calendar is a MUST for all HR professionals. How it Works: Type the below formula on the Calendar sheet. =IFERROR( TEXT( INDEX(trainings[[Date...
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...
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...
by Crispo Mwangi | May 14, 2020 | ADVANCED EXCEL
NEVER has there been so much noise (fuss) in the Excel Community as it was during the introduction of the XLOOKUP FUNCTION. Excel experts called it “Functions...
by Crispo Mwangi | Aug 4, 2018 | ADVANCED EXCEL, INTERMEDIATE EXCEL
Duplicates can be a pain in data analysis leading to the wrong conclusion. This is why knowing how to lookup unique values is very important. This article shows 5 ways to tackle...
by Crispo Mwangi | Aug 12, 2017 | ADVANCED EXCEL
When was the last time you comprehensively looked at the HLOOKUP function and its alternative? To look up data horizontally, many excel users tend to use HLOOKUP but it...
Recent Comments