|
Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать
эти файлы или скачать torrent-файл.
|
| 02-01-the-golden-rules-of-spreadsheet-design.xlsx |
2.64Мб |
| 02-02-cell-styles.xlsx |
12.12Кб |
| 02-03-controlling-data-input.xlsx |
11.49Кб |
| 02-04-adding-navigation-buttons.xlsx |
2.64Мб |
| 03-01-logical-functions.xlsx |
38.81Кб |
| 03-02-the-if-function.xlsx |
64.11Кб |
| 03-03-nested-ifs.xlsx |
66.25Кб |
| 03-04-the-IFS-function.xlsx |
68.77Кб |
| 03-05-countif-sumif-averageif.xlsx |
10.81Кб |
| 03-06-countifs-sumifs-averageifs.xlsx |
11.18Кб |
| 03-07-error-handling-ifna-and-iferror.xlsx |
82.73Кб |
| 04-01-vlookup-exact-match.xlsx |
15.97Кб |
| 04-02-vlookup-approx-match.xlsx |
10.90Кб |
| 04-03-hlookup.xlsx |
11.39Кб |
| 04-04-using-index-match.xlsx |
12.80Кб |
| 04-05-using-xlookup-and-xmatch.xlsx |
11.89Кб |
| 04-06-the-offset-funtction.xlsx |
11.30Кб |
| 04-07-the-indirect-function.xlsx |
14.39Кб |
| 05-01-sorting-on-multiple-columns.xlsx |
12.40Кб |
| 05-02-sorting-using-a-custom-list.xlsx |
12.47Кб |
| 05-03-the-sort-and-sortby-functions.xlsx |
11.08Кб |
| 05-04-using-the-advanced-filter.xlsx |
12.22Кб |
| 05-05-the-unique-function.xlsx |
10.09Кб |
| 05-06-the-filter-function.xlsx |
13.62Кб |
| 06-01-how-dates-and-times-work.xlsx |
10.75Кб |
| 06-02-applying-custom-date-formats.xlsx |
9.66Кб |
| 06-03-using-date-and-time-functions.xlsx |
12.38Кб |
| 06-04-using-the-workdays-function.xlsx |
10.44Кб |
| 06-05-using-the-networkdays-function.xlsx |
10.87Кб |
| 06-06-dates-difference-with-datediff.xlsx |
10.54Кб |
| 06-07-calculate-dates-with-edate-and-eomonth.xlsx |
76.42Кб |
| 07-02-removing-blank-rows-cells-and-duplicates.xlsx |
1.85Мб |
| 07-03-changing-case-and-removing-spaces.xlsx |
77.71Кб |
| 07-04-splitting-data-using-text-to-columns.xlsx |
76.55Кб |
| 07-05-splitting-data-using-text-functions.xlsx |
19.26Кб |
| 07-06-splitting-or-combining-cells-using-flashfill.xlsx |
76.80Кб |
| 07-07-joining-data-using-concat-and-textjoin.xlsx |
79.64Кб |
| 07-08-formatting-data-as-a-table.xlsx |
79.13Кб |
| 08-01-pivot-tables-explained.xlsx |
78.03Кб |
| 08-02-creating-a-pivot-table-from-scratch.xlsx |
79.41Кб |
| 08-03-pivoting-the-fields.xlsx |
110.28Кб |
| 08-04-subtotals-and-grandtotals.xlsx |
111.31Кб |
| 08-05-number-formatting.xlsx |
111.57Кб |
| 08-06-show-values-as-summarize-by.xlsx |
111.68Кб |
| 08-07-grouping-pivot-table-data.xlsx |
120.52Кб |
| 08-08-formatting-error-values-and-empty-cells.xlsx |
120.51Кб |
| 08-09-report-layouts.xlsx |
124.09Кб |
| 08-10-applying-pivottable-styles.xlsx |
120.56Кб |
| 09-01-creating-a-pivot-chart.xlsx |
120.99Кб |
| 09-02-formatting-a-pivot-chart-part1.xlsx |
120.47Кб |
| 09-03-formatting-a-pivot-chart-part2.xlsx |
126.02Кб |
| 09-04-using-map-charts.xlsx |
139.42Кб |
| 10-01-inserting-and-formatting-slicers.xlsx |
7.22Мб |
| 10-02-inserting-timeline-slicers.xlsx |
7.22Мб |
| 10-03-report-connections.xlsx |
7.23Мб |
| 10-04-updating-pivot-data.xlsx |
7.23Мб |
| 10 - Splitting or Combining Cell Data Using Flashfill.mp4 |
52.55Мб |
| 11-01-what-is-a-dashboard.xlsx |
210.82Кб |
| 11-02-assembling-a-dashboard-part-1.xlsx |
211.43Кб |
| 11-03-assembling-a-dashboard-part-2.xlsx |
122.97Кб |
| 11-04-assembling-a-dashboard-part-3.xlsx |
188.81Кб |
| 11 - Joining Data using CONCAT.mp4 |
91.19Мб |
| 12-01-common-errors.xlsx |
11.25Кб |
| 12-02-formula-auditing.xlsx |
188.81Кб |
| 12 - Formatting Data as a Table.mp4 |
100.38Мб |
| 13-01-data-validation.xlsx |
10.58Кб |
| 13-02-other-types-of-data-validation.xlsx |
10.99Кб |
| 13-03-custom-validation.xlsx |
8.84Кб |
| 13 - Exercise.mp4 |
108.23Мб |
| 14-01-loan-payments-with-pmt.xlsx |
54.35Кб |
| 14-02-goal-seek.xlsx |
36.06Кб |
| 14-03-scenario-manager.xlsx |
9.85Кб |
| 14-04-data-tables-one-variable.xlsx |
10.93Кб |
| 14-05-data-tables-two-variable.xlsx |
9.61Кб |
| 14 - Course Close.mp4 |
9.65Мб |
| 1 - Course Introduction.mp4 |
67.65Мб |
| 2 - WATCH ME Essential Information for a Successful Training Experience.mp4 |
39.53Мб |
| 3.html |
840б |
| 4.html |
861б |
| 5 - Importing Data into Excel.mp4 |
114.36Мб |
| 6 - Removing Blank Rows Cells and Duplicates.mp4 |
70.47Мб |
| 7 - Changing Case and Removing Spaces.mp4 |
184.23Мб |
| 8 - Splitting Data using Text to Columns.mp4 |
107.10Мб |
| 9 - Splitting Data using Text Functions.mp4 |
64.83Мб |
| Exercise01.xlsx |
41.31Кб |
| Exercise01 - Solution.xlsx |
42.88Кб |
| Exercise02.xlsx |
24.62Кб |
| Exercise02 - Solution.xlsx |
25.21Кб |
| Exercise03.xlsx |
40.00Кб |
| Exercise03 - Solution.xlsx |
41.39Кб |
| Exercise04.xlsx |
22.76Кб |
| Exercise04 - Solution.xlsx |
24.35Кб |
| Exercise05.xlsx |
1011.50Кб |
| Exercise05 - Solution.xlsx |
1.05Мб |
| Exercise06.xlsx |
1.07Мб |
| Exercise06 - Solution.xlsx |
1.29Мб |
| Exercise07.xlsx |
1.29Мб |
| Exercise07 - Solution.xlsx |
1.29Мб |
| Exercise08.xlsx |
1.28Мб |
| Exercise08 - Solution.xlsx |
1.57Мб |
| Exercise09.xlsx |
1.08Мб |
| Exercise10.xlsx |
631.99Кб |
| Exercise10 - Solution.xlsx |
631.06Кб |
| Exercise11.xlsx |
628.77Кб |
| Exercise11 - Solution.xlsx |
628.74Кб |
| Exercise12.xlsx |
2.43Мб |
| Exercise12 - Solution.xlsx |
2.44Мб |
| sales-2016.csv |
582.34Кб |
| sales-2017.csv |
605.10Кб |
| sales-2018.csv |
604.06Кб |
| sales-2019.csv |
605.84Кб |
| Sales Data.txt |
100.43Кб |