9.71 GB | 00:08:49 | mkv | 1920X1080 | 16:9
Genre:eLearning |Language:English

Files Included :
01 01-course introduction (180.94 MB)
01 02-what are pivot tables and why are they useful (206.9 MB)
02 01-the importance of cleaning data (111.43 MB)
02 02-removing blank rows (196.89 MB)
02 03-removing duplicate rows (109.23 MB)
02 04-clearing formatting (174.65 MB)
02 05-applying number formatting (364.88 MB)
02 06-changing the case (309.26 MB)
02 07-removing spaces and non-printing characters (360.94 MB)
02 08-merging and splitting columns (302.83 MB)
02 09-convert numbers stored as text (89.9 MB)
02 10-finding and replacing text (234.21 MB)
02 11-spell check (143.86 MB)
02 12-exercise 01 (171.48 MB)
03 01-excel tables versus pivot tables (223.91 MB)
03 02-format data as a table (395.74 MB)
03 03-exercise 02 (89.69 MB)
04 01-using recommended pivot tables (195.68 MB)
04 02-creating a pivot table from scratch (178.02 MB)
04 03-pivot table ribbons and fields (113.1 MB)
04 04-pivoting the fields (120.51 MB)
04 05-adding multiple dimensions (97.74 MB)
04 06-deleting fields and locking the report layout (119.76 MB)
04 07-exercise 03 (64.01 MB)
05 01-methods of aggregation (121.42 MB)
05 02-combining methods of aggregation (155.56 MB)
05 03-grouping and ungrouping data (285.67 MB)
05 04-exercise 04 (106.58 MB)
06 01-applying number formatting (146.83 MB)
06 02-handling cells with no data (115.9 MB)
06 03-exercise 05 (77.98 MB)
07 01-subtotals and grand totals (135.83 MB)
07 02-choosing a report layout (151.02 MB)
07 03-inserting blank rows (75.13 MB)
07 04-exercise 06 (66.6 MB)
08 01-applying pivot table styles (142.17 MB)
08 02-modifying pivot table styles (139.1 MB)
08 03-creating a custom pivot table style (186.91 MB)
08 04-exercise 07 (108.22 MB)
09 01-sorting pivot table data (262.68 MB)
09 02-filtering pivot table data (219.91 MB)
09 03-top 10 filter (96.28 MB)
09 04-exercise 08 (57.75 MB)
10 01-selecting the right chart type (211.08 MB)
10 02-clustered column and bar charts (263.04 MB)
10 03-line charts (200.13 MB)
10 04-pie and donut charts (216.98 MB)
10 05-map charts (239.41 MB)
10 06-applying chart layouts (65.87 MB)
10 07-exercise 09 (103.58 MB)
11 01-adding a slicer (148.66 MB)
11 02-formatting a slicer (130.79 MB)
11 03-adding a timeline (157.05 MB)
11 04-connecting slicers and timelines (110.24 MB)
11 05-exercise 10 (77.34 MB)
12 01-highlight cell rules (116.04 MB)
12 02-data bars (111.38 MB)
12 03-color scales (90.11 MB)
12 04-icon sets (120.42 MB)
12 05-exercise 11 (45.39 MB)
13 01-adding data to the dataset (123 MB)
13 02-updating pivot tables and pivot charts (51.04 MB)
13 03-exercise 12 (82.22 MB)
14 01-course and next steps (69.22 MB)