Completed
) Hours Worked or Hours Studied Before and After Lunch Calculation
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Basics - Date & Time Number Formatting, Formulas, Functions & Calculations
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Keyboard to toggle Ribbon Tabs on and off
- 3 ) Date Number Formatting
- 4 ) Number Days Invoice Late Calculation
- 5 ) Keyboard to hard code today’s date in a cell
- 6 ) TODAY Date Function
- 7 ) Loan Maturity Date Calculation
- 8 ) Number Days in Project Calculation
- 9 ) EDATE Function to calculate Invoice Due Date 2 months in the future
- 10 ) EOMONTH Function to calculate Invoice Due Date at the End Of The Month
- 11 ) Number of Days Late for Invoice Template
- 12 ) Time Number Formatting
- 13 ) Date and Time Data Entry Errors that result in Text Values
- 14 ) Keyboard to Apply General Number Formatting (Eraser)
- 15 ) Hours Worked Calculation
- 16 ) Hours Worked or Hours Studied Before and After Lunch Calculation
- 17 ) SUM Function for Hours Worked Before and After Lunch Calculation
- 18 ) Formula Evaluator (Evaluate Formula feature) to see how formula is calculated by Excel
- 19 ) Full Payroll Time Sheet Net Pay Template
- 20 ) Summary - Conclusion
