Wednesday, February 13, 2019

Add Error Bars to a Line Chart

If you're charting data and wanting to do some analysis on the variability of the data, you probably want to put some error bars on the line chart. This can be done fairly easily in Excel so check out this video of how to add error bars to a line chart.

Tuesday, February 12, 2019

Use the REPLACE and SUBSTITUTE Functions

If you want to find some values and replace it with other values there are two functions that can help you do this. Similar to the find and replace feature in Excel this uses functions to accomplish it. Learn how to use the REPLACE and SUBSTITUTE functions by checking out the video.

Monday, February 11, 2019

Create a Speedometer Chart

If you like cars and Excel, you might like this video. The speedometer analogy on business dashboards is often used or mis-used. You've got a spectrum where data resides and it gets separated by good, average, and poor areas. If you like the visual appeal of a car dashboard chart on your worksheet see this video to learn how to create a speedometer chart in Excel.