[GigaCourse.com] Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables

Other

Size

1.4 GB

Seeders

Leechers

Files

Category

Other

Added

04/01/20 at 8:51am GMT+1

Status

Verified by VeriPLUS

Infohash

1d5657804fcf68cd4d73af576a284827e26d17c0

Direct link Torrent file Download now

Description

Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables

Description

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Pivot Table course:

"This is a great Excel course. You can feel confident putting these skills on your resume, and the lectures are in-depth and easy to follow. I would highly recommend this course to anyone who wants to not just LEARN Excel Pivot Tables, but become a true Pivot Table EXPERT"

-Monique C.

"Chris provides clear, detailed explanations and shows how to use Excel Pivot Tables to extract hidden details and facts using raw, real-life data sets in Excel. The quizzes and homework reinforce the lessons and the course layout makes it easy to go back to sections that need revision. This course is exactly what I was looking for to master Excel Pivot Tables. Thanks, Chris!"

-Paul M.

"One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. I have added other Excel and Pivot Table courses from Chris & Maven Analytics and look forward to viewing them as well."

-Ernie A.

__________

FULL COURSE DESCRIPTION:

Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel.

Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates, or wondering how condo prices have trended over the past 10 years, Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:

Raw data structure in Excel
Pivot Table layouts & styles
Design & formatting options
Sorting, filtering, & grouping tools
Calculated fields, items & values
Pivot Charts, slicers & timelines
Interactive Excel dashboards

__________

We'll then explore and analyze Excel datasets from a number of real-world case studies, including:

San Diego burrito ratings
Shark attack records from 1900-2016
Facebook Post data from Spartan Race
Major League Baseball team statistics
San Francisco employee salaries
Daily stock market data
IMDb movie ratings
Apple Store mobile app ratings
Wine ratings and descriptions

__________

Microsoft Excel - Data Analysis with Excel Pivot Tables Whether you're looking for a quick Excel Pivot Table primer, trying to diversify your Excel skill set, or hoping to step up your analytics game in a major way, you've come to the right place. In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand, and those with the ability to transform data into insight are leading the charge. Enroll today and start your journey to becoming an Excel analytics pro!

See you there!

-Chris (Founder, Excel Maven & Maven Analytics)

__________

NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.

__________

P.S. Looking to master the full Microsoft Excel, Power BI + SQL stack? Search for "Maven Analytics" and complete the courses below to become a business intelligence ROCKSTAR:

Excel Pro Tips for Power Users
Advanced Excel Formulas & Functions
Data Visualization with Excel Charts & Graphs
Data Analysis with Excel PivotTables
Excel Power Query, Power Pivot & DAX
Up & Running with Power BI Desktop
Publishing to Power BI Service
SQL Database Analysis for Beginners
Advanced MySQL for Analytics & Business Intelligence

Created by Maven Analytics, Chris Dutton
Last updated 3/2020
English
English [Auto-generated]

File list

