Excel Spreadsheets

Local Support with Excel Spreadsheets: The Power of Excel

Did you know 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

You can contact us using the form below. Or give us a call (or text) if you want some help making sense of the difference.

You’ll use Formulas and Functions both to enable Excel to come up with the answers you need.

Formulas

Using an equal sign (=) and cell references or values, you’ll build the equation yourself.

Excel Spreadsheet Formulas

Functions

⇒ 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? Excel Spreadsheet IF Function

Mixed VLOOKUP excel spreadsheets

excel spreadsheets

VLOOKUP excel spreadsheets

You can contact us below and arrange personalized training in Excel. You’ll find a few posts about using Excel. Learn about absolute vs relative references, using proper Order of Operations, and grouping dates in PivotTables.