Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics

Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics

ExcelIsFun via YouTube Direct link

min) Excel's Golden Rule.

1 of 15

1 of 15

min) Excel's Golden Rule.

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics

Automatically move to the next video in the Classroom when playback concludes

  1. 1 min) Excel's Golden Rule.
  2. 2 min) Formula Elements.
  3. 3 min) Math Operators.
  4. 4 min) Comparative Operators.
  5. 5 min) Types of Formulas.
  6. 6 min) How Formulas Calculate: Order of Precedence in Excel.
  7. 7 min)Number Formatting is a Façade.
  8. 8 min) Default Alignment in Excel.
  9. 9 min)16 formula examples of formula elements and formula types.
  10. 10 min) LARGE and ROWS functions and 'expandable range' to extract Top .
  11. 11 min) SMALL and COLUMNS functions and 'expandable range' to extract bottom 3.
  12. 12 min) AGGREGATE and ROWS functions and 'expandable range' to extract bottom 3.
  13. 13 min) 10 Examples of INDEX and MATCH functions.
  14. 14 min) SUMIFS to add with two criteria.
  15. 15 min) Advantage of formulas over other Excel features such as Filter and PivotTables.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.