The tutor tells how to find the number of a day in the year with Excel or LibreOffice Calc. Today, October 21, 2016, is the 295th day of 2016. How do I know? Here are two ways: Counting the days …

Spreadsheets: which day in the year is this? -Calculated with Excel or LibreOffice Calc Read more »

Tagged with: , , ,

The tutor tells about using the Fill button to extend a number pattern. If you want a really quick way to extend a series of numbers, here’s how in Excel (2007): In adjacent cells, enter the known numbers of the …

Excel: extrapolating (following) a data trend quickly and easily Read more »

Tagged with: ,

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 »

Tagged with: , ,

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 »

Tagged with: ,