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.

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.

Create a Frequency Table and Chart

If you're doing basic statistical analysis you're probably going to come across frequency table or chart. You're basically taking a group of data and putting them into some buckets and comparing them. Excel makes this quite easy with the COUNTIF function and using PivotTables. Check out the video to learn how.