Udemy - Introduction to Tables and Pivot Tables in Excel
- Category Other
- Type Tutorials
- Language English
- Total size 2.2 GB
- Uploaded By freecoursewb
- Downloads 292
- Last checked 1 day ago
- Date uploaded 5 months ago
- Seeders 13
- Leechers 6
Introduction to Tables and Pivot Tables in Excel
https://WebToolTip.com
Published 8/2025
Created by CreateMyExcel with Ben Scholl
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English | Duration: 30 Lectures ( 1h 4m ) | Size: 2.2 GB
Learn to organize, analyze, and summarize data efficiently using Excel Tables and Pivot Tables.
What you'll learn
Learn to sort table data using simple and partial field sorting techniques.
Use the SORT and SORTBY functions to organize data dynamically in arrays.
Filter table data using basic and complex criteria for precise results.
Apply the FILTER function to extract specific data sets from tables.
Use the UNIQUE function to find distinct values within data tables.
Reference tables in formulas to simplify calculations and improve accuracy.
Analyze data with DAVERAGE and DGET to perform database-style queries.
Perform statistical analysis using case studies on real defect databases.
Create and customize PivotTables for advanced data summarization.
Use calculated fields and items in PivotTables to enhance data insights.
Requirements
Microsoft Excel (Office 2021 or Microsoft 365) installed.
Basic knowledge of Excel (e.g., entering data, simple calculations).
Access to a computer with a stable internet connection.
No prior advanced Excel skills required; suitable for beginners.
Files:
[ WebToolTip.com ] Udemy - Introduction to Tables and Pivot Tables in Excel- Get Bonus Downloads Here.url (0.2 KB) ~Get Your Files Here ! 1 - Analyzing Data with Tables
- 1 -Analyzing Data with Tables - Complete.xlsx (519.5 KB)
- 1 -Analyzing Data with Tables - Teaching File.xlsx (514.7 KB)
- 1 -Analyzing Data with Tables.mp4 (14.8 MB)
- 1 -Analyzing Data with Tables.pptx (1.1 GB)
- 10 -Complex Criteria, Entering a Compound Criteria.mp4 (17.6 MB)
- 11 -Filtering Table Data with The FILTER Function.mp4 (12.3 MB)
- 12 -UNIQUE Function.mp4 (9.5 MB)
- 13 -Referencing Tables in Formulas.mp4 (45.2 MB)
- 14 -Enterting Table Formulas.mp4 (21.9 MB)
- 15 -Excel's Table Functions.mp4 (13.3 MB)
- 16 -Using DAVERAGE.mp4 (17.0 MB)
- 17 -Using DGET.mp4 (20.0 MB)
- 18 -Case Study; Statistical Analysis of a Defects Database.mp4 (172.3 MB)
- 2 -Sorting a Table.mp4 (15.8 MB)
- 3 -Sorting on Part of a Field.mp4 (21.6 MB)
- 4 -Sorting Without Articles.mp4 (54.9 MB)
- 5 -Sorting Table Data into an Array, Part I; The SORT Function.mp4 (11.6 MB)
- 6 -Sorting Table Data into an Array, Part II; The SORTBY Function.mp4 (15.8 MB)
- 7 -Filtering Table Data.mp4 (13.4 MB)
- 8 -Complex Criteria, Setting Up a Criteria Range.mp4 (19.6 MB)
- 9 -Complex Criteria, Filtering a Table with a Criteria Range.mp4 (13.1 MB)
- 1 -Analyzing Data with PivotTables - Complete.xlsm (778.7 KB)
- 1 -Analyzing Data with PivotTables - Teaching File.xlsm (777.2 KB)
- 1 -Analyzing Data with PivotTables.mp4 (17.9 MB)
- 1 -Analyzing Data with PivotTables.pptx (412.8 MB)
- 10 -Creating Custom PivotTable Calculations.mp4 (16.8 MB)
- 11 -Creating a Calculated Item.mp4 (33.4 MB)
- 12 -Using PivotTable Results in a Worksheet Formula.mp4 (15.3 MB)
- 2 -Hiding PivotTable Grand Totals.mp4 (8.3 MB)
- 3 -Hiding PivotTable Subtotals.mp4 (6.9 MB)
- 4 -Customizing The Subtotal Calculation.mp4 (15.3 MB)
- 5 -Changing The Value Field Summary Calculation.mp4 (9.3 MB)
- 6 -Using a Difference Summary Calculation.mp4 (15.1 MB)
- 7 -Using a Percentage Summary Calculation.mp4 (23.3 MB)
- 8 -Using a Running Total Summary Calculation.mp4 (10.9 MB)
- 9 -Using an Index Summary Calculation.mp4 (14.0 MB)
- Bonus Resources.txt (0.1 KB)
There are currently no comments. Feel free to leave one :)
Code:
- 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