Excel Basics - Date & Time Number Formatting, Formulas, Functions & Calculations
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction.
) Keyboard to toggle Ribbon Tabs on and off.
) Date Number Formatting.
) Number Days Invoice Late Calculation.
) Keyboard to hard code today’s date in a cell.
) TODAY Date Function.
) Loan Maturity Date Calculation.
) Number Days in Project Calculation.
) EDATE Function to calculate Invoice Due Date 2 months in the future.
) EOMONTH Function to calculate Invoice Due Date at the End Of The Month.
) Number of Days Late for Invoice Template.
) Time Number Formatting.
) Date and Time Data Entry Errors that result in Text Values.
) Keyboard to Apply General Number Formatting (Eraser).
) Hours Worked Calculation.
) Hours Worked or Hours Studied Before and After Lunch Calculation.
) SUM Function for Hours Worked Before and After Lunch Calculation.
) Formula Evaluator (Evaluate Formula feature) to see how formula is calculated by Excel.
) Full Payroll Time Sheet Net Pay Template.
) Summary - Conclusion.
Taught by
ExcelIsFun