Главная
Study mode:
on
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
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Business Intelligence #Power Query
0:00 / 0:00
1 of 25

) Introduction