Completed
) Introduction
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
