PivotTables in Excel Course for Beginners

Learn how to clean data before analyzing with pivot tables by tidying formats, removing blanks and duplicates, and ensuring consistent data imports for accurate pivot analysis.

Tidy up a worksheet by removing formatting to restore plain text and values, using Excel's clear formats option from the Home tab.

Split a column into separate order date and order ID with text to columns or flash fill, then merge data using the concatenate (concat) function for pivot table ready results.

Learn to run spell check in Excel to clean data for pivot tables, selecting the correct language and dictionary, and using F7 with change, ignore, or add-to-dictionary.

Explore how to use Excel's recommended pivot tables to quickly summarize clean data by region or item type, then customize and build a blank pivot table from scratch.

Explore pivot table ribbons and the field list to manage, style, and arrange data, then drag fields into filters, columns, rows, and values to analyze regions and units sold.

Build pivot tables by dragging fields into rows, columns, and values to sum totals like total profit by region, then use filters and collapsible items to refine analysis.

Delete fields to tidy a pivot table and lock the report layout, then control column widths by turning off auto fit on update in PivotTable options.

Learn to handle empty cells in pivot tables by replacing blanks with zero to keep analyses complete. Filter Albania, then view profit by item type and sales channel.

Apply accounting formatting with zero decimal places and a U.S. dollar symbol to all pivot table value columns, then configure the pivot table to show zeros for empty cells.

Explore how to manage subtotals and grand totals in pivot tables, control their display with the design tab layout options, and choose where they appear for rows or columns.

Apply and customize pivot table styles in the design ribbon, with live previews of light to dark presets, and adjust options like row headers, column headers, and banded rows.

Learn to modify pivot table styles in Excel by duplicating styles to create custom options, then format borders, header colors, fonts, and row or column stripes.

Learn to create a custom pivot table style from scratch, tailor every element with your branding colors, save it as a default, and copy the style across workbooks.

Sort pivot table data to organize regions and the sum of profit. Explore sorting options, custom lists, and manual sorts, then refresh the pivot table.

Master filtering pivot table data in Excel by region and item type, using label and value filters, wildcards, and multi-filter options to refine profit insights.

Apply the top 10 filter in pivot tables to show the top five countries by the sum of profit, improving pivot chart readability.

Master selecting the right chart type for pivot table data to visualize insights clearly. Explore column, bar, line, donut, pie, and map charts and learn when to use each.

Learn to create clustered column charts from pivot tables in Excel, filter top five countries by units sold, and convert to bar charts with basic formatting and data labels.

Create line charts from pivot table data by duplicating a worksheet, configuring a date field on rows, filtering to the last four years, and applying chart formatting and legend options.

Learn to create and format pie and donut charts from pivot tables, including grouping data into canceled and active orders and applying data labels and colors for clear visualization.