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