The tutor shows how to get a best-fit line using Excel or LibreOffice Calc. Let’s imagine you want a best fit line of form y=mx + b for the following data: x y 0 3 2 5 6 10 8 …
Spreadsheets: linear regression in four easy steps on Excel or LibreOffice Calc Read more →
The tutor mentions Excel’s convenient conversion utility. I used to wonder, casually, what a nautical mile is compared to an ordinary mile. Not anymore: today I discovered Excel’s convert() formula, which is among the Engineering ones in More Functions, in …
The tutor suggests a possible way to get rid of ######## in cells after inserting a column in Excel. Sometimes, after you shift content by inserting a column at the left, you might find some cells become filled with ##########. …
Excel: getting rid of ######### after inserting a column Read more →
The tutor tells how to have Excel evaluate a determinant for you. Here’s how: Key in your matrix values. Let’s imagine you use the range a1:d4. Select a cell away from the range, let’s say f6. Key in =mdeterm(a1:d4) then …
Spreadsheets: finding the determinant of a matrix using Excel Read more →
The tutor tells how to rotate text in Excel. Excel can rotate text at an arbitrary angle. In Home view, find the button that looks like . Clicking the little down arrow next to it, you’ll see a drop-down menu; …
The tutor tells how to set a border around a selected area in Excel. Here’s how: Select the area around which you want a border, then right click. You’ll see a toolbar and a menu. On the toolbar, find the …
Spreadsheets: How to border a range of cells in Excel Read more →
The tutor shows an example of how to use the yearfrac() function in Excel or LibreOffice Calc. Example: Find the fraction of a year between January 10, 2016, and June 2, 2016. Solution: In Excel or LibreOffice Calc, select a …
Spreadsheets: Calculating fraction of a year: yearfrac() function Read more →
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 →
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 →
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 …
Linear Algebra: solving a three-variable linear system with Excel or LibreOffice Calc Read more →