| 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 | ||
| 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 | ||
| 04-01-vlookup-exact-match.xlsx | 16 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 08-01-pivot-tables-explained.xlsx | 78 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 | ||
| 09-01-creating-a-pivot-chart.xlsx | 121 KB | ||
| 09-02-formatting-a-pivot-chart-part1.xlsx | 120.5 KB | ||
| 09-03-formatting-a-pivot-chart-part2.xlsx | 126 KB | ||
| 09-04-using-map-charts.xlsx | 139.4 KB | ||
| 1 - Course Introduction.mp4 | 67.7 MB | ||
| 10 - Tabulate Date Differences with the DATEDIF Function.mp4 | 62.8 MB | ||
| 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 | ||
| 11 - Calculate Dates with EDATE and EOMONTH.mp4 | 67.2 MB | ||
| 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 KB | ||
| 11-04-assembling-a-dashboard-part-3.xlsx | 188.8 KB | ||
| 12 - Exercise.mp4 | 41.8 MB | ||
| 12-01-common-errors.xlsx | 11.3 KB | ||
| 12-02-formula-auditing.xlsx | 188.8 KB | ||
| 13 - Course Close.mp4 | 9.6 MB | ||
| 13-01-data-validation.xlsx | 10.6 KB | ||
| 13-02-other-types-of-data-validation.xlsx | 11 KB | ||
| 13-03-custom-validation.xlsx | 8.8 KB | ||
| 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 | ||
| 2 - WATCH ME Essential Information for a Successful Training Experience.mp4 | 39.5 MB | ||
| 3.html | 819.2 B | ||
| 4.html | 819.2 B | ||
| 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 | ||
| 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 KB | ||
| Exercise04 - Solution.xlsx | 24.4 KB | ||
| Exercise04.xlsx | 22.8 KB | ||
| Exercise05 - Solution.xlsx | 1.1 MB | ||
| 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 KB | ||
| Exercise11 - Solution.xlsx | 628.7 KB | ||
| Exercise11.xlsx | 628.8 KB | ||
| Exercise12 - Solution.xlsx | 2.4 MB | ||
| Exercise12.xlsx | 2.4 MB | ||
| Sales Data.txt | 100.4 KB | ||
| sales-2016.csv | 582.3 KB | ||
| sales-2017.csv | 605.1 KB | ||
| sales-2018.csv | 604.1 KB | ||
| sales-2019.csv | 605.8 KB | ||
| ▲ 110 total files | |||
Quote:
Working with Date and Time Functions: Intermediate Excel
Learn Excel’s Date and Time Functions to Calculate, Format, and Analyze Time-Based Data Efficiently.
What you'll learn
Apply custom date formats for clear and professional presentations.
Utilize various date and time functions to manage data with precision.
Calculate date differences and accurately determine ages.
Use WORKDAY and WORKDAY.INTL functions to calculate workdays.
Leverage NETWORKDAYS and NETWORKDAYS.INTL to calculate business days.
Apply EDATE and EOMONTH to manipulate dates for scheduling and reporting.
Description
**This course includes downloadable course instructor files and exercise files to work with and follow along.**
Welcome to Microsoft Excel Intermediate training! This course will help you enhance your Excel skills by focusing on date and time functions, which are critical tools for anyone working with spreadsheets. You will learn to calculate dates, manage time-based data, and utilize powerful Excel functions like TODAY, WORKDAY, NETWORKDAYS, and many more. Whether you're a beginner looking to strengthen your foundational skills or an experienced user aiming to refine your techniques, this course will give you the knowledge to work efficiently with date-related data.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 303 MB | freecoursewb | 4 months | 0 | 0 | |
|
Azure Developer Associate (AZ-204) - Working with Cloud Storage and Databases Posted by
freecoursewb in Other
|
393.8 MB | freecoursewb | 10 months | 6 | 7 |
| 539 MB | freecoursewb | 1 year | 15 | 4 | |
| 847.2 MB | freecoursewb | 1 year | 8 | 0 | |
| 405.9 MB | freecoursewb | 1 year | 0 | 1 |
All Comments