Excel Basics - Date & Time Number Formatting, Formulas, Functions & Calculations

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn essential Excel skills for date and time formatting, calculations, and functions in this comprehensive 40-minute tutorial. Master keyboard shortcuts, date number formatting, and invoice calculations. Explore the TODAY function, loan maturity dates, and project duration calculations. Discover how to use EDATE and EOMONTH functions for invoice due dates. Tackle time formatting, data entry errors, and hours worked calculations. Utilize the SUM function and Formula Evaluator for complex calculations. Apply your new skills to create a full payroll timesheet template. Access downloadable start and finished files, along with detailed written notes, to enhance your learning experience.

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.