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 »
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 »