Wednesday, February 20, 2019

Create a Two Variable Data Table

This video is about creating a two variable data table feature. The use case for this is if you want to input two varying pieces of data and see how the output changes. For example say you are taking out a loan and maybe not sure how much you want to take out. At the same time you are unsure of the rate you might get. What are the possibilities of monthly payments you'll have? It's almost endless! With a two variable data table you can a range of interest rate AND a range of loan amounts and let the handy-dandy data table feature figure out the different monthly payments that are possible. Amazing! See the magic at work in the video.

Tuesday, February 19, 2019

Create a Radar Chart

How to create a radar chart. It is also know as a spider chart or star chart. It is used to display multiple categories of data. I show two examples (1) how to create a filled radar chart and (2) how to create a chart with some target markers or rings.

Monday, February 18, 2019

Create a Checkbook Register in Excel

Are you one of those people who like to balance your checkbook? Do you look forward to getting your bank monthly statement and reconciling it with your checkbook register? You probably want to ditch the register and put this on a spreadsheet. With Excel you can create a basic checkbook register so see this video to learn how to create an online checkbook register using Excel.