17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - The Best Excel Pivot Tables Course In The World
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
The course consists only of hands-on exercises in which I share my many years of experience working with a pivot table and show you various tricks.
Thanks to it, every Excel user will quickly learn to work with a pivot table and learn about the possibilities of creating dashboards with their use.
You will learn preparing the data, inserting pivot tables, changing the calculations.
There is also a lot of content on dashboards with pivot tables, pivot charts and slicers.
Requirements
I recorded the course in 2019 in Office 365, but the pivot table has been working the same for years. You can easily follow the course in Excel 2007, 2010, 2013, 2016, 2019 and 365. In older versions, you may encounter different nomenclature or lack of certain functions (e.g. slicer, timeline, + - icons next to the chart).
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/01 - How to learn Excel/001 The New Excel Learning Curve.mp4
57.4 MB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/001 1-solution.xlsx
4.2 MB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/001 1.1. My first pivot table.mp4
83.4 MB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/002 1.2. Insert a pivot table - DIY exercise.mp4
28 MB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/003 1.3. Pivot table refresh range vs table.mp4
166.6 MB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4. How to prepare data for a pivot table.mp4
58.2 MB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4.wrong-data-source-solution.xlsx
36.5 KB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4.wrong-data-source.xlsx
13.5 KB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/001 2-solution.xlsx
3.4 MB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/001 2.1. Sum, Count, Average.mp4
83.7 MB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/002 2.2. DIY Summarize values by.mp4
36 MB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3-solution.xlsx
12.9 KB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3. How does the average work.mp4
29.6 MB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3.xlsx
9.5 KB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/004 2.4. Drill down - viewing the source data.mp4
36.7 MB
~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/001 3-solution.xlsx
2.8 MB
~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/001 3.1. Auto grouping (+ -), grand totals and subtotals.mp4
50.3 MB
~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/002 3.2. Changing the report layout.mp4
48.4 MB
~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/003 3.3. Automatic and manual sorting.mp4
51.7 MB
~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/004 3.4. DIY Pivot table layout.mp4
53.7 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/001 4-solution.xlsx
2.4 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/001 4.1. Manual grouping.mp4
56.2 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/002 4.2. Grouping dates.mp4
54.2 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3-problem-with-dates.xlsx
14.9 KB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3-solution.xlsx
16 KB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3. Problems with date grouping.mp4
13.7 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/004 4.4. Grouping values.mp4
29.6 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/005 4.5. DIY Grouping TOP 5 vs Others.mp4
35.8 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/001 5-solution.xlsx
2.6 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/001 5.1. Filters shelf.mp4
42.1 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/002 5.2. Rows and columns filter - text, date, number.mp4
100.4 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/003 5.3. Value filter and TOP N filter.mp4
57.2 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/004 5.4. Generate report filter pages.mp4
23.4 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/005 5.5. Slicer.mp4
122.5 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/006 5.6. Timeline.mp4
19.1 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/007 5.7. DIY Week slicer.mp4
28 MB
~Get Your Files Here !/07 - Lesson 6. Pivot charts/001 6-solution.xlsx
2.4 MB
~Get Your Files Here !/07 - Lesson 6. Pivot charts/001 6.1. Column chart.mp4
56.5 MB
~Get Your Files Here !/07 - Lesson 6. Pivot charts/002 6.2. Line chart.mp4
41.5 MB
~Get Your Files Here !/07 - Lesson 6. Pivot charts/003 6.3. Combo chart and other charts.mp4
51.5 MB
~Get Your Files Here !/07 - Lesson 6. Pivot charts/004 6.4. DIY Combo chart.mp4
31.8 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/001 7-solution.xlsx
4.1 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/001 7.1. % of Grand total.mp4
23.8 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/002 7.2. % of Row total.mp4
18.7 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/003 7.3. % of Parent total.mp4
27 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/004 7.4. Year-on-Year % change.mp4
26.8 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/005 7.5. Running total.mp4
52.1 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/006 7.6. DIY Show values as.mp4
104 MB
~Get Your Files Here !/09 - Lesson 8. Calculated field/001 8-solution.xlsx
3.5 MB
~Get Your Files Here !/09 - Lesson 8. Calculated field/001 8.1. Calculated field - multiplication.mp4
39.5 MB
~Get Your Files Here !/09 - Lesson 8. Calculated field/002 8.2. Calculated field - division.mp4
60.6 MB
~Get Your Files Here !/09 - Lesson 8. Calculated field/003 8.3. Rounding and list of formulas.mp4
27.7 MB
~Get Your Files Here !/09 - Lesson 8. Calculated field/004 8.4. DIY Calculated Field.mp4
66.1 MB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9-solution.xlsx
49 KB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9.1. Dashboard part 1 – Sales KPI.mp4
16.9 MB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9.xlsx
22.5 KB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/002 9.2. Dashboard part 2 – Target realization %.mp4
11.8 MB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/003 9.3. Dashboard part 3 – Sales vs Target by years.mp4
22.7 MB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/004 9.4. Dashboard part 4 – Target deviation %.mp4
17.8 MB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/005 9.5. Dashboard part 5 – Filtering and dashboard design.mp4
22.5 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/001 10-solution.xlsx
2.9 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/001 10.1. Text slicer.mp4
45.8 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/002 10.2. Date filter From-To.mp4
24.1 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/003 10.3. Fiscal year slicer.mp4
39.7 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/004 10.4. Year and month slicer.mp4
29.2 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/005 10.5. Last day slicer.mp4
24.5 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/006 10.6. DIY Week of the year slicer.mp4
20 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11-solution.xlsx
4.1 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11.1. Distinct count.mp4
68.9 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11v2-solution.xlsx
2.4 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/002 11.2. Count in the calculated field.mp4
38.2 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/003 11.3. Calculated item.mp4
30.3 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/004 11.4. Calculated item on dates.mp4
53.8 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/005 11.5. GETPIVOTDATA formula.mp4
23.2 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/006 11.6. Sales vs Target as GETPIVOTDATA.mp4
15.4 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/007 11.7. Changing the aggregation of the subtotal.mp4
15.4 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8-solution.xlsx
17.2 KB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8. Product.mp4
9.1 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8.xlsx
8.7 KB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9-solution.xlsx
18.7 KB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9. Standard Deviation and Variance.mp4
17.2 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9.xlsx
8.8 KB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/010 11.10. Count Numbers.mp4
10.2 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/011 11.11. DIY Selecting a measure from the list.mp4
20.8 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/001 12-solution.xlsx
3.3 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/001 12.1. Histogram in a column-line chart.mp4
66.1 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/002 12.2. Conditional formatting.mp4
43.3 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/003 12.3. Calendar heat map.mp4
42.4 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/004 12.4. Cycle plot.mp4
18.2 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/005 12.5. Gantt chart.mp4
51.7 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/006 12.6. Constant line.mp4
15.6 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/007 12.7. TOP 5 vs Others on the pie chart.mp4
22.3 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/008 12.8. Cohort analysis.mp4
32.8 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/009 12.9. Scatter plot.mp4
38.4 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/010 12.10. Filled map.mp4
12.6 MB
~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/001 13.1. Power Query.mp4
33.3 MB
~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/002 13.2. Power Query animation.mp4
44.7 MB
~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/003 13.3. Power Pivot.mp4
