Excel Spreadsheets

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

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

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.