Other
Working with Date and Time Functions Intermediate Excel
Torrent info
Torrent Files List
1 - Dates and Time (Size: 599.63 MB) (Files: 111)
1 - Dates and Time
1 - Course Introduction.mp4
2 - WATCH ME Essential Information for a Successful Training Experience.mp4
3.html
4.html
5 - Understanding How Dates are Stored in Excel.mp4
6 - Applying Custom Date Formats.mp4
7 - Using Date and Time Functions.mp4
8 - Using the WORKDAY and WORKDAYINT Functions.mp4
9 - Using the NETWORKDAYS and NETWORKDAYSINT Function.mp4
10 - Tabulate Date Differences with the DATEDIF Function.mp4
11 - Calculate Dates with EDATE and EOMONTH.mp4
12 - Exercise.mp4
13 - Course Close.mp4
Course Files
(Intermediate 1 of 13)
02-01-the-golden-rules-of-spreadsheet-design.xlsx
02-02-cell-styles.xlsx
02-03-controlling-data-input.xlsx
02-04-adding-navigation-buttons.xlsx
(Intermediate 2 of 13)
03-01-logical-functions.xlsx
03-02-the-if-function.xlsx
03-03-nested-ifs.xlsx
03-04-the-IFS-function.xlsx
03-05-countif-sumif-averageif.xlsx
03-06-countifs-sumifs-averageifs.xlsx
03-07-error-handling-ifna-and-iferror.xlsx
(Intermediate 3 of 13)
04-01-vlookup-exact-match.xlsx
04-02-vlookup-approx-match.xlsx
04-03-hlookup.xlsx
04-04-using-index-match.xlsx
04-05-using-xlookup-and-xmatch.xlsx
04-06-the-offset-funtction.xlsx
04-07-the-indirect-function.xlsx
(Intermediate 4 of 13)
05-01-sorting-on-multiple-columns.xlsx
05-02-sorting-using-a-custom-list.xlsx
05-03-the-sort-and-sortby-functions.xlsx
05-04-using-the-advanced-filter.xlsx
05-05-the-unique-function.xlsx
05-06-the-filter-function.xlsx
(Intermediate 5 of 13)
06-01-how-dates-and-times-work.xlsx
06-02-applying-custom-date-formats.xlsx
06-03-using-date-and-time-functions.xlsx
06-04-using-the-workdays-function.xlsx
06-05-using-the-networkdays-function.xlsx
06-06-dates-difference-with-datediff.xlsx
06-07-calculate-dates-with-edate-and-eomonth.xlsx
(Intermediate 6 of 13)
07-02-removing-blank-rows-cells-and-duplicates.xlsx
07-03-changing-case-and-removing-spaces.xlsx
07-04-splitting-data-using-text-to-columns.xlsx
07-05-splitting-data-using-text-functions.xlsx
07-06-splitting-or-combining-cells-using-flashfill.xlsx
07-07-joining-data-using-concat-and-textjoin.xlsx
07-08-formatting-data-as-a-table.xlsx
Sales Data.txt
Sales Data
sales-2016.csv
sales-2017.csv
sales-2018.csv
sales-2019.csv
(Intermediate 7 of 13)
08-01-pivot-tables-explained.xlsx
08-02-creating-a-pivot-table-from-scratch.xlsx
08-03-pivoting-the-fields.xlsx
08-04-subtotals-and-grandtotals.xlsx
08-05-number-formatting.xlsx
08-06-show-values-as-summarize-by.xlsx
08-07-grouping-pivot-table-data.xlsx
08-08-formatting-error-values-and-empty-cells.xlsx
08-09-report-layouts.xlsx
08-10-applying-pivottable-styles.xlsx
(Intermediate 8 of 13)
09-01-creating-a-pivot-chart.xlsx
09-02-formatting-a-pivot-chart-part1.xlsx
09-03-formatting-a-pivot-chart-part2.xlsx
09-04-using-map-charts.xlsx
(Intermediate 9 of 13)
10-01-inserting-and-formatting-slicers.xlsx
10-02-inserting-timeline-slicers.xlsx
10-03-report-connections.xlsx
10-04-updating-pivot-data.xlsx
(Intermediate 10 of 13)
11-01-what-is-a-dashboard.xlsx
11-02-assembling-a-dashboard-part-1.xlsx
11-03-assembling-a-dashboard-part-2.xlsx
11-04-assembling-a-dashboard-part-3.xlsx
(Intermediate 11 of 13)
12-01-common-errors.xlsx
12-02-formula-auditing.xlsx
(Intermediate 12 of 13)
13-01-data-validation.xlsx
13-02-other-types-of-data-validation.xlsx
13-03-custom-validation.xlsx
(Intermediate 13 of 13)
14-01-loan-payments-with-pmt.xlsx
14-02-goal-seek.xlsx
14-03-scenario-manager.xlsx
14-04-data-tables-one-variable.xlsx
14-05-data-tables-two-variable.xlsx
Exercises Files
Exercise01 - Solution.xlsx
Exercise01.xlsx
Exercise02 - Solution.xlsx
Exercise02.xlsx
Exercise03 - Solution.xlsx
Exercise03.xlsx
Exercise04 - Solution.xlsx
Exercise04.xlsx
Exercise05 - Solution.xlsx
Exercise05.xlsx
Exercise06 - Solution.xlsx
Exercise06.xlsx
Exercise07 - Solution.xlsx
Exercise07.xlsx
Exercise08 - Solution.xlsx
Exercise08.xlsx
Exercise09.xlsx
Exercise10 - Solution.xlsx
Exercise10.xlsx
Exercise11 - Solution.xlsx
Exercise11.xlsx
Exercise12 - Solution.xlsx
Exercise12.xlsx
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch Working with Date and Time Functions Intermediate Excel Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
