Wednesday, May 15, 2019

Use the SEARCH Function

If you're looking for some text string or other values within a cell you can use the Find feature in Excel. But what if you wanted to do this programatically and have it execute for every row without manual interventions. It can be done with a built in function called SEARCH...see the video to learn how to use the SEARCH function in Excel.

Tuesday, May 14, 2019

Create a Bubble Chart with Multiple Series of Data

Ask kids if they like bubbles and most likely you'll get a resounding "YES!" Heck even some adults like bubbles. I think it has something to do with the shiny curves and the airiness of these spherical entities. So when you have the chance to add more bubbles to your Excel bubble chart why not? It actually not that hard to add more more series of data to your chart. But be careful of adding too many series (bubbles), because just like a washing machine overloaded with too much detergent, a bubble chart can be overloaded with too many bubble.

Monday, May 13, 2019

Create a Motion Bubble Chart

If you're familiar with a TED talk given by the late Hans Rosling, you're problem familiar the the cool motion chart he showed with about world development. It had data, it had animation and it had drama! You can replicate the data and animation part (the drama you'll need to provide) in the example of how to create a motion bubble chart from this video.