How to use XMatch() in Excel
XMatch() function in Excel locates an item in an array or range of cells, then returns its position relative to Read More
Annabelle Almer
About Annabelle Almer
Posts by Annabelle Almer:
How to do your own modelling in Excel with Forecast
Excel can use past data to project possible future results with the Forecast feature. It’s a very simple version of statistical ‘modelling’. The Read More
The best way to add drop-down list in Excel
Previously we talked about How to add a Drop-down List in Word, but you can also work more efficiently in Excel worksheets by making Read More
New Lambda options and helper functions for Excel
Excel 365’s nifty LAMBDA feature is getting an interesting, literally optional, improvement plus ‘Helper’ functions to extend its usefulness. LAMBDA, a powerful tool that allows users Read More
How to Force a Page Break through Styles Setting in Word
There’s another way you can force a page break before a paragraph in Microsoft Word. By setting this up, the Read More