Working With Date And Time Functions: Intermediate Excel

Files:

• 1 - Course Introduction.mp4 (67.7 MB)
• 2 - WATCH ME Essential Information for a Successful Training Experience.mp4 (39.5 MB)
• 3.html (0.8 KB)
• 4.html (0.8 KB)
• 5 - Understanding How Dates are Stored in Excel.mp4 (29.1 MB)
• 6 - Applying Custom Date Formats.mp4 (68.2 MB)
• 7 - Using Date and Time Functions.mp4 (89.5 MB)
• 8 - Using the WORKDAY and WORKDAYINT Functions.mp4 (30.3 MB)
• 9 - Using the NETWORKDAYS and NETWORKDAYSINT Function.mp4 (33.2 MB)
• 10 - Tabulate Date Differences with the DATEDIF Function.mp4 (62.8 MB)
• 11 - Calculate Dates with EDATE and EOMONTH.mp4 (67.2 MB)
• 12 - Exercise.mp4 (41.8 MB)
• 13 - Course Close.mp4 (9.6 MB)
Course Files (Intermediate 1 of 13)
• 02-01-the-golden-rules-of-spreadsheet-design.xlsx (2.6 MB)
• 02-02-cell-styles.xlsx (12.1 KB)
• 02-03-controlling-data-input.xlsx (11.5 KB)
• 02-04-adding-navigation-buttons.xlsx (2.6 MB)
(Intermediate 2 of 13)
• 03-01-logical-functions.xlsx (38.8 KB)
• 03-02-the-if-function.xlsx (64.1 KB)
• 03-03-nested-ifs.xlsx (66.3 KB)
• 03-04-the-IFS-function.xlsx (68.8 KB)
• 03-05-countif-sumif-averageif.xlsx (10.8 KB)
• 03-06-countifs-sumifs-averageifs.xlsx (11.2 KB)
• 03-07-error-handling-ifna-and-iferror.xlsx (82.7 KB)
(Intermediate 3 of 13)
• 04-01-vlookup-exact-match.xlsx (16.0 KB)
• 04-02-vlookup-approx-match.xlsx (10.9 KB)
• 04-03-hlookup.xlsx (11.4 KB)
• 04-04-using-index-match.xlsx (12.8 KB)
• 04-05-using-xlookup-and-xmatch.xlsx (11.9 KB)
• 04-06-the-offset-funtction.xlsx (11.3 KB)
• 04-07-the-indirect-function.xlsx (14.4 KB)
(Intermediate 4 of 13)
• 05-01-sorting-on-multiple-columns.xlsx (12.4 KB)
• 05-02-sorting-using-a-custom-list.xlsx (12.5 KB)
• 05-03-the-sort-and-sortby-functions.xlsx (11.1 KB)
• 05-04-using-the-advanced-filter.xlsx (12.2 KB)
• 05-05-the-unique-function.xlsx (10.1 KB)
• 05-06-the-filter-function.xlsx (13.6 KB)
(Intermediate 5 of 13)
• 06-01-how-dates-and-times-work.xlsx (10.8 KB)
• 06-02-applying-custom-date-formats.xlsx (9.7 KB)
• 06-03-using-date-and-time-functions.xlsx (12.4 KB)
• 06-04-using-the-workdays-function.xlsx (10.4 KB)
• 06-05-using-the-networkdays-function.xlsx (10.9 KB)
• 06-06-dates-difference-with-datediff.xlsx (10.5 KB)
• 06-07-calculate-dates-with-edate-and-eomonth.xlsx (76.4 KB)
(Intermediate 6 of 13)
• 07-02-removing-blank-rows-cells-and-duplicates.xlsx (1.9 MB)
• 07-03-changing-case-and-removing-spaces.xlsx (77.7 KB)
• 07-04-splitting-data-using-text-to-columns.xlsx (76.6 KB)
• 07-05-splitting-data-using-text-functions.xlsx (19.3 KB)
• 07-06-splitting-or-combining-cells-using-flashfill.xlsx (76.8 KB)
• 07-07-joining-data-using-concat-and-textjoin.xlsx (79.6 KB)
• 07-08-formatting-data-as-a-table.xlsx (79.1 KB)
• Sales Data.txt (100.4 KB)
Sales Data
• sales-2016.csv (582.3 KB)
• sales-2017.csv (605.1 KB)
• sales-2018.csv (604.1 KB)
• sales-2019.csv (605.8 KB)
(Intermediate 7 of 13)
• 08-01-pivot-tables-explained.xlsx (78.0 KB)
• 08-02-creating-a-pivot-table-from-scratch.xlsx (79.4 KB)
• 08-03-pivoting-the-fields.xlsx (110.3 KB)
• 08-04-subtotals-and-grandtotals.xlsx (111.3 KB)
• 08-05-number-formatting.xlsx (111.6 KB)
• 08-06-show-values-as-summarize-by.xlsx (111.7 KB)
• 08-07-grouping-pivot-table-data.xlsx (120.5 KB)
• 08-08-formatting-error-values-and-empty-cells.xlsx (120.5 KB)
• 08-09-report-layouts.xlsx (124.1 KB)
• 08-10-applying-pivottable-styles.xlsx (120.6 KB)
(Intermediate 8 of 13)
• 09-01-creating-a-pivot-chart.xlsx (121.0 KB)
• 09-02-formatting-a-pivot-chart-part1.xlsx (120.5 KB)
• 09-03-formatting-a-pivot-chart-part2.xlsx (126.0 KB)
• 09-04-using-map-charts.xlsx (139.4 KB)
(Intermediate 9 of 13)
• 10-01-inserting-and-formatting-slicers.xlsx (7.2 MB)
• 10-02-inserting-timeline-slicers.xlsx (7.2 MB)
• 10-03-report-connections.xlsx (7.2 MB)
• 10-04-updating-pivot-data.xlsx (7.2 MB)
(Intermediate 10 of 13)
• 11-01-what-is-a-dashboard.xlsx (210.8 KB)
• 11-02-assembling-a-dashboard-part-1.xlsx (211.4 KB)
• 11-03-assembling-a-dashboard-part-2.xlsx (123.0 KB)
• 11-04-assembling-a-dashboard-part-3.xlsx (188.8 KB)
(Intermediate 11 of 13)
• 12-01-common-errors.xlsx (11.3 KB)
• 12-02-formula-auditing.xlsx (188.8 KB)
(Intermediate 12 of 13)
• 13-01-data-validation.xlsx (10.6 KB)
• 13-02-other-types-of-data-validation.xlsx (11.0 KB)
• 13-03-custom-validation.xlsx (8.8 KB)
(Intermediate 13 of 13)
• 14-01-loan-payments-with-pmt.xlsx (54.4 KB)
• 14-02-goal-seek.xlsx (36.1 KB)
• 14-03-scenario-manager.xlsx (9.8 KB)
• 14-04-data-tables-one-variable.xlsx (10.9 KB)
• 14-05-data-tables-two-variable.xlsx (9.6 KB)
Exercises Files
• Exercise01 - Solution.xlsx (42.9 KB)
• Exercise01.xlsx (41.3 KB)
• Exercise02 - Solution.xlsx (25.2 KB)
• Exercise02.xlsx (24.6 KB)
• Exercise03 - Solution.xlsx (41.4 KB)
• Exercise03.xlsx (40.0 KB)
• Exercise04 - Solution.xlsx (24.4 KB)
• Exercise04.xlsx (22.8 KB)
• Exercise05 - Solution.xlsx (1.1 MB)
• Exercise05.xlsx (1,011.5 KB)
• Exercise06 - Solution.xlsx (1.3 MB)
• Exercise06.xlsx (1.1 MB)
• Exercise07 - Solution.xlsx (1.3 MB)
• Exercise07.xlsx (1.3 MB)
• Exercise08 - Solution.xlsx (1.6 MB)
• Exercise08.xlsx (1.3 MB)
• Exercise09.xlsx (1.1 MB)
• Exercise10 - Solution.xlsx (631.1 KB)
• Exercise10.xlsx (632.0 KB)
• Exercise11 - Solution.xlsx (628.7 KB)
• Exercise11.xlsx (628.8 KB)
• Exercise12 - Solution.xlsx (2.4 MB)
• Exercise12.xlsx (2.4 MB)