|
|
02-01-the-golden-rules-of-spreadsheet-design.xlsx
|
XLSX
|
2.6 MB
|
|
|
02-02-cell-styles.xlsx
|
XLSX
|
12.1 KB
|
|
|
02-03-controlling-data-input.xlsx
|
XLSX
|
11.5 KB
|
|
|
02-04-adding-navigation-buttons.xlsx
|
XLSX
|
2.6 MB
|
|
|
03-01-logical-functions.xlsx
|
XLSX
|
38.8 KB
|
|
|
03-02-the-if-function.xlsx
|
XLSX
|
64.1 KB
|
|
|
03-03-nested-ifs.xlsx
|
XLSX
|
66.3 KB
|
|
|
03-04-the-IFS-function.xlsx
|
XLSX
|
68.8 KB
|
|
|
03-05-countif-sumif-averageif.xlsx
|
XLSX
|
10.8 KB
|
|
|
03-06-countifs-sumifs-averageifs.xlsx
|
XLSX
|
11.2 KB
|
|
|
03-07-error-handling-ifna-and-iferror.xlsx
|
XLSX
|
82.7 KB
|
|
|
04-01-vlookup-exact-match.xlsx
|
XLSX
|
16 KB
|
|
|
04-02-vlookup-approx-match.xlsx
|
XLSX
|
10.9 KB
|
|
|
04-03-hlookup.xlsx
|
XLSX
|
11.4 KB
|
|
|
04-04-using-index-match.xlsx
|
XLSX
|
12.8 KB
|
|
|
04-05-using-xlookup-and-xmatch.xlsx
|
XLSX
|
11.9 KB
|
|
|
04-06-the-offset-funtction.xlsx
|
XLSX
|
11.3 KB
|
|
|
04-07-the-indirect-function.xlsx
|
XLSX
|
14.4 KB
|
|
|
05-01-sorting-on-multiple-columns.xlsx
|
XLSX
|
12.4 KB
|
|
|
05-02-sorting-using-a-custom-list.xlsx
|
XLSX
|
12.5 KB
|
|
|
05-03-the-sort-and-sortby-functions.xlsx
|
XLSX
|
11.1 KB
|
|
|
05-04-using-the-advanced-filter.xlsx
|
XLSX
|
12.2 KB
|
|
|
05-05-the-unique-function.xlsx
|
XLSX
|
10.1 KB
|
|
|
05-06-the-filter-function.xlsx
|
XLSX
|
13.6 KB
|
|
|
06-01-how-dates-and-times-work.xlsx
|
XLSX
|
10.8 KB
|
|
|
06-02-applying-custom-date-formats.xlsx
|
XLSX
|
9.7 KB
|
|
|
06-03-using-date-and-time-functions.xlsx
|
XLSX
|
12.4 KB
|
|
|
06-04-using-the-workdays-function.xlsx
|
XLSX
|
10.4 KB
|
|
|
06-05-using-the-networkdays-function.xlsx
|
XLSX
|
10.9 KB
|
|
|
06-06-dates-difference-with-datediff.xlsx
|
XLSX
|
10.5 KB
|
|
|
06-07-calculate-dates-with-edate-and-eomonth.xlsx
|
XLSX
|
76.4 KB
|
|
|
07-02-removing-blank-rows-cells-and-duplicates.xlsx
|
XLSX
|
1.9 MB
|
|
|
07-03-changing-case-and-removing-spaces.xlsx
|
XLSX
|
77.7 KB
|
|
|
07-04-splitting-data-using-text-to-columns.xlsx
|
XLSX
|
76.6 KB
|
|
|
07-05-splitting-data-using-text-functions.xlsx
|
XLSX
|
19.3 KB
|
|
|
07-06-splitting-or-combining-cells-using-flashfill.xlsx
|
XLSX
|
76.8 KB
|
|
|
07-07-joining-data-using-concat-and-textjoin.xlsx
|
XLSX
|
79.6 KB
|
|
|
07-08-formatting-data-as-a-table.xlsx
|
XLSX
|
79.1 KB
|
|
|
08-01-pivot-tables-explained.xlsx
|
XLSX
|
78 KB
|
|
|
08-02-creating-a-pivot-table-from-scratch.xlsx
|
XLSX
|
79.4 KB
|
|
|
08-03-pivoting-the-fields.xlsx
|
XLSX
|
110.3 KB
|
|
|
08-04-subtotals-and-grandtotals.xlsx
|
XLSX
|
111.3 KB
|
|
|
08-05-number-formatting.xlsx
|
XLSX
|
111.6 KB
|
|
|
08-06-show-values-as-summarize-by.xlsx
|
XLSX
|
111.7 KB
|
|
|
08-07-grouping-pivot-table-data.xlsx
|
XLSX
|
120.5 KB
|
|
|
08-08-formatting-error-values-and-empty-cells.xlsx
|
XLSX
|
120.5 KB
|
|
|
08-09-report-layouts.xlsx
|
XLSX
|
124.1 KB
|
|
|
08-10-applying-pivottable-styles.xlsx
|
XLSX
|
120.6 KB
|
|
|
09-01-creating-a-pivot-chart.xlsx
|
XLSX
|
121 KB
|
|
|
09-02-formatting-a-pivot-chart-part1.xlsx
|
XLSX
|
120.5 KB
|
|
|
09-03-formatting-a-pivot-chart-part2.xlsx
|
XLSX
|
126 KB
|
|
|
09-04-using-map-charts.xlsx
|
XLSX
|
139.4 KB
|
|
|
1 - Course Introduction.mp4
|
MP4
|
67.6 MB
|
|
|
10 - Splitting or Combining Cell Data Using Flashfill.mp4
|
MP4
|
52.6 MB
|
|
|
10-01-inserting-and-formatting-slicers.xlsx
|
XLSX
|
7.2 MB
|
|
|
10-02-inserting-timeline-slicers.xlsx
|
XLSX
|
7.2 MB
|
|
|
10-03-report-connections.xlsx
|
XLSX
|
7.2 MB
|
|
|
10-04-updating-pivot-data.xlsx
|
XLSX
|
7.2 MB
|
|
|
11 - Joining Data using CONCAT.mp4
|
MP4
|
91.2 MB
|
|
|
11-01-what-is-a-dashboard.xlsx
|
XLSX
|
210.8 KB
|
|
|
11-02-assembling-a-dashboard-part-1.xlsx
|
XLSX
|
211.4 KB
|
|
|
11-03-assembling-a-dashboard-part-2.xlsx
|
XLSX
|
123 KB
|
|
|
11-04-assembling-a-dashboard-part-3.xlsx
|
XLSX
|
188.8 KB
|
|
|
12 - Formatting Data as a Table.mp4
|
MP4
|
100.4 MB
|
|
|
12-01-common-errors.xlsx
|
XLSX
|
11.3 KB
|
|
|
12-02-formula-auditing.xlsx
|
XLSX
|
188.8 KB
|
|
|
13 - Exercise.mp4
|
MP4
|
108.2 MB
|
|
|
13-01-data-validation.xlsx
|
XLSX
|
10.6 KB
|
|
|
13-02-other-types-of-data-validation.xlsx
|
XLSX
|
11 KB
|
|
|
13-03-custom-validation.xlsx
|
XLSX
|
8.8 KB
|
|
|
14 - Course Close.mp4
|
MP4
|
9.6 MB
|
|
|
14-01-loan-payments-with-pmt.xlsx
|
XLSX
|
54.4 KB
|
|
|
14-02-goal-seek.xlsx
|
XLSX
|
36.1 KB
|
|
|
14-03-scenario-manager.xlsx
|
XLSX
|
9.8 KB
|
|
|
14-04-data-tables-one-variable.xlsx
|
XLSX
|
10.9 KB
|
|
|
14-05-data-tables-two-variable.xlsx
|
XLSX
|
9.6 KB
|
|
|
2 - WATCH ME Essential Information for a Successful Training Experience.mp4
|
MP4
|
39.5 MB
|
|
|
3.html
|
HTML
|
819.2 B
|
|
|
4.html
|
HTML
|
819.2 B
|
|
|
5 - Importing Data into Excel.mp4
|
MP4
|
114.4 MB
|
|
|
6 - Removing Blank Rows Cells and Duplicates.mp4
|
MP4
|
70.5 MB
|
|
|
7 - Changing Case and Removing Spaces.mp4
|
MP4
|
184.2 MB
|
|
|
8 - Splitting Data using Text to Columns.mp4
|
MP4
|
107.1 MB
|
|
|
9 - Splitting Data using Text Functions.mp4
|
MP4
|
64.8 MB
|
|
|
Exercise01 - Solution.xlsx
|
XLSX
|
42.9 KB
|
|
|
Exercise01.xlsx
|
XLSX
|
41.3 KB
|
|
|
Exercise02 - Solution.xlsx
|
XLSX
|
25.2 KB
|
|
|
Exercise02.xlsx
|
XLSX
|
24.6 KB
|
|
|
Exercise03 - Solution.xlsx
|
XLSX
|
41.4 KB
|
|
|
Exercise03.xlsx
|
XLSX
|
40 KB
|
|
|
Exercise04 - Solution.xlsx
|
XLSX
|
24.4 KB
|
|
|
Exercise04.xlsx
|
XLSX
|
22.8 KB
|
|
|
Exercise05 - Solution.xlsx
|
XLSX
|
1.1 MB
|
|
|
Exercise06 - Solution.xlsx
|
XLSX
|
1.3 MB
|
|
|
Exercise06.xlsx
|
XLSX
|
1.1 MB
|
|
|
Exercise07 - Solution.xlsx
|
XLSX
|
1.3 MB
|
|
|
Exercise07.xlsx
|
XLSX
|
1.3 MB
|
|
|
Exercise08 - Solution.xlsx
|
XLSX
|
1.6 MB
|
|
|
Exercise08.xlsx
|
XLSX
|
1.3 MB
|
|
|
Exercise09.xlsx
|
XLSX
|
1.1 MB
|
|
|
Exercise10 - Solution.xlsx
|
XLSX
|
631.1 KB
|
|
|
Exercise10.xlsx
|
XLSX
|
632 KB
|
|
|
Exercise11 - Solution.xlsx
|
XLSX
|
628.7 KB
|
|
|
Exercise11.xlsx
|
XLSX
|
628.8 KB
|
|
|
Exercise12 - Solution.xlsx
|
XLSX
|
2.4 MB
|
|
|
Exercise12.xlsx
|
XLSX
|
2.4 MB
|
|
|
Sales Data.txt
|
TXT
|
100.4 KB
|
|
|
sales-2016.csv
|
CSV
|
582.3 KB
|
|
|
sales-2017.csv
|
CSV
|
605.1 KB
|
|
|
sales-2018.csv
|
CSV
|
604.1 KB
|
|
|
sales-2019.csv
|
CSV
|
605.8 KB
|
