Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Date & Time Formulas & Functions in Excel Worksheet and Power Query

ExcelIsFun via YouTube

Overview

Dive into a comprehensive 51-minute video tutorial on Date & Time Formulas & Functions in Excel Worksheet and Power Query. Learn the fundamentals of date and time values, number formatting, and various calculations. Master essential functions like NETWORKDAY.INTL, WORKDAY.INTL, EDATE, EOMONTH, and MROUND. Explore techniques for creating date attribute fields using worksheet formulas and Power Query. Discover how to handle night shift calculations, round time values, and create fiscal period fields. Gain insights into the importance of date and time attribute fields and their application in PivotTables. Access downloadable Excel files and PDF notes to enhance your learning experience.

Syllabus

) Introduction.
) Fundamentals of how Date Values work in Excel, Power Query and the Data Model.
) How Date Number Formatting Works.
) Date Formulas to calculate the difference between two dates.
) Count Workdays. NETWORKDAY.INTL function.
) Add or subtract days to get a future date. WORKDAY.INTL function.
) Month Date calculations such as determining date by adding or subtracting months with EDATE function or determining end of month by using EOMONTH function.
) Fundamentals of how Time Values and Time Number Formatting work in Excel, Power Query and the Data Model.
) Enter Date-Time Values.
) Time formulas to calculate the number of hours worked.
) Formulas for Working Night Shift, including Logical Formula, IF function and MOD function.
) Evaluate Formula Tool.
) Round time values to nearest five minutes. MROUND function.
) Create Date Attribute Fields to a table using Worksheet formulas and functions.
) Using TEXT function to add Month Name and Day Name Attribute Fields.
) Using ROUNDUP function to create Standard Quarter Attribute Field.
) Using IF function to create Fiscal Quarter Attribute Field.
) Using IF function to create Fiscal Year Attribute Field.
) The Importance of Date and Time Attribute Fields.
) Create Date Attribute Fields to a table using Power Query formulas and functions. Create Attribute Fields such as Month Name, Fiscal Quarter and Fiscal Year.
) if function in Power Query. Learn how to use the Conditional Column feature in Power Query to create Fiscal Quarter and Year Fields.
) Use Add Column Merge Columns feature to create Fiscal Period Field..
) Load fact table with Date Attribute Fields to PivotTable Cache..
) Conclusion.
) Closing and Video Links.

Taught by

ExcelIsFun

Reviews

Start your review of Date & Time Formulas & Functions in Excel Worksheet and Power Query

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.