Extract Text From String With Known Position
You may need to get a part of a text string from within another text string. If you know starting position of the text you...
You may need to get a part of a text string from within another text string. If you know starting position of the text you...
Once in a while you may encounter data in a text form. If you copy this data and paste it directly to Excel, all columns...
In this post, I will show you how to create dynamic charts with Offset Function. You can create super handsome charts once you get a...
Butterfly chart is a very nice visualization technique for comparing two data series side by side. You can easily see how one series do compared...
While surfing the net, I saw a nice interactive donut chart with an equally nice data table beside it. I wondered whether I can do...
This is the first post of a new series I call “Do It in Excel”. I will be recreating data visualizations of several sources in...