[GigaCourse.com] Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables
1. Getting Started/1. Course Structure & Outline.mp4 6.8 MB
1. Getting Started/1. Course Structure & Outline.srt 5.4 KB
1. Getting Started/2. READ ME Important Notes for New Students.html 4.4 KB
1. Getting Started/3. DOWNLOAD Course Resources.html 486 B
1. Getting Started/3.1 IMDb Movie Database.xlsx.xlsx 459.6 KB
1. Getting Started/3.2 Excel_PivotTable_Slides.pdf.pdf 2.3 MB
1. Getting Started/3.3 2016_Movies.xlsx.xlsx 9.8 KB
1. Getting Started/4. Getting to Know the IMDb Movie Database.mp4 9.3 MB
1. Getting Started/4. Getting to Know the IMDb Movie Database.srt 3.5 KB
1. Getting Started/5. Setting Expectations.mp4 2.2 MB
1. Getting Started/5. Setting Expectations.srt 1.8 KB
2. Excel Pivot Table 101/1. Why Pivot Tables.mp4 7.7 MB
2. Excel Pivot Table 101/1. Why Pivot Tables.srt 6.4 KB
2. Excel Pivot Table 101/10. PRO TIP Dealing with Growing Source Data.mp4 28 MB
2. Excel Pivot Table 101/10. PRO TIP Dealing with Growing Source Data.srt 8.6 KB
2. Excel Pivot Table 101/11. Removing & Reviving Data from the Pivot Table Cache.mp4 59 MB
2. Excel Pivot Table 101/11. Removing & Reviving Data from the Pivot Table Cache.srt 7.9 KB
2. Excel Pivot Table 101/12. PRO TIP How Excel Pivot Tables ACTUALLY Work.mp4 8 MB
2. Excel Pivot Table 101/12. PRO TIP How Excel Pivot Tables ACTUALLY Work.srt 4.9 KB
2. Excel Pivot Table 101/13. QUIZ Excel Pivot Table 101.html 147 B
2. Excel Pivot Table 101/14. HOMEWORK Excel Pivot Table 101.html 3.3 KB
2. Excel Pivot Table 101/2. Structuring Source Data for Analysis in Excel.mp4 4.2 MB
2. Excel Pivot Table 101/2. Structuring Source Data for Analysis in Excel.srt 2.9 KB
2. Excel Pivot Table 101/3. Creating Your First Pivot Table.mp4 10.7 MB
2. Excel Pivot Table 101/3. Creating Your First Pivot Table.srt 4.5 KB
2. Excel Pivot Table 101/4. IMPORTANT Add to Data Model.html 1.1 KB
2. Excel Pivot Table 101/5. Navigating the Pivot Table Field List.mp4 15.7 MB
2. Excel Pivot Table 101/5. Navigating the Pivot Table Field List.srt 10.9 KB
2. Excel Pivot Table 101/6. KNOWLEDGE CHECK Manipulating the Pivot Table Field List.html 1.8 KB
2. Excel Pivot Table 101/7. Exploring Pivot Table Analyze & Design Options.mp4 3.4 MB
2. Excel Pivot Table 101/7. Exploring Pivot Table Analyze & Design Options.srt 2.2 KB
2. Excel Pivot Table 101/8. Selecting, Clearing, Moving & Copying Pivot Tables.mp4 10.8 MB
2. Excel Pivot Table 101/8. Selecting, Clearing, Moving & Copying Pivot Tables.srt 7.9 KB
2. Excel Pivot Table 101/9. Refreshing & Updating Pivot Tables.mp4 25.7 MB
2. Excel Pivot Table 101/9. Refreshing & Updating Pivot Tables.srt 9.9 KB
3. Formatting Data with Pivot Tables/1. Changing Pivot Table Number Formats.mp4 4.7 MB
3. Formatting Data with Pivot Tables/1. Changing Pivot Table Number Formats.srt 3.4 KB
3. Formatting Data with Pivot Tables/10. HOMEWORK Excel Pivot Table Formatting.html 2.8 KB
3. Formatting Data with Pivot Tables/2. PRO TIP Formatting Empty Pivot Table Cells.mp4 4 MB
3. Formatting Data with Pivot Tables/2. PRO TIP Formatting Empty Pivot Table Cells.srt 2.5 KB
3. Formatting Data with Pivot Tables/3. Configuring Pivot Table Layouts & Styles.mp4 12.8 MB
3. Formatting Data with Pivot Tables/3. Configuring Pivot Table Layouts & Styles.srt 8 KB
3. Formatting Data with Pivot Tables/4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.mp4 5.9 MB
3. Formatting Data with Pivot Tables/4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.srt 3.1 KB
3. Formatting Data with Pivot Tables/5. Customizing Pivot Table Headers & Labels.mp4 2.5 MB
3. Formatting Data with Pivot Tables/5. Customizing Pivot Table Headers & Labels.srt 1.9 KB
3. Formatting Data with Pivot Tables/6. Applying Basic Conditional Formats to Pivot Tables.mp4 18.6 MB
3. Formatting Data with Pivot Tables/6. Applying Basic Conditional Formats to Pivot Tables.srt 9.6 KB
3. Formatting Data with Pivot Tables/7. PRO TIP Adding Data Bars with Invisible Text.mp4 5.2 MB
3. Formatting Data with Pivot Tables/7. PRO TIP Adding Data Bars with Invisible Text.srt 3.3 KB
3. Formatting Data with Pivot Tables/8. Applying Advanced Conditional Formats to Pivot Tables.mp4 68.3 MB
3. Formatting Data with Pivot Tables/8. Applying Advanced Conditional Formats to Pivot Tables.srt 9.4 KB
3. Formatting Data with Pivot Tables/9. QUIZ Excel Pivot Table Formatting.html 147 B
4. Sorting, Filtering & Grouping Data with Pivot Tables/1. Sorting Data with Pivot Tables.mp4 12.1 MB
4. Sorting, Filtering & Grouping Data with Pivot Tables/1. Sorting Data with Pivot Tables.srt 7.1 KB
4. Sorting, Filtering & Grouping Data with Pivot Tables/10. Breaking Out Pivot Table Report Filter Pages.mp4 9.3 MB
4. Sorting, Filtering & Grouping Data with Pivot Tables/10. Breaking Out Pivot Table Report Filter Pages.srt 5.7 KB
4. Sorting, Filtering & Grouping Data with Pivot Tables/11. QUIZ Sorting, Filtering & Grouping Data with Excel Pivot Tables.html 147 B
4. Sorting, Filtering & Grouping Data with Pivot Tables/12. HOMEWORK Sorting, Filtering & Grouping Data with Excel Pivot Tables.html 2.6 KB
4. Sorting, Filtering & Grouping Data with Pivot Tables/2. PRO TIP Fixing Incorrect Alphabetical Sorting.mp4 5.8 MB
4. Sorting, Filtering & Grouping Data with Pivot Tables/2. PRO TIP Fixing Incorrect Alphabetical Sorting.srt 2.9 KB
4. Sorting, Filtering & Grouping Data with Pivot Tables/3. Filtering Data with Pivot Table Label & Selection Filters.mp4 21 MB
4. Sorting, Filtering & Grouping Data with Pivot Tables/3. Filtering Data with Pivot Table Label & Selection Filters.srt 11.7 KB
4. Sorting, Filtering & Grouping Data with Pivot Tables/4. PRO TIP Pivot Table Label Filters with Wildcards.mp4 10.4 MB
4. Sorting, Filtering & Grouping Data with Pivot Tables/4. PRO TIP Pivot Table Label Filters with Wildcards.srt 5 KB
4. Sorting, Filtering & Grouping Data with Pivot Tables/5. Filtering Data with Pivot Table Value Filters.mp4 7.4 MB
4. Sorting, Filtering & Grouping Data with Pivot Tables/5. Filtering Data with Pivot Table Value Filters.srt 4.1 KB
4. Sorting, Filtering & Grouping Data with Pivot Tables/6. PRO TIP Enabling Multiple Pivot Table Filters.mp4 7.9 MB
4. Sorting, Filtering & Grouping Data with Pivot Tables/6. PRO TIP Enabling Multiple Pivot Table Filters.srt 3.6 KB
4. Sorting, Filtering & Grouping Data with Pivot Tables/7. Grouping & Segmenting Data with Pivot Tables.mp4 9.6 MB
4. Sorting, Filtering & Grouping Data with Pivot Tables/7. Grouping & Segmenting Data with Pivot Tables.srt 4.5 KB
4. Sorting, Filtering & Grouping Data with Pivot Tables/8. PRO TIP Enabling & Disabling Automatic Date Grouping.mp4 10.7 MB
4. Sorting, Filtering & Grouping Data with Pivot Tables/8. PRO TIP Enabling & Disabling Automatic Date Grouping.srt 6.4 KB
4. Sorting, Filtering & Grouping Data with Pivot Tables/9. Filtering Data with Pivot Table Slicers & Timelines.mp4 10.3 MB
4. Sorting, Filtering & Grouping Data with Pivot Tables/9. Filtering Data with Pivot Table Slicers & Timelines.srt 6.6 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/1. Aggregating & Summarizing Data with Pivot Tables.mp4 9.1 MB
5. Enriching Data with Pivot Table Calculated Values & Fields/1. Aggregating & Summarizing Data with Pivot Tables.srt 6.8 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/10. KNOWLEDGE CHECK Pivot Table Value Calculations.html 1 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/11. Defining Calculated Fields with Pivot Tables.mp4 14.9 MB
5. Enriching Data with Pivot Table Calculated Values & Fields/11. Defining Calculated Fields with Pivot Tables.srt 8.6 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/12. Creating Calculated Fields in Pivot Tables vs. Source Data.mp4 10.4 MB
5. Enriching Data with Pivot Table Calculated Values & Fields/12. Creating Calculated Fields in Pivot Tables vs. Source Data.srt 6.1 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).mp4 16.6 MB
5. Enriching Data with Pivot Table Calculated Values & Fields/13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).srt 9.7 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).mp4 9.9 MB
5. Enriching Data with Pivot Table Calculated Values & Fields/14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).srt 5.7 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).mp4 11.8 MB
5. Enriching Data with Pivot Table Calculated Values & Fields/15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).srt 8.4 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/16. Generating Solve Order & List Formulas Reports.mp4 10.1 MB
5. Enriching Data with Pivot Table Calculated Values & Fields/16. Generating Solve Order & List Formulas Reports.srt 6.7 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/17. QUIZ Enriching Data with Pivot Table Calculated Values & Fields.html 147 B
5. Enriching Data with Pivot Table Calculated Values & Fields/18. HOMEWORK Enriching Data with Pivot Table Calculated Values & Fields.html 3.5 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/2. PRO TIP Avoiding the Pivot Table Count Of Trap.mp4 9.8 MB
5. Enriching Data with Pivot Table Calculated Values & Fields/2. PRO TIP Avoiding the Pivot Table Count Of Trap.srt 5.4 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/3. Defining Value Calculations with Pivot Tables.mp4 6.5 MB
5. Enriching Data with Pivot Table Calculated Values & Fields/3. Defining Value Calculations with Pivot Tables.srt 5.2 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/4. Calculating Pivot Table Values % of ColumnRow.mp4 8.6 MB
5. Enriching Data with Pivot Table Calculated Values & Fields/4. Calculating Pivot Table Values % of ColumnRow.srt 5.3 KB
5. Enriching Data with Pivot Table Calculated Values & Fields/5. Calculating Pivot Table Values % of Parent.mp4 6.7 MB

