Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 10, 2016
Download Files: https://people.highline.edu/mgirvin/A... In this video learn about: 1. (00:12) Introduction 2. (00:22) Reminder of Date Math and Serial Number Dates and Number Formatting 3. (02:14) TODAY and NOW functions to show the current date and time 4. (03:13) EOMONTH function to get the end of the month date 5. (04:03) EDATE function to get Invoice Due Date (one month ahead) or Pension Vest Date 6. (05:58) DATE function that takes the inputs: year, month and day and then delivers a serial number date. 7. (06:17) YEAR, MONTH and DAY functions to get year, month and day as numbers from a serial number date. 8. (07:43) Year Sales Report with SUMIFS function 9. (08:58) Calculate Month Name with TEXT function and Custom Number formatting 10. (09:51) Calculate Day Name with TEXT function and Custom Number formatting 11. (10:18) Weekday Sales Report with SUMIFS function 12. (11:06) Standard Quarter with ROUNDUP function 13. (13:11) Label for quarter. 14. (13:47) Quarter Sales Report with SUMIFS function 15. (14:17) What is a Fiscal Quarter. 16. (14:46) VLOOKUP Formula for Fiscal Quarter when Jan, Fed, Mar = 4th quarter. 17. (16:45) IF Formula for Fiscal Quarter when Jan, Fed, Mar = 4th quarter. This type of formula will work in Power Pivot Data Model also. 18. (18:51) Calculate Fiscal Year with IF function. 19. (19:42) Label for Fiscal Quarter. This sort of label will sort correct, like when we use this sort of formula in our Power Pivot Data Model and we use our DAX formula in our PivotTable Row area. 20. (20:43) Fiscal Quarter Sales Report with SUMIFS function 21. (21:19) Summary