By Keith Yap

Things I've Learnt

Page 2 of 2

Select multiple items from a list in Excel

For the rare occasion when you need to select multiple items from a list in Excel, the below VBA code will do the trick, complete with a nice selector panel. See the screen capture below for it in action. This… Continue Reading →

Text Analysis using Excel

Word Counts Word Clouds Sentence Counts Sentiment Analysis Topic Modelling Combining it all together Below is a summary of my explorations using excel for text analysis. The example used in this article focuses on customer feedback for a hypothetical bank’s… Continue Reading →

Newer posts »

© 2017 By Keith Yap — Powered by WordPress

Theme by Anders NorenUp ↑