Completed
) Fundamentals of how Time Values and Time Number Formatting work in Excel, Power Query and the Data Model
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Date & Time Formulas & Functions in Excel Worksheet and Power Query
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Fundamentals of how Date Values work in Excel, Power Query and the Data Model
- 3 ) How Date Number Formatting Works
- 4 ) Date Formulas to calculate the difference between two dates
- 5 ) Count Workdays. NETWORKDAY.INTL function
- 6 ) Add or subtract days to get a future date. WORKDAY.INTL function
- 7 ) Month Date calculations such as determining date by adding or subtracting months with EDATE function or determining end of month by using EOMONTH function
- 8 ) Fundamentals of how Time Values and Time Number Formatting work in Excel, Power Query and the Data Model
- 9 ) Enter Date-Time Values
- 10 ) Time formulas to calculate the number of hours worked
- 11 ) Formulas for Working Night Shift, including Logical Formula, IF function and MOD function
- 12 ) Evaluate Formula Tool
- 13 ) Round time values to nearest five minutes. MROUND function
- 14 ) Create Date Attribute Fields to a table using Worksheet formulas and functions
- 15 ) Using TEXT function to add Month Name and Day Name Attribute Fields
- 16 ) Using ROUNDUP function to create Standard Quarter Attribute Field
- 17 ) Using IF function to create Fiscal Quarter Attribute Field
- 18 ) Using IF function to create Fiscal Year Attribute Field
- 19 ) The Importance of Date and Time Attribute Fields
- 20 ) 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
- 21 ) if function in Power Query. Learn how to use the Conditional Column feature in Power Query to create Fiscal Quarter and Year Fields
- 22 ) Use Add Column Merge Columns feature to create Fiscal Period Field.
- 23 ) Load fact table with Date Attribute Fields to PivotTable Cache.
- 24 ) Conclusion
- 25 ) Closing and Video Links
