Monday, February 25, 2019
Create Angled or Slanted Text and Borders
How to create slanted, angled or sideways text in Excel. The example show a 45 degree orientation for headings. There are also other ways to rotate the text such as vertically. The video finished with formatting such as adding borders that are also angled.
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.
Subscribe to:
Posts (Atom)