Rating

Not rated yet

Comments

No comments yet.

Similar torrents

Name	Size	Date
[DesireCourse.Com] Udemy - Microsoft Excel - The Xtreme Excel Pivot Tables Course Verified in Other	1.4 GB	12/28/18	3	0
[GigaCourse.Com] Udemy - Microsoft Excel - Data Visualization, Excel Charts & Graphs Verified in Other	1.5 GB	01/16/24	2	0
[DesireCourse.Com] Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables Verified in Other	1.1 GB	10/30/18	0	0
[FreeCourseLab.com] Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables Verified in Other	1.1 GB	11/27/18	0	1
[FreeCourseSite.com] Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables in Other	1.1 GB	12/20/18	0	1
Microsoft Excel - Data Analysis with Excel Pivot Tables Verified in Other	1.4 GB	12/29/18	0	1
[DesireCourse.Com] Udemy - Microsoft Excel - Master Data Analysis, Pivot Tables and BI Verified in Other	2.5 GB	01/02/19	0	1
Udemy - Learn Excel Data Analysis with Interactive Excel Dashboards Verified in Other	3.3 GB	05/13/19	0	1
Excel Pivot Table Champion- How to Easily Manage and Analyze Giant Databases with Micro ... Verified in eBooks	1 MB	06/24/19	0	1
MindMekka.com - Reports and Data Analysis with Excel Pivot Tables in Other	760 MB	07/16/19	0	0
Udemy - Microsoft Excel 2013- Excel Data Analysis- Beginner Excel Verified in Other	690 MB	09/03/19	0	0
Udemy - Microsoft Excel - Excel with Power Pivot & DAX Formulas Verified in Other	747 MB	11/01/19	0	1
Udemy - Microsoft Excel - Excel with Power Pivot & DAX Formulas (Updated) Verified in Other	86 kB	11/08/19	0	1
Udemy - Microsoft Excel - Excel with Power Pivot & DAX Formulas (Updated) Verified in Other	1.1 GB	11/08/19	0	1
Udemy - Microsoft Excel - Excel with Pivot Tables & Data Analysis Verified in Other	3.1 GB	11/17/19	0	1