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

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 …

## Linear Algebra: solving a three-variable linear system with Excel or LibreOffice Calc

The tutor shows an example of how to solve a system of three equations using a spreadsheet. Example: solve the system -3x + 2y + z = 16 x – y – 3z = -19 2x + y + 7z …

## Spreadsheets: how to make an amortization table in Excel or LibreOffice Calc

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 …

## Microsoft Excel: how to make a square grid for graphing

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, …

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 …

Tagged with: