Monday, April 22, 2019

Add a Watermark in Excel

Do you want to insert some kind of background image to your worksheet? Maybe a picture or some kind of watermark. This video covers how to insert a watermark into an excel worksheet. Two examples are covered, one using WordArt and the other is inserting an image in the header.

Wednesday, April 17, 2019

Remove Unwanted Characters in Excel

This brief video show some example of how to remove unwanted characters or spaces. It gives an overview of the what symbols are in Excel and what to look out for when deleting "spaces".


Tuesday, April 16, 2019

Calculate A Compound Annual Growth Rate (CAGR)

If you're familiar with business metrics or taken a business strategy course, you may have come across CAGR. It's a derived number to is used to average out the growth rate of a product or investment over a span of time. There is actually a formula that you can do by hand to calculate CAGR, but why do that when you have Excel! See the video to learn how to calculate compounded annual growth rate (CAGR) with a formula and ALSO create your own function in Excel.