Spreadsheets: Excel or LibreOffice Calc: sumif(), continued
Tutoring spreadsheets, here’s the next level of complexity with the sumif() function: a separate test range. …
Spreadsheets: Excel or LibreOffice Calc: sumif(), continued Read more →
spreadsheets
Spreadsheets: Excel or LibreOffice Calc: sumif()
The tutor shows the neat function sumif() found on Excel and also on LibreOffice Calc. At …
Spreadsheets: Excel or LibreOffice Calc: sumif() Read more →
Spreadsheets: how to reference a cell on a different sheet in Excel and in LibreOffice Calc
Tutoring spreadsheet usage, cell references are important. Let’s imagine you want a1 in the first sheet …
Spreadsheets: Excel, LibreOffice Calc: number formatting: how to get rid of E-05 (for example)
The tutor explains how to change from scientific notation to regular number format in Excel or …
Spreadsheets: how to use Excel to solve an equation
The tutor gives an example of using Excel’s Goal Seek. Example: Solve lnx + 15= 0.25x …
Spreadsheets: how to use Excel to solve an equation Read more →
Spreadsheets: Excel and LibreOffice Calc: the sum of a geometric series
The tutor shows the seriessum() function, found on both Excel and LibreOffice Calc. A geometric series …
Spreadsheets: Excel and LibreOffice Calc: the sum of a geometric series Read more →
Spreadsheets: logarithms: logs in other bases
The tutor shows the log() function on Excel and LibreOffice Calc. Pretty much every scientific calculator …
Statistics: Spreadsheets: the frequency() function
The tutor shares a nice function that seems to work the same in Excel or LibreOffice …
Statistics: Spreadsheets: the frequency() function Read more →
Spreadsheets: LibreOffice Calc: how to get a graph and equation from data
The tutor shows how to get a graph and equation for data using LibreOffice Calc, in …
Spreadsheets: LibreOffice Calc: how to get a graph and equation from data Read more →
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. …
Excel: How to make a graph from data and get an equation, 4 easy steps Read more →