Udemy - The best Excel pivot tables course in the world

seeders: 10
leechers: 15
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ DevCourseWeb.com ] Udemy - The best Excel pivot tables course in the world
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 01 - How to learn Excel
    • 001 The New Excel Learning Curve.mp4 (57.4 MB)
    02 - Lesson 1. Introduction to pivot tables
    • 001 1-solution.xlsx (4.2 MB)
    • 001 1.1. My first pivot table.mp4 (83.4 MB)
    • 002 1.2. Insert a pivot table - DIY exercise.mp4 (28.0 MB)
    • 003 1.3. Pivot table refresh range vs table.mp4 (166.6 MB)
    • 004 1.4. How to prepare data for a pivot table.mp4 (58.2 MB)
    • 004 1.4.wrong-data-source-solution.xlsx (36.5 KB)
    • 004 1.4.wrong-data-source.xlsx (13.5 KB)
    03 - Lesson 2. Basic calculations in a pivot table
    • 001 2-solution.xlsx (3.4 MB)
    • 001 2.1. Sum, Count, Average.mp4 (83.7 MB)
    • 002 2.2. DIY Summarize values by.mp4 (36.0 MB)
    • 003 2.3-solution.xlsx (12.9 KB)
    • 003 2.3. How does the average work.mp4 (29.6 MB)
    • 003 2.3.xlsx (9.5 KB)
    • 004 2.4. Drill down - viewing the source data.mp4 (36.7 MB)
    04 - Lesson 3. Layout, formatting and sorting of a pivot table
    • 001 3-solution.xlsx (2.8 MB)
    • 001 3.1. Auto grouping (+ -), grand totals and subtotals.mp4 (50.3 MB)
    • 002 3.2. Changing the report layout.mp4 (48.4 MB)
    • 003 3.3. Automatic and manual sorting.mp4 (51.7 MB)
    • 004 3.4. DIY Pivot table layout.mp4 (53.7 MB)
    05 - Lesson 4. Grouping a pivot table
    • 001 4-solution.xlsx (2.4 MB)
    • 001 4.1. Manual grouping.mp4 (56.2 MB)
    • 002 4.2. Grouping dates.mp4 (54.2 MB)
    • 003 4.3-problem-with-dates.xlsx (14.9 KB)
    • 003 4.3-solution.xlsx (16.0 KB)
    • 003 4.3. Problems with date grouping.mp4 (13.7 MB)
    • 004 4.4. Grouping values.mp4 (29.6 MB)
    • 005 4.5. DIY Grouping TOP 5 vs Others.mp4 (35.8 MB)
    06 - Lesson 5. Filtering a pivot table
    • 001 5-solution.xlsx (2.6 MB)
    • 001 5.1. Filters shelf.mp4 (42.1 MB)
    • 002 5.2. Rows and columns filter - text, date, number.mp4 (100.4 MB)
    • 003 5.3. Value filter and TOP N filter.mp4 (57.2 MB)
    • 004 5.4. Generate report filter pages.mp4 (23.4 MB)
    • 005 5.5. Slicer.mp4 (122.5 MB)
    • 006 5.6. Timeline.mp4 (19.1 MB)
    • 007 5.7. DIY Week slicer.mp4 (28.0 MB)
    07 - Lesson 6. Pivot charts
    • 001 6-solution.xlsx (2.4 MB)
    • 001 6.1. Column chart.mp4 (56.5 MB)
    • 002 6.2. Line chart.mp4 (41.5 MB)
    • 003 6.3. Combo chart and other charts.mp4 (51.5 MB)
    • 004 6.4. DIY Combo chart.mp4 (31.8 MB)
    08 - Lesson 7. Show values as
    • 001 7-solution.xlsx (4.1 MB)
    • 001 7.1. % of Grand total.mp4 (23.8 MB)
    • 002 7.2. % of Row total.mp4 (18.7 MB)
    • 003 7.3. % of Parent total.mp4 (27.0 MB)
    • 004 7.4. Year-on-Year % change.mp4 (26.8 MB)
    • 005 7.5. Running total.mp4 (52.1 MB)
    • 006 7.6. DIY Show values as.mp4 (104.0 MB)
    09 - Lesson 8. Calculated field
    • 001 8-solution.xlsx (3.5 MB)
    • 001 8.1. Calculated field - multiplication.mp4 (39.5 MB)
    • 002 8.2. Calculated field - division.mp4 (60.6 MB)
    • 003 8.3. Rounding and list of formulas.mp4 (27.7 MB)
    • 004 8.4. DIY Calculated Field.mp4 (66.1 MB)
    10 - Lesson 9. Designing a dashboard on pivot tables
    • 001 9-solution.xlsx (49.0 KB)
    • 001 9.1. Dashboard part 1 – Sales KPI.mp4 (16.9 MB)
    • 001 9.xlsx (22.5 KB)
    • 002 9.2. Dashboard part 2 – Target realization %.mp4 (11.8 MB)
    • 003 9.3. Dashboard part 3 – Sales vs Target by years.mp4 (22.7 MB)
    • 004 9.4. Dashboard part 4 – Target deviation %.mp4 (17.8 MB)
    • 005 9.5. Dashboard part 5 – Filtering and dashboard design.mp4 (22.5 MB)
    11 - Lesson 10. Advanced slicers and filtering
    • 001 10-solution.xlsx (2.9 MB)
    • 001 10.1. Text slicer.mp4 (45.8 MB)
    • 002 10.2. Date filter From-To.mp4 (24.1 MB)
    • 003 10.3. Fiscal year slicer.mp4 (39.7 MB)
    • 004 10.4. Year and month slicer.mp4 (29.2 MB)
    • 005 10.5. Last day slicer.mp4 (24.5 MB)
    • 006 10.6. DIY Week of the year slicer.mp4 (20.0 MB)
    12 - Lesson 11. Advanced calculations
    • 001 11-solution.xlsx (4.1 MB)
    • 001 11.1. Distinct count.mp4 (68.9 MB)
    • 001 11v2-solution.xlsx (2.4 MB)
    • 002 11.2. Count in the calculated field.mp4 (38.2 MB)
    • 003 11.3. Calculated item.mp4 (30.3 MB)
    • 004 11.4. Calculated item on dates.mp4 (53.8 MB)
    • 005 11.5. GETPIVOTDATA formula.mp4 (23.2 MB)
    • 006 11.6. Sales vs Target as GETPIVOTDATA.mp4 (15.4 MB)
    • 007 11.7. Changing the aggregation of the subtotal.mp4 (15.4 MB)
    • 008 11.8-solution.xlsx (17.2 KB)
    • 008 11.8. Product.mp4 (9.1 MB)
    • 008 11.8.xlsx (8.7 KB)
    • 009 11.9-solution.xlsx (18.7 KB)
    • 009 11.9. Standard Deviation and Variance.mp4 (17.2 MB)
    • 009 11.9.xlsx (8.8 KB)
    • 010 11.10. Count Numbers.mp4 (10.2 MB)
    • 011 11.11. DIY Selecting a measure from the list.mp4 (20.8 MB)
    13 - Lesson 12. Advanced pivot charts
    • 001 12-solution.xlsx (3.3 MB)
    • 001 12.1. Histogram in a column-line chart.mp4 (66.1 MB)
    • 002 12.2. Conditional formatting.mp4 (43.3 MB)
    • 003 12.3. Calendar heat map.mp4 (42.4 MB)
    • 004 12.4. Cycle plot.mp4 (18.2 MB)
    • 005 12.5. Gantt chart.mp4 (51.7 MB)
    • 006 12.6. Constant line.mp4 (15.6 MB)
    • 007 12.7. TOP 5 vs Others on the pie chart.mp4 (22.3 MB)
    • 008 12.8. Cohort analysis.mp4 (32.8 MB)
    • 009 12.9. Scatter plot.mp4 (38.4 MB)
    • 010 12.10. Filled map.mp4 (12.6 MB)
    14 - Lesson 13. Power tools for the pivot table user
    • 001 13.1. Power Query.mp4 (33.3 MB)
    • 002 13.2. Power Query animation.mp4 (44.7 MB)
    • 003 13.3. Power Pivot.mp4 (12.7 MB)

Description

The best Excel pivot tables course in the world



https://DevCourseWeb.com

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 87 lectures (5h 45m) | Size: 2.93 GB

Easily create pivot tables, charts & dashboards

What you'll learn
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).



Download torrent
3.1 GB
seeders:10
leechers:15
Udemy - The best Excel pivot tables course in the world

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
3.1 GB
seeders:10
leechers:15
Udemy - The best Excel pivot tables course in the world

Torrent hash: 786C9288619EB2AF48C97303868EC436B407A7CF