Microsoft Excel: Pivot Tables - Zero to Hero

Clean and arrange a data set for pivot tables in Excel, ensuring headers are named and data is ready. Resolve errors by removing unwanted or hidden columns and unmerging headers.

Convert a pdf-derived data set to Excel, clean and unmerge columns, remove unwanted rows, then create a pivot table to analyze credit card transactions.

Learn pivot tables by transforming datasets, selecting fields for rows and values, applying sum, average, or count, grouping dates, formatting results, and refreshing to update reports.

Create a profit column from sales price minus cost and build pivot tables to analyze revenue, profit, and vehicles sold by month, plus employee performance monthly and detailed sale records.

Learn to create and customize pivot tables and charts in Excel, switch between line and pie charts, use slicers and timeline filters, and update data sources efficiently.

Master text to columns in Excel to split data into columns, choosing delimited or fixed width and using semicolon or other characters for clean pivot table analysis.

Learn essential basic formulas for pivot tables, including joining text with ampersand and concatenate, splitting with left, right, and mid, and using substitute, find, and length to manipulate data.

Split the account number and account name in Excel using left, right, and length-based formulas, with find and two methods. Build complex formulas by using helping columns and merging steps.

learn to use the if function to prep data for pivot tables in Excel, including repeating customer names and separating invoices and receipts.

Learn how to handle merge cells in pivot tables by unmerging and filling down with if formulas, then build accurate pivot analyses of chargeable weight by agent.

Convert dates into the correct format using text to column and date formulas to enable accurate pivot tables; extract year, month, and day as needed.

Learn to merge data sets using Vlookup and Xlookup, check duplicates with conditional formatting, and apply exact-match lookups with optional arguments for robust Excel analysis.

Create a data set in Excel by merging three sheets, using VLOOKUP and SUMIFS/IFS to develop pivot tables that track monthly and project revenue, cost, cash flow, and profit.

Build a dynamic dashboard by creating pivot tables and a pivot chart, linking them, adding a timeline, and using formulas to auto-update titles and filters, with clean visuals.