Search This Blog

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.

Wednesday, May 29, 2019

Show Only a Few Rows or Columns

How to show only a few rows or columns in a worksheet.  Two examples one using the Hide feature (2:19) and the other limiting the scrolling area (4:37).