The tutor explains how to make a loan payment table. Example: Make a table to show the retirement of a $5000 loan, at 5.99% compounded monthly, with monthly payments of $221.58. The loan will be retired in 24 payments. (Note …
Spreadsheets: how to make an amortization table in Excel or LibreOffice Calc Read more »
The tutor explains how, on Excel, to make a grid useful for displaying a graph. In these days of software availability, one would expect making squares on a page to be obvious. Here’s the easiest way I know: In Excel, …
Microsoft Excel: how to make a square grid for graphing Read more »
The tutor explains the use of Excel’s built-in function to calculate the number of work days between two dates. Excel’s networkdays() function is located in the Formulas tab by clicking the Date & Time icon. It calculates the number of …
The tutor shares a find from today’s Excel session. I use Excel for very specific purposes, mainly programming and such. There are common skills I’m only now accumulating. Today, from Microsoft, I learned that the Select All button is the …
The tutor opens the discussion about how to display, automatically, a cell’s content according to its value. What if, in Excel, you want to display any value between 78 and 93 in green? Well, you can, using conditional formatting. On …