Working with Date and Time Functions Intermediate Excel | 8CEFEF8015028ED5F452417F8E990ACA093F31C7

Working with Date and Time Functions Intermediate Excel

Name	Working with Date and Time Functions Intermediate Excel	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	628.8 MB
Total Files	111
Last Seen	2025-07-18 00:14
Hash	8CEFEF8015028ED5F452417F8E990ACA093F31C7

/1 - Dates and Time/
1 - Course Introduction.mp4	71.0 MB
2 - WATCH ME Essential Information for a Successful Training Experience.mp4	41.4 MB
3.html	0.8 KB
4.html	0.9 KB
5 - Understanding How Dates are Stored in Excel.mp4	30.6 MB
6 - Applying Custom Date Formats.mp4	71.5 MB
7 - Using Date and Time Functions.mp4	93.8 MB
8 - Using the WORKDAY and WORKDAYINT Functions.mp4	31.8 MB
9 - Using the NETWORKDAYS and NETWORKDAYSINT Function.mp4	34.8 MB
10 - Tabulate Date Differences with the DATEDIF Function.mp4	65.9 MB
11 - Calculate Dates with EDATE and EOMONTH.mp4	70.5 MB
12 - Exercise.mp4	43.9 MB
13 - Course Close.mp4	10.1 MB
/.../(Intermediate 1 of 13)/
02-01-the-golden-rules-of-spreadsheet-design.xlsx	2.8 MB
02-02-cell-styles.xlsx	12.4 KB
02-03-controlling-data-input.xlsx	11.8 KB
02-04-adding-navigation-buttons.xlsx	2.8 MB
/.../(Intermediate 2 of 13)/
03-01-logical-functions.xlsx	39.7 KB
03-02-the-if-function.xlsx	65.6 KB
03-03-nested-ifs.xlsx	67.8 KB
03-04-the-IFS-function.xlsx	70.4 KB
03-05-countif-sumif-averageif.xlsx	11.1 KB
03-06-countifs-sumifs-averageifs.xlsx	11.4 KB
03-07-error-handling-ifna-and-iferror.xlsx	84.7 KB
/.../(Intermediate 3 of 13)/
04-01-vlookup-exact-match.xlsx	16.4 KB
04-02-vlookup-approx-match.xlsx	11.2 KB
04-03-hlookup.xlsx	11.7 KB
04-04-using-index-match.xlsx	13.1 KB
04-05-using-xlookup-and-xmatch.xlsx	12.2 KB
04-06-the-offset-funtction.xlsx	11.6 KB
04-07-the-indirect-function.xlsx	14.7 KB
/.../(Intermediate 4 of 13)/
05-01-sorting-on-multiple-columns.xlsx	12.7 KB
05-02-sorting-using-a-custom-list.xlsx	12.8 KB
05-03-the-sort-and-sortby-functions.xlsx	11.3 KB
05-04-using-the-advanced-filter.xlsx	12.5 KB
05-05-the-unique-function.xlsx	10.3 KB
05-06-the-filter-function.xlsx	13.9 KB
/.../(Intermediate 5 of 13)/
06-01-how-dates-and-times-work.xlsx	11.0 KB
06-02-applying-custom-date-formats.xlsx	9.9 KB
06-03-using-date-and-time-functions.xlsx	12.7 KB
06-04-using-the-workdays-function.xlsx	10.7 KB
06-05-using-the-networkdays-function.xlsx	11.1 KB
06-06-dates-difference-with-datediff.xlsx	10.8 KB
06-07-calculate-dates-with-edate-and-eomonth.xlsx	78.3 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	79.6 KB
07-04-splitting-data-using-text-to-columns.xlsx	78.4 KB
07-05-splitting-data-using-text-functions.xlsx	19.7 KB
07-06-splitting-or-combining-cells-using-flashfill.xlsx	78.6 KB
07-07-joining-data-using-concat-and-textjoin.xlsx	81.5 KB
07-08-formatting-data-as-a-table.xlsx	81.0 KB
Sales Data.txt	102.8 KB
/.../(Intermediate 6 of 13)/Sales Data/
sales-2016.csv	596.3 KB
sales-2017.csv	619.6 KB
sales-2018.csv	618.6 KB
sales-2019.csv	620.4 KB
/.../(Intermediate 7 of 13)/
08-01-pivot-tables-explained.xlsx	79.9 KB
08-02-creating-a-pivot-table-from-scratch.xlsx	81.3 KB
08-03-pivoting-the-fields.xlsx	112.9 KB
08-04-subtotals-and-grandtotals.xlsx	114.0 KB
08-05-number-formatting.xlsx	114.2 KB
08-06-show-values-as-summarize-by.xlsx	114.4 KB
08-07-grouping-pivot-table-data.xlsx	123.4 KB
08-08-formatting-error-values-and-empty-cells.xlsx	123.4 KB
08-09-report-layouts.xlsx	127.1 KB
08-10-applying-pivottable-styles.xlsx	123.5 KB
/.../(Intermediate 8 of 13)/
09-01-creating-a-pivot-chart.xlsx	123.9 KB
09-02-formatting-a-pivot-chart-part1.xlsx	123.4 KB
09-03-formatting-a-pivot-chart-part2.xlsx	129.0 KB
09-04-using-map-charts.xlsx	142.8 KB
/.../(Intermediate 9 of 13)/
10-01-inserting-and-formatting-slicers.xlsx	7.6 MB
10-02-inserting-timeline-slicers.xlsx	7.6 MB
10-03-report-connections.xlsx	7.6 MB
10-04-updating-pivot-data.xlsx	7.6 MB
/.../(Intermediate 10 of 13)/
11-01-what-is-a-dashboard.xlsx	215.9 KB
11-02-assembling-a-dashboard-part-1.xlsx	216.5 KB
11-03-assembling-a-dashboard-part-2.xlsx	125.9 KB
11-04-assembling-a-dashboard-part-3.xlsx	193.3 KB
/.../(Intermediate 11 of 13)/
12-01-common-errors.xlsx	11.5 KB
12-02-formula-auditing.xlsx	193.3 KB
/.../(Intermediate 12 of 13)/
13-01-data-validation.xlsx	10.8 KB
13-02-other-types-of-data-validation.xlsx	11.3 KB
13-03-custom-validation.xlsx	9.1 KB
/.../(Intermediate 13 of 13)/
14-01-loan-payments-with-pmt.xlsx	55.7 KB
14-02-goal-seek.xlsx	36.9 KB
14-03-scenario-manager.xlsx	10.1 KB
14-04-data-tables-one-variable.xlsx	11.2 KB
14-05-data-tables-two-variable.xlsx	9.8 KB
/Exercises Files/
Exercise01 - Solution.xlsx	43.9 KB
Exercise01.xlsx	42.3 KB
Exercise02 - Solution.xlsx	25.8 KB
Exercise02.xlsx	25.2 KB
Exercise03 - Solution.xlsx	42.4 KB
Exercise03.xlsx	41.0 KB
Exercise04 - Solution.xlsx	24.9 KB
Exercise04.xlsx	23.3 KB
Exercise05 - Solution.xlsx	1.1 MB
Exercise05.xlsx	1.0 MB
Exercise06 - Solution.xlsx	1.3 MB
Exercise06.xlsx	1.1 MB
Exercise07 - Solution.xlsx	1.4 MB
Exercise07.xlsx	1.4 MB
Exercise08 - Solution.xlsx	1.6 MB
Exercise08.xlsx	1.3 MB
Exercise09.xlsx	1.1 MB
Exercise10 - Solution.xlsx	646.2 KB
Exercise10.xlsx	647.2 KB
Exercise11 - Solution.xlsx	643.8 KB
Exercise11.xlsx	643.9 KB
Exercise12 - Solution.xlsx	2.6 MB
Exercise12.xlsx	2.5 MB
Total files 111