Monthly Archives: July 2019

Updates on Excel Magic in One Minute

Posted on July 27, 2019 by

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?

Posted on July 20, 2019 by

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

Posted on July 13, 2019 by

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?

Posted on July 6, 2019 by

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