Excel sure gives you many ways to present data in a visual format. Sure there are different graphs like line charts or bar charts, but what about a cube? Although not always practical, this is more of a novel way to capture your audience for an initial reaction to data. Check out this video on how to create a 3D Table Cube.
P.S. Feel free to provide a comment or share it with a friend!
Monday, June 10, 2019
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.
Subscribe to:
Posts (Atom)