Clean and Format Excel Data for Analysis Intermediate
大小
1.05 GB
文件数
112
Info Hash:
28190A14DEF8276A34A3A6550CE68C69BF5D7DAF
收录时间
2026-01-28 01:57:39
更新时间
2026-01-28 01:57:39
文件列表 (112)
1 - Prepare Data for Analysis/1 - Course Introduction.mp4
67.65 MB
1 - Prepare Data for Analysis/2 - WATCH ME Essential Information for a Successful Training Experience.mp4
39.53 MB
1 - Prepare Data for Analysis/3.html
840 B
1 - Prepare Data for Analysis/4.html
861 B
1 - Prepare Data for Analysis/5 - Importing Data into Excel.mp4
114.36 MB
1 - Prepare Data for Analysis/6 - Removing Blank Rows Cells and Duplicates.mp4
70.47 MB
1 - Prepare Data for Analysis/7 - Changing Case and Removing Spaces.mp4
184.23 MB
1 - Prepare Data for Analysis/8 - Splitting Data using Text to Columns.mp4
107.1 MB
1 - Prepare Data for Analysis/9 - Splitting Data using Text Functions.mp4
64.83 MB
1 - Prepare Data for Analysis/10 - Splitting or Combining Cell Data Using Flashfill.mp4
52.55 MB
1 - Prepare Data for Analysis/11 - Joining Data using CONCAT.mp4
91.19 MB
1 - Prepare Data for Analysis/12 - Formatting Data as a Table.mp4
100.38 MB
1 - Prepare Data for Analysis/13 - Exercise.mp4
108.23 MB
1 - Prepare Data for Analysis/14 - Course Close.mp4
9.65 MB
1 - Prepare Data for Analysis/Course Files/(Intermediate 1 of 13)/02-01-the-golden-rules-of-spreadsheet-design.xlsx
2.64 MB
1 - Prepare Data for Analysis/Course Files/(Intermediate 1 of 13)/02-02-cell-styles.xlsx
12.12 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 1 of 13)/02-03-controlling-data-input.xlsx
11.49 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 1 of 13)/02-04-adding-navigation-buttons.xlsx
2.64 MB
1 - Prepare Data for Analysis/Course Files/(Intermediate 2 of 13)/03-01-logical-functions.xlsx
38.81 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 2 of 13)/03-02-the-if-function.xlsx
64.11 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 2 of 13)/03-03-nested-ifs.xlsx
66.25 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 2 of 13)/03-04-the-IFS-function.xlsx
68.77 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 2 of 13)/03-05-countif-sumif-averageif.xlsx
10.81 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 2 of 13)/03-06-countifs-sumifs-averageifs.xlsx
11.18 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 2 of 13)/03-07-error-handling-ifna-and-iferror.xlsx
82.73 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 3 of 13)/04-01-vlookup-exact-match.xlsx
15.97 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 3 of 13)/04-02-vlookup-approx-match.xlsx
10.9 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 3 of 13)/04-03-hlookup.xlsx
11.39 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 3 of 13)/04-04-using-index-match.xlsx
12.8 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 3 of 13)/04-05-using-xlookup-and-xmatch.xlsx
11.89 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 3 of 13)/04-06-the-offset-funtction.xlsx
11.3 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 3 of 13)/04-07-the-indirect-function.xlsx
14.39 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 4 of 13)/05-01-sorting-on-multiple-columns.xlsx
12.4 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 4 of 13)/05-02-sorting-using-a-custom-list.xlsx
12.47 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 4 of 13)/05-03-the-sort-and-sortby-functions.xlsx
11.08 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 4 of 13)/05-04-using-the-advanced-filter.xlsx
12.22 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 4 of 13)/05-05-the-unique-function.xlsx
10.09 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 4 of 13)/05-06-the-filter-function.xlsx
13.62 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 5 of 13)/06-01-how-dates-and-times-work.xlsx
10.75 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 5 of 13)/06-02-applying-custom-date-formats.xlsx
9.66 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 5 of 13)/06-03-using-date-and-time-functions.xlsx
12.38 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 5 of 13)/06-04-using-the-workdays-function.xlsx
10.44 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 5 of 13)/06-05-using-the-networkdays-function.xlsx
10.87 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 5 of 13)/06-06-dates-difference-with-datediff.xlsx
10.54 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 5 of 13)/06-07-calculate-dates-with-edate-and-eomonth.xlsx
76.42 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/07-02-removing-blank-rows-cells-and-duplicates.xlsx
1.85 MB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/07-03-changing-case-and-removing-spaces.xlsx
77.71 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/07-04-splitting-data-using-text-to-columns.xlsx
76.55 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/07-05-splitting-data-using-text-functions.xlsx
19.26 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/07-06-splitting-or-combining-cells-using-flashfill.xlsx
76.8 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/07-07-joining-data-using-concat-and-textjoin.xlsx
79.64 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/07-08-formatting-data-as-a-table.xlsx
79.13 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/Sales Data.txt
100.43 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/Sales Data/sales-2016.csv
582.34 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/Sales Data/sales-2017.csv
605.1 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/Sales Data/sales-2018.csv
604.06 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 6 of 13)/Sales Data/sales-2019.csv
605.84 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 7 of 13)/08-01-pivot-tables-explained.xlsx
78.03 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 7 of 13)/08-02-creating-a-pivot-table-from-scratch.xlsx
79.41 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 7 of 13)/08-03-pivoting-the-fields.xlsx
110.28 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 7 of 13)/08-04-subtotals-and-grandtotals.xlsx
111.31 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 7 of 13)/08-05-number-formatting.xlsx
111.57 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 7 of 13)/08-06-show-values-as-summarize-by.xlsx
111.68 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 7 of 13)/08-07-grouping-pivot-table-data.xlsx
120.52 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 7 of 13)/08-08-formatting-error-values-and-empty-cells.xlsx
120.51 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 7 of 13)/08-09-report-layouts.xlsx
124.09 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 7 of 13)/08-10-applying-pivottable-styles.xlsx
120.56 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 8 of 13)/09-01-creating-a-pivot-chart.xlsx
120.99 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 8 of 13)/09-02-formatting-a-pivot-chart-part1.xlsx
120.47 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 8 of 13)/09-03-formatting-a-pivot-chart-part2.xlsx
126.02 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 8 of 13)/09-04-using-map-charts.xlsx
139.42 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 9 of 13)/10-01-inserting-and-formatting-slicers.xlsx
7.22 MB
1 - Prepare Data for Analysis/Course Files/(Intermediate 9 of 13)/10-02-inserting-timeline-slicers.xlsx
7.22 MB
1 - Prepare Data for Analysis/Course Files/(Intermediate 9 of 13)/10-03-report-connections.xlsx
7.23 MB
1 - Prepare Data for Analysis/Course Files/(Intermediate 9 of 13)/10-04-updating-pivot-data.xlsx
7.23 MB
1 - Prepare Data for Analysis/Course Files/(Intermediate 10 of 13)/11-01-what-is-a-dashboard.xlsx
210.82 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 10 of 13)/11-02-assembling-a-dashboard-part-1.xlsx
211.43 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 10 of 13)/11-03-assembling-a-dashboard-part-2.xlsx
122.97 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 10 of 13)/11-04-assembling-a-dashboard-part-3.xlsx
188.81 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 11 of 13)/12-01-common-errors.xlsx
11.25 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 11 of 13)/12-02-formula-auditing.xlsx
188.81 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 12 of 13)/13-01-data-validation.xlsx
10.58 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 12 of 13)/13-02-other-types-of-data-validation.xlsx
10.99 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 12 of 13)/13-03-custom-validation.xlsx
8.84 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 13 of 13)/14-01-loan-payments-with-pmt.xlsx
54.35 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 13 of 13)/14-02-goal-seek.xlsx
36.06 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 13 of 13)/14-03-scenario-manager.xlsx
9.85 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 13 of 13)/14-04-data-tables-one-variable.xlsx
10.93 KB
1 - Prepare Data for Analysis/Course Files/(Intermediate 13 of 13)/14-05-data-tables-two-variable.xlsx
9.61 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise01 - Solution.xlsx
42.88 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise01.xlsx
41.31 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise02 - Solution.xlsx
25.21 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise02.xlsx
24.62 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise03 - Solution.xlsx
41.39 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise03.xlsx
40 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise04 - Solution.xlsx
24.35 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise04.xlsx
22.76 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise05 - Solution.xlsx
1.05 MB
1 - Prepare Data for Analysis/Exercises Files/Exercise05.xlsx
1011.5 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise06 - Solution.xlsx
1.29 MB
1 - Prepare Data for Analysis/Exercises Files/Exercise06.xlsx
1.07 MB
1 - Prepare Data for Analysis/Exercises Files/Exercise07 - Solution.xlsx
1.29 MB
1 - Prepare Data for Analysis/Exercises Files/Exercise07.xlsx
1.29 MB
1 - Prepare Data for Analysis/Exercises Files/Exercise08 - Solution.xlsx
1.57 MB
1 - Prepare Data for Analysis/Exercises Files/Exercise08.xlsx
1.28 MB
1 - Prepare Data for Analysis/Exercises Files/Exercise09.xlsx
1.08 MB
1 - Prepare Data for Analysis/Exercises Files/Exercise10 - Solution.xlsx
631.06 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise10.xlsx
631.99 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise11 - Solution.xlsx
628.74 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise11.xlsx
628.77 KB
1 - Prepare Data for Analysis/Exercises Files/Exercise12 - Solution.xlsx
2.44 MB
1 - Prepare Data for Analysis/Exercises Files/Exercise12.xlsx
2.43 MB