Udemy - Introduction to Tables and Pivot Tables in Excel

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.