Monthly Archives: July 2019

Updates on Excel Magic in One Minute

Six weeks ago, I created my YouTube playlist – Excel Magic in One Minute. As of today, I’ve already published 17 videos to the playlist.  Meaning 2-3 videos per week.  Not too bad as a weekend YouTuber (newbie), I guess. … Continue reading

Rate this:

Posted in General | Tagged | Leave a comment

Do your random numbers stay the same when you copy and paste in Excel?

This is an extension of my previous post – Freeze a random result with mouse trick. In my experience using Excel, from Excel 2000 to 2010, and recently 365 (I’d never used Excel 2013 though), I have experienced the same strange … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 10 Comments

Freeze a random result with mouse trick

Perhaps you have tried to use Excel to generate a random number for a lucky draw. That is easy.  For example, if you want to generate a random number, you can use the function RANDBETWEEN. =RANDBETWEEN(1,1000) This will give you … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments

How to sort bar chart in descending order?

Sound like a silly question, but it is a bit confusing indeed. One day, a friend asked me how to sort a bar chart in descending order.  I told her to sort the data. She replied: “I did.  The data … Continue reading

Rate this:

Posted in Chart | Tagged , | Leave a comment