The Complete Microsoft Excel Data Analysis and Pivot Tables

Explore using Excel for data analysis with a simple sales dataset, turning data into a table, and applying sums, averages, sorts, filters, and a clustered column chart.

Explore how pivot tables in Excel summarize and analyze sales data, showing totals by month and product, and revealing patterns without altering the original data.

Learn to create a pivot table from a dataset in Excel, drag fields to rows and values to summarize sales by product, month, and region with no advanced formulas required.

Explore the Microsoft Excel pivot table interface, create a pivot table from raw data, assign fields to filters, rows, columns, and values, and use slicer and timeline.

Explore rearranging fields in a pivot table, moving rows, columns, values, and filters to analyze data from different angles. Use drag-and-drop and sum or average calculations.

Master grouping and summarizing data in pivot tables to organize dates, numbers, and categories by inserting a pivot table, dragging fields, and grouping by month or year.

Master sorting and filtering in pivot tables to analyze sales data by region and product, using row labels, values, and slicers for dynamic insights.

Learn to use slicers for interactive filtering in pivot tables, enabling one-click data filtering of regions and products, with dynamic sales summaries and pivot table customization.

Learn how to create calculated fields and items in pivot tables to compute total revenue from unit sold and unit price, without altering source data.

Create pivot charts to visually explore and present sales data alongside pivot tables, enabling quick trend and outlier detection and at-a-glance comparisons.

Explore pivot chart types in Excel and learn when to use column, bar, line, area, and pie charts to compare categories, show trends, and reveal proportions in pivot tables.

Learn to customize pivot charts by editing titles, axis, and legends, and adding data labels and a chart title for clear sales insights from region, product, and quarter data.

Learn to build a dynamic dashboard from a simple sales data set by creating pivot tables, pivot charts, and slicers to summarize revenue by product and region.

Learn to build an inventory tracking and forecasting sheet in Excel, monitor stock levels, highlight low stock with conditional formatting, and forecasted sales and stock using a basic growth model.

Learn how to use pivot tables in Microsoft Excel for customer segmentation by region and spending, creating a dataset and pivot table to group customers and analyze totals.