Videos uploaded by user “MF Wong”
A compelling chart for Actual vs Budget, Target and Last Year
Note: Please turn on CC for English subtitles. In business world, we often compare actual sales to various benchmarks such as budget, target, and last year. In this video, I am going to show you step-by-step how to make a compelling chart for this purpose. This is basically a simplified version of bullet chart, and is super-easy to create. I hope you find it useful and relevant. If you like this video, please give a thumb up and subscribe to my channel / blog. :) Blogpost: https://wmfexcel.com/2019/02/17/a-compelling-chart-in-three-minutes/
Views: 128 MF Wong
When unhide row doesn't work...
Note: Pls turn on CC for English subtitles. This video show a situation when unhide row does not work as expected in Excel, and how to unhide them with a workaround trick. Blogpost: https://wmfexcel.com/2014/04/01/when-unhide-row-doesnt-work/?wref=tp
Views: 386 MF Wong
Turn CSV data into insight like a pro with Excel 2016
Please turn on CC for English subtitles In this video, I will show you how to turn CSV data into meaningful insights in just a couple of minutes with Excel 2016. Techniques demonstrated are mainly Flash Fill and Quick Analysis, these two features were introduced in Excel 2013 but somehow most people are not aware of it. Nevertheless, the two chart types, Histogram and Pareto are "new" since Excel 2016. Hope you like it. Blogpost: https://wmfexcel.com/2019/03/03/turn-csv-data-into-insight-like-a-pro-with-excel-2016/
Views: 44 MF Wong
Birthday Treat Calculator
Turn CC on for English subtitles. Something silly but interesting... In short, it is a calculator for an unusual scenario. :) Want the story, read my blogpost: https://wmfexcel.com/2019/03/16/birthday-treat-calculator/
Views: 18 MF Wong