Local Support with Excel Spreadsheets: The Power of Excel
A spreadsheet is little more than columns and rows, comprised of lists and lists. The real power in Excel spreadsheets is when you use Formulas and/or Functions.
Formulas and Functions aren’t the same
Contact us using the form below or give us a call if you want some help making sense of the difference.
- Formulas are essentially calculations you build using cell references and mathematical operators.
- Basically mathematical equations.
- e.g. The value of one cell added to another cell (or cells). =C5+C6+C7
- Functions are Excel spreadsheets built-in calculations that Excel understands
- e.g. Sum the entire range of the row =SUM(C5:C7)
⇒ IF, IFS, IFERROR, ⇒ SUM, SUMIF, SUMIFS,
⇒ COUNT, COUNTIF, COUNTIFS
⇒ VLOOKUP ⇒ INT, ROUND ⇒ LEFT, RIGHT
Of the over 450 Functions (available in Excel 2016), all Functions start with an equal sign ( = ), followed by the name of the function, and then in parenthesis, Arguments which cells are used to calculate the Function.
Which Functions do you use or need help with?
Contact us below and ask about personalized training in Excel. We also have a few posts about using Excel, including posts on absolute vs relative references, using proper Order of Operations, and grouping dates in PivotTables.