Other
Clean and Format Excel Data for Analysis Intermediate
Torrent info
Torrent Files List
1 - Prepare Data for Analysis (Size: 1.05 GB) (Files: 112)
1 - Prepare Data for Analysis
1 - Course Introduction.mp4
2 - WATCH ME Essential Information for a Successful Training Experience.mp4
3.html
4.html
5 - Importing Data into Excel.mp4
6 - Removing Blank Rows Cells and Duplicates.mp4
7 - Changing Case and Removing Spaces.mp4
8 - Splitting Data using Text to Columns.mp4
9 - Splitting Data using Text Functions.mp4
10 - Splitting or Combining Cell Data Using Flashfill.mp4
11 - Joining Data using CONCAT.mp4
12 - Formatting Data as a Table.mp4
13 - Exercise.mp4
14 - 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 Clean and Format Excel Data for Analysis Intermediate Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
