Udemy - Introduction to Excel Pivot Tables

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

Files

[ CoursePig.com ] Udemy - Introduction to Excel Pivot Tables
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction
    • 1. What you will learn in this course.mp4 (10.4 MB)
    • 1. What you will learn in this course.srt (2.0 KB)
    • 2. Data Summarize & Dashboards.mp4 (14.0 MB)
    • 2. Data Summarize & Dashboards.srt (1.8 KB)
    • 3. Pivot Table Terminology.mp4 (50.5 MB)
    • 3. Pivot Table Terminology.srt (6.1 KB)
    • 3.1 03 - Pivot Table Terminology.xlsx (5.3 MB)
    2. Creating your first Pivot Table
    • 1. Inserting Pivot Table.mp4 (51.5 MB)
    • 1. Inserting Pivot Table.srt (4.1 KB)
    • 1.1 Creating a Pivot Table.pdf (350.5 KB)
    • 1.2 Pivot Table.xlsx (4.2 MB)
    • 2. Drag Drop & Slice Dice.mp4 (36.2 MB)
    • 2. Drag Drop & Slice Dice.srt (4.3 KB)
    • 2.1 05 - Drag Drop & Slice Dice.xlsx (5.2 MB)
    • 2.2 Drag Drop & Slice Dice in Pivot Table.pdf (533.7 KB)
    3. Implementing Calculations in Pivot Tables
    • 1. Using GETPIVOTDATA Function.mp4 (46.1 MB)
    • 1. Using GETPIVOTDATA Function.srt (5.5 KB)
    • 1.1 06 - Using GETPIVOTDATA Function - Jul 4 2019 7_34 PM.xlsx (5.2 MB)
    • 1.2 GetPivotData Function in Pivot Table.pdf (379.6 KB)
    • 2. Field Settings or Value Field Settings.mp4 (36.6 MB)
    • 2. Field Settings or Value Field Settings.srt (4.4 KB)
    • 2.1 Value Field Setting in Pivot Table.pdf (400.3 KB)
    • 3. Creating Calculated Fields & Calculated Items in Pivot Tables.mp4 (60.7 MB)
    • 3. Creating Calculated Fields & Calculated Items in Pivot Tables.srt (5.0 KB)
    • 3.1 08 - Creating Calculated Fields & Calculated Items in Pivot Tables.xlsx (169.3 KB)
    • 3.2 Calculated Field and Calculated Item in Pivot Table.pdf (436.9 KB)
    • 4. Groups & Subtotals with Pivot Tables.mp4 (44.2 MB)
    • 4. Groups & Subtotals with Pivot Tables.srt (5.6 KB)
    • 4.1 09 - Groups & Subtotals with Pivot Tables.xlsx (5.3 MB)
    • 4.2 Groups and SubTotals with Pivot Table.pdf (422.0 KB)
    • 5. Calculating percent for subtotals in a Pivot Table.mp4 (47.7 MB)
    • 5. Calculating percent for subtotals in a Pivot Table.srt (6.0 KB)
    • 5.1 10 - Calculating percent for subtotals in a Pivot Table.xlsx (5.3 MB)
    • 5.2 Calculate percentage for subtotals in a PivotTable Pivot Table.pdf (416.7 KB)
    4. Page Filters, Slicers & Timelines
    • 1. Page Filter.mp4 (11.3 MB)
    • 1. Page Filter.srt (1.4 KB)
    • 1.1 11 - Page Filter.xlsx (164.4 KB)
    • 1.2 Page Filter in Pivot Table.pdf (388.2 KB)
    • 2. Using Slicers with Pivot Tables.mp4 (28.5 MB)
    • 2. Using Slicers with Pivot Tables.srt (2.8 KB)
    • 2.1 12 - Using Slicers with Pivot Tables.xlsx (169.5 KB)
    • 2.2 Slicers in Pivot Table.pdf (352.1 KB)
    • 3. Value & Label Filters.mp4 (17.7 MB)
    • 3. Value & Label Filters.srt (2.0 KB)
    • 3.1 13 - Using Value & Label Filters.xlsx (165.0 KB)
    • 4. Using Timelines with Pivot Tables.mp4 (38.2 MB)
    • 4. Using Timelines with Pivot Tables.srt (4.3 KB)
    • 4.1 14 - Using Timelines with Pivot Tables.xlsx (5.3 MB)
    • 4.2 Timeline in Pivot Table.pdf (438.4 KB)
    5. Formatting a Pivot Table
    • 1. Changing Pivot Table Style.mp4 (46.6 MB)
    • 1. Changing Pivot Table Style.srt (4.4 KB)
    • 1.1 15 - Changing Pivot Table Style.xlsx (181.6 KB)
    • 1.2 Changing Pivot Table Style.pdf (401.5 KB)
    • 2. Changing Field Formatting.mp4 (19.3 MB)
    • 2. Changing Field Formatting.srt (1.9 KB)
    6. Using Pivot Charts
    • 1. One Shortcut to Create Pivot Chart out of Pivot Table.mp4 (12.6 MB)
    • 1. One Shortcut to Create Pivot Chart out of Pivot Table.srt (1.7 KB)
    • 1.1 17 - One Shortcut to Create Pivot Chart out of Pivot Table.xlsx (170.4 KB)
    • 1.2 Creating Pivot Chart out of Pivot Table.pdf (371.6 KB)
    7. Creating Dashboard using Pivot Tables
    • 1. Creating Dashboard using Pivot Tables.mp4 (113.4 MB)
    • 1. Creating Dashboard using Pivot Tables.srt (10.7 KB)
    • 1.1 18 - Creating Dashboard using Pivot Tables.xlsx (7.9 MB)
    • 1.2 Creating Dashboard using Pivot Table.pdf (869.6 KB)
    • Bonus Resources.txt (0.4 KB)

Description

Introduction to Excel Pivot Tables



https://CoursePig.com

Last updated 06/2020
Duration: 1h 4m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 735 MB
Genre: eLearning | Language: English

Learn Pivot Tables from scratch, applying calculations, applying formatting & combining multiple Pivots.

What you'll learn
Understand how Excel represents data in different forms
Learn how to create Pivot Table from scratch
Understand how to effectively use Excel Pivot Tables
Ad-hoc analysis of using multiple Pivot Tables
Creating Dashboard by using multiple Pivot Tables
Requirements
Understanding of basic Excel
Description
Want to learn how to use Excel Pivot Tables? You can!
This Introductory course will teach you the basics for working with Pivot Tables and It will equip you with the skills needed for creating Pivot Tables from scratch to the extent that you can create a Dashboard using Pivot Tables.
We’ll start with some basic concepts and terminology. Then we’ll provide an easy to follow example using some fairly straightforward data and develop a pivot table and a pivot chart. We’ll then move into performing calculations using Pivot Tables, you will learn how to pull data using GETPIVOTDATA function, you will learn to apply formatting to the Pivot Table, you will learn to use Slicers & Timelines and finally you will create a Dashboard on the fly.
By the end of the course, you'll be confident using Pivot Tables on the data that you use every day.

Who this course is for
Business Users
Beginner of Microsoft Excel
Want to understand Data Analysis using Excel



Download torrent
735.7 MB
seeders:17
leechers:5
Udemy - Introduction to Excel Pivot Tables

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
735.7 MB
seeders:17
leechers:5
Udemy - Introduction to Excel Pivot Tables

Torrent hash: 2E63E64C901435B7774352E220C0CD94DE2F21C1