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.
Tuesday, June 4, 2019
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).
Subscribe to:
Posts (Atom)