Excel Worksheet Formulas & Models – Everything You Ever Wanted to Know

Excel Worksheet Formulas & Models – Everything You Ever Wanted to Know

ExcelIsFun via YouTube Direct link

) Build Model #3: Date & Time Formulas & Number Formatting to calculate total days and total time for a work project

19 of 25

19 of 25

) Build Model #3: Date & Time Formulas & Number Formatting to calculate total days and total time for a work project

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Worksheet Formulas & Models – Everything You Ever Wanted to Know

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

  1. 1 ) Introduction
  2. 2 ) List of Formula Elements
  3. 3 ) Discuss Different Formula Types
  4. 4 ) Examples of Modes of Formula Editing
  5. 5 ) Examples of the five Calculation Formula Types
  6. 6 ) Type #1: Relative and Absolute Cell References in Single Input-Output Formula
  7. 7 ) When you must use ROUND function
  8. 8 ) Use General Number Format as eraser to remove Number Formatting
  9. 9 ) Type #2: Dynamic Spilled Array Formulas
  10. 10 ) Spilled Range Operator for Dynamic Spilled Array Formulas
  11. 11 ) Type #3: Excel Table Formulas
  12. 12 ) Summary about SIOF, DSAF and TF formulas.
  13. 13 ) Type #5: Aggregate Formulas
  14. 14 ) Type #4: Scalar Array Formulas
  15. 15 ) Style Formatting for Models
  16. 16 ) Compare Number Formats: Accounting, Currency and Number
  17. 17 ) Build Model #1: Sales & Expenses Budget
  18. 18 ) Build Model #2: Markup On Cost Pricing Formulas
  19. 19 ) Build Model #3: Date & Time Formulas & Number Formatting to calculate total days and total time for a work project
  20. 20 ) Build Model #4: Largest Profit for Each Product. Learn about functions: UNIQUE, SORT and MAXIFS
  21. 21 ) Look at Finance Cashflow Model to help pick investment
  22. 22 ) Look at Analytics Simulation Model to product risk of new project
  23. 23 ) Homework or practice problems
  24. 24 ) Conclusion
  25. 25 ) Closing and Video Links

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.