Tuesday, June 11, 2019

Use the FIND Function

If you've got heaps of info in your worksheet sometimes it's hard to look for specific info in all those cells.  Luckily Excel has a useful function that can help you perform a search in a cell and better yet use that result in other formulas.  This video covers how to use the FIND function to do that.

Monday, June 10, 2019

Create a 3D Table Cube

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!

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.