Create a Checkbook Register in Excel

Are you one of those people who like to balance your checkbook? Do you look forward to getting your bank monthly statement and reconciling it with your checkbook register? You probably want to ditch the register and put this on a spreadsheet. With Excel you can create a basic checkbook register so see this video to learn how to create an online checkbook register using Excel.

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.

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.