Overview
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