The tutor explains the difference between power and exponential curves. According to Excel, a power equation has the form y=axb whereas an exponential equation has the form y=aekx Example: I tried both options on the following data: x y 0.5 …
Spreadsheets: regression curves: power vs exponential Read more →
The tutor shows how to use the logest() function to get an exponential curve from data. Excel’s logest() function returns parameters for the equation y=bm^x, according to data fed for x and y values. Let’s imagine the data is as …
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 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 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 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 →