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

Formulas and Functions both 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
(retirement date – hire date)/ # of days in a year

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?

Mixed 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.