By Keith Yap

Things I've Learnt

Page 2 of 2

Rent vs Buy Calculator

A simple calculator to determine if you are financially better off to rent or buy a property. Feedback welcomed in the comments below. Notes: this calculator has been tailored to the Australian market (eg. rent is expressed in weeks) there… Continue Reading →

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 »

© 2018 By Keith Yap — Powered by WordPress

Theme by Anders NorenUp ↑