Wednesday, June 5, 2019

Create a Date Based Axis or Text Based Axis Line Chart

When you create a chart, there are usually many option you have to fine tune the way information is show.  One of those ways is on the axis.  This video will show you how to create a chart with the horizontal axis based on either a date or text axis type.

Tuesday, June 4, 2019

Copy and Paste Only Visible Cells

This video covers how to copy and paste visible cells.  There are times when you hide a column or row, make a selection to copy and then paste to a target cell. The expectation is that the visible cells are the only one pasted at the target area.  Unfortunately that didn't happen.  I covered how to workaround that with selecting only the visible cells with two examples.

Monday, June 3, 2019

Use the TREND Function to Predict Sales Growth

This video show you how to use the TREND function to predict future monthly sales (from one to multiple months) based on historical values. Use this Excel statistical function to help you forecast your sales and potential revenues for products or services.