| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/1 - Course Introduction.mp4 |
67.7 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/2 - WATCH ME Essential Information for a Successful Training Experience.mp4 |
39.5 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/3.html |
840 B |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/4.html |
861 B |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/5 - Understanding How Dates are Stored in Excel.mp4 |
29.1 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/6 - Applying Custom Date Formats.mp4 |
68.2 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/7 - Using Date and Time Functions.mp4 |
89.5 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/8 - Using the WORKDAY and WORKDAYINT Functions.mp4 |
30.3 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/9 - Using the NETWORKDAYS and NETWORKDAYSINT Function.mp4 |
33.2 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/10 - Tabulate Date Differences with the DATEDIF Function.mp4 |
62.8 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/11 - Calculate Dates with EDATE and EOMONTH.mp4 |
67.2 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/12 - Exercise.mp4 |
41.8 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/13 - Course Close.mp4 |
9.6 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 1 of 13)/02-01-the-golden-rules-of-spreadsheet-design.xlsx |
2.6 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 1 of 13)/02-02-cell-styles.xlsx |
12 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 1 of 13)/02-03-controlling-data-input.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 1 of 13)/02-04-adding-navigation-buttons.xlsx |
2.6 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 2 of 13)/03-01-logical-functions.xlsx |
39 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 2 of 13)/03-02-the-if-function.xlsx |
64 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 2 of 13)/03-03-nested-ifs.xlsx |
66 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 2 of 13)/03-04-the-IFS-function.xlsx |
69 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 2 of 13)/03-05-countif-sumif-averageif.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 2 of 13)/03-06-countifs-sumifs-averageifs.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 2 of 13)/03-07-error-handling-ifna-and-iferror.xlsx |
83 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 3 of 13)/04-01-vlookup-exact-match.xlsx |
16 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 3 of 13)/04-02-vlookup-approx-match.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 3 of 13)/04-03-hlookup.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 3 of 13)/04-04-using-index-match.xlsx |
13 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 3 of 13)/04-05-using-xlookup-and-xmatch.xlsx |
12 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 3 of 13)/04-06-the-offset-funtction.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 3 of 13)/04-07-the-indirect-function.xlsx |
14 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 4 of 13)/05-01-sorting-on-multiple-columns.xlsx |
12 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 4 of 13)/05-02-sorting-using-a-custom-list.xlsx |
12 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 4 of 13)/05-03-the-sort-and-sortby-functions.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 4 of 13)/05-04-using-the-advanced-filter.xlsx |
12 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 4 of 13)/05-05-the-unique-function.xlsx |
10 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 4 of 13)/05-06-the-filter-function.xlsx |
14 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 5 of 13)/06-01-how-dates-and-times-work.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 5 of 13)/06-02-applying-custom-date-formats.xlsx |
10 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 5 of 13)/06-03-using-date-and-time-functions.xlsx |
12 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 5 of 13)/06-04-using-the-workdays-function.xlsx |
10 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 5 of 13)/06-05-using-the-networkdays-function.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 5 of 13)/06-06-dates-difference-with-datediff.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 5 of 13)/06-07-calculate-dates-with-edate-and-eomonth.xlsx |
76 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/07-02-removing-blank-rows-cells-and-duplicates.xlsx |
1.9 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/07-03-changing-case-and-removing-spaces.xlsx |
78 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/07-04-splitting-data-using-text-to-columns.xlsx |
77 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/07-05-splitting-data-using-text-functions.xlsx |
19 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/07-06-splitting-or-combining-cells-using-flashfill.xlsx |
77 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/07-07-joining-data-using-concat-and-textjoin.xlsx |
80 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/07-08-formatting-data-as-a-table.xlsx |
79 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/Sales Data.txt |
100 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/Sales Data/sales-2016.csv |
582 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/Sales Data/sales-2017.csv |
605 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/Sales Data/sales-2018.csv |
604 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 6 of 13)/Sales Data/sales-2019.csv |
606 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 7 of 13)/08-01-pivot-tables-explained.xlsx |
78 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 7 of 13)/08-02-creating-a-pivot-table-from-scratch.xlsx |
79 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 7 of 13)/08-03-pivoting-the-fields.xlsx |
110 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 7 of 13)/08-04-subtotals-and-grandtotals.xlsx |
111 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 7 of 13)/08-05-number-formatting.xlsx |
112 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 7 of 13)/08-06-show-values-as-summarize-by.xlsx |
112 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 7 of 13)/08-07-grouping-pivot-table-data.xlsx |
121 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 7 of 13)/08-08-formatting-error-values-and-empty-cells.xlsx |
121 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 7 of 13)/08-09-report-layouts.xlsx |
124 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 7 of 13)/08-10-applying-pivottable-styles.xlsx |
121 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 8 of 13)/09-01-creating-a-pivot-chart.xlsx |
121 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 8 of 13)/09-02-formatting-a-pivot-chart-part1.xlsx |
120 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 8 of 13)/09-03-formatting-a-pivot-chart-part2.xlsx |
126 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 8 of 13)/09-04-using-map-charts.xlsx |
139 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 9 of 13)/10-01-inserting-and-formatting-slicers.xlsx |
7.2 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 9 of 13)/10-02-inserting-timeline-slicers.xlsx |
7.2 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 9 of 13)/10-03-report-connections.xlsx |
7.2 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 9 of 13)/10-04-updating-pivot-data.xlsx |
7.2 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 10 of 13)/11-01-what-is-a-dashboard.xlsx |
211 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 10 of 13)/11-02-assembling-a-dashboard-part-1.xlsx |
211 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 10 of 13)/11-03-assembling-a-dashboard-part-2.xlsx |
123 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 10 of 13)/11-04-assembling-a-dashboard-part-3.xlsx |
189 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 11 of 13)/12-01-common-errors.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 11 of 13)/12-02-formula-auditing.xlsx |
189 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 12 of 13)/13-01-data-validation.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 12 of 13)/13-02-other-types-of-data-validation.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 12 of 13)/13-03-custom-validation.xlsx |
9 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 13 of 13)/14-01-loan-payments-with-pmt.xlsx |
54 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 13 of 13)/14-02-goal-seek.xlsx |
36 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 13 of 13)/14-03-scenario-manager.xlsx |
10 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 13 of 13)/14-04-data-tables-one-variable.xlsx |
11 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Course Files/(Intermediate 13 of 13)/14-05-data-tables-two-variable.xlsx |
10 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise01 - Solution.xlsx |
43 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise01.xlsx |
41 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise02 - Solution.xlsx |
25 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise02.xlsx |
25 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise03 - Solution.xlsx |
41 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise03.xlsx |
40 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise04 - Solution.xlsx |
24 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise04.xlsx |
23 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise05 - Solution.xlsx |
1.1 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise05.xlsx |
1011 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise06 - Solution.xlsx |
1.3 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise06.xlsx |
1.1 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise07 - Solution.xlsx |
1.3 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise07.xlsx |
1.3 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise08 - Solution.xlsx |
1.6 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise08.xlsx |
1.3 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise09.xlsx |
1.1 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise10 - Solution.xlsx |
631 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise10.xlsx |
632 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise11 - Solution.xlsx |
629 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise11.xlsx |
629 KB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise12 - Solution.xlsx |
2.4 MB |
| Working with Date and Time Functions Intermediate Excel/1 - Dates and Time/Exercises Files/Exercise12.xlsx |
2.4 MB |