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 tells the quick way to convert the accumulated balance after regular deposits between “beginning” vs “end of month” payments. In a previous post I tell how to find the end balance of an account after five years of …
The tutor shows how to find the balance of a savings account after monthly deposits over a period of years, using the Texas Instruments BA-35. Example: $100 is deposited into a savings account each month for five years. If the …
Financial calculators: TI BA-35: finding account balance after regular deposits Read more »
The tutor tells how to accomplish text rotation with LibreOffice Calc. Here’s how: Type the text in a cell. With that cell selected, go to the top and click the Format heading. In the drop-down menu, click Cells… You’ll see …
Spreadsheets: how to rotate text in LibreOffice Calc 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 explains how to set a border around a range of cells in LibreOffice Calc. Here’s what to do: Select the area around which you want a border. Find the icon that’s a square divided in four; it’s perhaps …
Spreadsheets: How to border a selection in LibreOffice Calc 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 »