Clean and Format Excel Data for Analysis Intermediate | 28190A14DEF8276A34A3A6550CE68C69BF5D7DAF

Clean and Format Excel Data for Analysis Intermediate

Name	Clean and Format Excel Data for Analysis Intermediate	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.1 GB
Total Files	112
Last Seen	2025-07-18 00:11
Hash	28190A14DEF8276A34A3A6550CE68C69BF5D7DAF

/1 - Prepare Data for Analysis/
1 - Course Introduction.mp4	70.9 MB
2 - WATCH ME Essential Information for a Successful Training Experience.mp4	41.4 MB
3.html	0.8 KB
4.html	0.9 KB
5 - Importing Data into Excel.mp4	119.9 MB
6 - Removing Blank Rows Cells and Duplicates.mp4	73.9 MB
7 - Changing Case and Removing Spaces.mp4	193.2 MB
8 - Splitting Data using Text to Columns.mp4	112.3 MB
9 - Splitting Data using Text Functions.mp4	68.0 MB
10 - Splitting or Combining Cell Data Using Flashfill.mp4	55.1 MB
11 - Joining Data using CONCAT.mp4	95.6 MB
12 - Formatting Data as a Table.mp4	105.3 MB
13 - Exercise.mp4	113.5 MB
14 - Course Close.mp4	10.1 MB
/.../(Intermediate 1 of 13)/
02-01-the-golden-rules-of-spreadsheet-design.xlsx	2.8 MB
02-02-cell-styles.xlsx	12.4 KB
02-03-controlling-data-input.xlsx	11.8 KB
02-04-adding-navigation-buttons.xlsx	2.8 MB
/.../(Intermediate 2 of 13)/
03-01-logical-functions.xlsx	39.7 KB
03-02-the-if-function.xlsx	65.6 KB
03-03-nested-ifs.xlsx	67.8 KB
03-04-the-IFS-function.xlsx	70.4 KB
03-05-countif-sumif-averageif.xlsx	11.1 KB
03-06-countifs-sumifs-averageifs.xlsx	11.4 KB
03-07-error-handling-ifna-and-iferror.xlsx	84.7 KB
/.../(Intermediate 3 of 13)/
04-01-vlookup-exact-match.xlsx	16.4 KB
04-02-vlookup-approx-match.xlsx	11.2 KB
04-03-hlookup.xlsx	11.7 KB
04-04-using-index-match.xlsx	13.1 KB
04-05-using-xlookup-and-xmatch.xlsx	12.2 KB
04-06-the-offset-funtction.xlsx	11.6 KB
04-07-the-indirect-function.xlsx	14.7 KB
/.../(Intermediate 4 of 13)/
05-01-sorting-on-multiple-columns.xlsx	12.7 KB
05-02-sorting-using-a-custom-list.xlsx	12.8 KB
05-03-the-sort-and-sortby-functions.xlsx	11.3 KB
05-04-using-the-advanced-filter.xlsx	12.5 KB
05-05-the-unique-function.xlsx	10.3 KB
05-06-the-filter-function.xlsx	13.9 KB
/.../(Intermediate 5 of 13)/
06-01-how-dates-and-times-work.xlsx	11.0 KB
06-02-applying-custom-date-formats.xlsx	9.9 KB
06-03-using-date-and-time-functions.xlsx	12.7 KB
06-04-using-the-workdays-function.xlsx	10.7 KB
06-05-using-the-networkdays-function.xlsx	11.1 KB
06-06-dates-difference-with-datediff.xlsx	10.8 KB
06-07-calculate-dates-with-edate-and-eomonth.xlsx	78.3 KB
/.../(Intermediate 6 of 13)/
07-02-removing-blank-rows-cells-and-duplicates.xlsx	1.9 MB
07-03-changing-case-and-removing-spaces.xlsx	79.6 KB
07-04-splitting-data-using-text-to-columns.xlsx	78.4 KB
07-05-splitting-data-using-text-functions.xlsx	19.7 KB
07-06-splitting-or-combining-cells-using-flashfill.xlsx	78.6 KB
07-07-joining-data-using-concat-and-textjoin.xlsx	81.5 KB
07-08-formatting-data-as-a-table.xlsx	81.0 KB
Sales Data.txt	102.8 KB
/.../(Intermediate 6 of 13)/Sales Data/
sales-2016.csv	596.3 KB
sales-2017.csv	619.6 KB
sales-2018.csv	618.6 KB
sales-2019.csv	620.4 KB
/.../(Intermediate 7 of 13)/
08-01-pivot-tables-explained.xlsx	79.9 KB
08-02-creating-a-pivot-table-from-scratch.xlsx	81.3 KB
08-03-pivoting-the-fields.xlsx	112.9 KB
08-04-subtotals-and-grandtotals.xlsx	114.0 KB
08-05-number-formatting.xlsx	114.2 KB
08-06-show-values-as-summarize-by.xlsx	114.4 KB
08-07-grouping-pivot-table-data.xlsx	123.4 KB
08-08-formatting-error-values-and-empty-cells.xlsx	123.4 KB
08-09-report-layouts.xlsx	127.1 KB
08-10-applying-pivottable-styles.xlsx	123.5 KB
/.../(Intermediate 8 of 13)/
09-01-creating-a-pivot-chart.xlsx	123.9 KB
09-02-formatting-a-pivot-chart-part1.xlsx	123.4 KB
09-03-formatting-a-pivot-chart-part2.xlsx	129.0 KB
09-04-using-map-charts.xlsx	142.8 KB
/.../(Intermediate 9 of 13)/
10-01-inserting-and-formatting-slicers.xlsx	7.6 MB
10-02-inserting-timeline-slicers.xlsx	7.6 MB
10-03-report-connections.xlsx	7.6 MB
10-04-updating-pivot-data.xlsx	7.6 MB
/.../(Intermediate 10 of 13)/
11-01-what-is-a-dashboard.xlsx	215.9 KB
11-02-assembling-a-dashboard-part-1.xlsx	216.5 KB
11-03-assembling-a-dashboard-part-2.xlsx	125.9 KB
11-04-assembling-a-dashboard-part-3.xlsx	193.3 KB
/.../(Intermediate 11 of 13)/
12-01-common-errors.xlsx	11.5 KB
12-02-formula-auditing.xlsx	193.3 KB
/.../(Intermediate 12 of 13)/
13-01-data-validation.xlsx	10.8 KB
13-02-other-types-of-data-validation.xlsx	11.3 KB
13-03-custom-validation.xlsx	9.1 KB
/.../(Intermediate 13 of 13)/
14-01-loan-payments-with-pmt.xlsx	55.7 KB
14-02-goal-seek.xlsx	36.9 KB
14-03-scenario-manager.xlsx	10.1 KB
14-04-data-tables-one-variable.xlsx	11.2 KB
14-05-data-tables-two-variable.xlsx	9.8 KB
/Exercises Files/
Exercise01 - Solution.xlsx	43.9 KB
Exercise01.xlsx	42.3 KB
Exercise02 - Solution.xlsx	25.8 KB
Exercise02.xlsx	25.2 KB
Exercise03 - Solution.xlsx	42.4 KB
Exercise03.xlsx	41.0 KB
Exercise04 - Solution.xlsx	24.9 KB
Exercise04.xlsx	23.3 KB
Exercise05 - Solution.xlsx	1.1 MB
Exercise05.xlsx	1.0 MB
Exercise06 - Solution.xlsx	1.3 MB
Exercise06.xlsx	1.1 MB
Exercise07 - Solution.xlsx	1.4 MB
Exercise07.xlsx	1.4 MB
Exercise08 - Solution.xlsx	1.6 MB
Exercise08.xlsx	1.3 MB
Exercise09.xlsx	1.1 MB
Exercise10 - Solution.xlsx	646.2 KB
Exercise10.xlsx	647.2 KB
Exercise11 - Solution.xlsx	643.8 KB
Exercise11.xlsx	643.9 KB
Exercise12 - Solution.xlsx	2.6 MB
Exercise12.xlsx	2.5 MB
Total files 112