The tutor shares a nice function that seems to work the same in Excel or LibreOffice Calc. The frequency() function tells, from an array of values and another of categories, the frequency in each category. A potential use is to …

Excel: How to make a graph from data and get an equation, 4 easy steps

The tutor shares quick, easy way to get a graph and equation from Excel, 2007 version. Let’s imagine your x data is in range a1:a10, your y-data, b1:b10. Select a1:b10, then click Insert, then the Scatter icon. Then, in the …

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 …

Excel: getting rid of ######### after inserting a column

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 ##########. …

Spreadsheets: finding the determinant of a matrix using Excel

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 …

Tagged with:

Spreadsheets: How to border a range of cells in Excel

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: Calculating fraction of a year: yearfrac() function

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 …

Tagged with: