Master Microsoft Excel 2025 Pivot Tables for Data Analysis.

Learn to designate data as a formal table in Excel, name the table, enable headers, apply table design options, and add a subtotal row with customizable functions.

Remove duplicates in Excel tables by using the remove duplicates tool and selecting the sales number column. Excel reports three duplicates found and 62 unique values remain.

Explore how to manage automation settings in Excel 2023, turning off or on automatic table range updates and formula replication for new rows, via files, options, proofing, and autocorrect.

Learn how structured referencing in Excel tables replaces cell addresses with field names, creating readable, automatically replicated formulas for totals and profits, and enabling easier filtering and pivot table workflows.

Master pivot tables by learning how to create, reconfigure, and analyze sales data in Excel, using a sample sales listing table to explore time-based and cross-tab analyses, totals, and averages.

Create and customize a pivot table in Excel to analyze data by placing product families and branches in rows and columns, applying currency formatting and value settings.

Explore how pivot tables auto filter fields in columns and rows, using label filters and global filters to display a subset of data by year, product, and branch.

Learn to reconfigure pivot tables by adding levels to rows, columns, and filters with region and branch groupings, apply filters, collapse or expand groups, and switch from sum to average.

Explore how pivot table layouts affect group and item placement, including compact, outline, and tabular forms, and learn when to repeat labels and insert blank rows.

Open and adjust field settings in a pivot table, including rows, columns, and filters, and rename subtotals while applying sum, count, and average across product families.

Create a pivot table with month rows and year columns, include total cost, total sales, profit; add calculated fields for margin over revenue and margin over cost; apply branch filters.

Explore how to group dates in Excel pivot tables, automatically create year, quarter, and month levels, and adjust grouping with days, filters, and the Analyze tab.

Learn how slicers extend pivot table filtering by using any field, not just those in the pivot. Add slicers for year and product family to filter dynamically and combine selections.

Explore how to use the timeline filter for date type fields in pivot tables, select years, quarters, or days, and apply automatic updates and timeline styles.

Explore Power Pivot for blending data from multiple tables by linking sales, branch, clients, and product tables through common IDs, and understand relational databases before using Power Pivot.

Explore how relational databases structure data into tables with fields and records, and how primary keys ensure unique identifiers while foreign keys link tables in a one to many relationship.

Define each data list as a formal table, add them to the data model, and define relationships to build a pivot table from blended data.

Add the sales table to the data model using the Power Pivot tab, then add the branches, clients, and products tables, preparing to create relationships.

Create relationships in the diagram view by linking primary and foreign keys across sales, branch, client, and product tables to form a one-to-many data model for pivot analysis.

Learn to create pivot tables from a data model with multiple related tables, using fields at the second level, filtering by country, and visualizing results with pivot charts.