Excel Tables (Beginners' Guide) Mini Free Course

Format your data as an Excel table by converting a range with headers. Insert with Ctrl+T, explore the table design, and notice filters.

Use filter buttons on column headers to sort and filter data, including city and date range filters, then clear filters to reset results.

Navigate Excel tables with an automatically pinned header, filter data from header dropdowns, and enable a dynamic total row using the subtotal function to summarize visible data.

Navigate the table design tab to format, style, and rename Excel tables, creating unique, descriptive names like TableSales and applying or customizing table styles.

Format data cells within the table using date, currency, text formats, and font styles, applying formatting to the table so it extends to rows or columns as the table grows.

Add data to an Excel table; it auto expands with new rows or columns, preserves formatting and formulas, and updates the name manager range, even when adding a budget column.

Move and resize Excel table columns and rows by drag and drop, use header selection and edge cursors, and resize via design tools or the bottom-right handle.

Visualize data in Excel tables by creating charts and slicers, updating charts automatically as data changes, and using filters to refine views.

Learn how to write formulas with Excel tables using structured references and column names, including the @ row reference, to calculate commissions and sums across worksheets.

Learn how using Excel tables with pivot tables delivers dynamic ranges that auto-update as data grows, thanks to automatic resizing and easy refresh of single or multiple pivot tables.

Convert an Excel table back to a normal range using the Design tab, remove duplicates to clean data, and understand how formatting remains while table features are lost.

Learn the advantages of using Excel tables for your data, and prepare to dive into pivot tables and dynamic dashboards in upcoming courses.