https://img87.pixhost.to/images/599/359020115_tuto.jpg
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)
[align=center]
Screenshot
https://images2.imgbox.com/cd/cf/xpNpmm27_o.jpg

[/align]

Код:
https://ddownload.com/yngm9pjfb6hf/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part1.rar
https://ddownload.com/dlr7crjeopi0/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part2.rar
https://ddownload.com/7m4ofdu7wjs6/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part3.rar
https://ddownload.com/ppxr81jxn579/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part4.rar
https://ddownload.com/mo2h5rstydkj/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part5.rar
https://ddownload.com/1ep5c1l946i5/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part6.rar
Код:
https://rapidgator.net/file/57c7f961a49b0f822cbf22da179d2d58/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part1.rar
https://rapidgator.net/file/6bbbc49f4e43d9b73756595b3d194504/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part2.rar
https://rapidgator.net/file/334272462debe57955484afb2296e0a3/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part3.rar
https://rapidgator.net/file/29d739f2e5bc0e824e488e552e5b6181/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part4.rar
https://rapidgator.net/file/7d67567917d00319b3ad8fbb209b0fa5/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part5.rar
https://rapidgator.net/file/d1ecab03c4b34746b65cb22cf008507b/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part6.rar
Код:
https://turbobit.net/1qeexmd9qaly/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part1.rar.html
https://turbobit.net/wxj1296ylkjy/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part2.rar.html
https://turbobit.net/v7q50oic5qid/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part3.rar.html
https://turbobit.net/pxwjdfq897s2/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part4.rar.html
https://turbobit.net/32peyocj4u6o/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part5.rar.html
https://turbobit.net/ryj603lbj2mo/Microsoft.Excel.A.Beginners.Guide.to.Pivot.Tables.in.Excel-XQZT.part6.rar.html