| 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 | ||
| 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 | ||
| 10 -Creating Custom PivotTable Calculations.mp4 | 16.8 MB | ||
| 11 -Creating a Calculated Item.mp4 | 33.4 MB | ||
| 11 -Filtering Table Data with The FILTER Function.mp4 | 12.3 MB | ||
| 12 -UNIQUE Function.mp4 | 9.5 MB | ||
| 12 -Using PivotTable Results in a Worksheet Formula.mp4 | 15.3 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 MB | ||
| 17 -Using DGET.mp4 | 20 MB | ||
| 18 -Case Study; Statistical Analysis of a Defects Database.mp4 | 172.3 MB | ||
| 2 -Hiding PivotTable Grand Totals.mp4 | 8.3 MB | ||
| 2 -Sorting a Table.mp4 | 15.8 MB | ||
| 3 -Hiding PivotTable Subtotals.mp4 | 6.9 MB | ||
| 3 -Sorting on Part of a Field.mp4 | 21.6 MB | ||
| 4 -Customizing The Subtotal Calculation.mp4 | 15.3 MB | ||
| 4 -Sorting Without Articles.mp4 | 54.9 MB | ||
| 5 -Changing The Value Field Summary Calculation.mp4 | 9.3 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 | ||
| 6 -Using a Difference Summary Calculation.mp4 | 15.1 MB | ||
| 7 -Filtering Table Data.mp4 | 13.4 MB | ||
| 7 -Using a Percentage Summary Calculation.mp4 | 23.3 MB | ||
| 8 -Complex Criteria, Setting Up a Criteria Range.mp4 | 19.6 MB | ||
| 8 -Using a Running Total Summary Calculation.mp4 | 10.9 MB | ||
| 9 -Complex Criteria, Filtering a Table with a Criteria Range.mp4 | 13.1 MB | ||
| 9 -Using an Index Summary Calculation.mp4 | 14 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 38 total files | |||
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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.1 GB | freecoursewb | 1 week | 25 | 24 | |
| 3.8 GB | freecoursewb | 3 weeks | 4 | 5 | |
| 1.6 GB | freecoursewb | 3 weeks | 5 | 3 | |
| 1.6 GB | freecoursewb | 3 weeks | 9 | 4 | |
| 649 MB | freecoursewb | 3 weeks | 10 | 3 |
All Comments