Microsoft Excel - Tables - Deep Dive

Explore why and how to use Excel tables, cover data preparation, creation, naming, and converting back to ranges for faster, more accurate work.

Discover how Excel tables organize related row data to automate formatting, calculations, sorting, and filtering, reduce errors, and boost efficiency and stability in large worksheets.

Define fields and records, distinguish lists and tables, and prepare data by removing blank rows and separating data before converting to a table.

Convert a data range to an Excel table to enable automatic sorting, filtering, and formatting with header recognition, using either the Home format as table or the Insert table command.

Explore how Excel tables automatically format data, keep headers visible while scrolling, enable in-column sorting and filtering, and manage table boundaries for reliable, fast calculations and pivot tables and charts.

Learn how to name Excel tables using the design tab and name box, renaming a default table to product sales and following naming rules for clarity.

Explore the benefits of Excel tables, when to convert a table to a traditional range, and how formatting can persist after conversion while some functions like subtotals may not apply.

Learn how to manage Excel tables: add and delete records, paste data, insert rows and columns, sort and filter with in-column filters and slicers, and apply custom sorts and lists.

Add and delete records in an Excel table, as the table automatically expands to include new data and maintains formatting and range integrity.

Access the Excel data form to quickly add, edit, delete, and search records in a table, and learn to customize the Quick Access Toolbar for easy use.

Add a column to an Excel table by typing the field name in the first cell and pressing enter, triggering automatic formatting and table expansion.

Explore how Excel tables enable quick in-column sorting with dropdowns, sorting by region, last name, or order total in ascending or descending order, and using multi-criteria and custom sort options.

Learn how to use slicers in Excel tables to filter data visually, including adding slicers from the table design tab for fields like order date, customer type, and region.

Apply table styles to make data readable and visually appealing, using predefined or custom table styles with fonts, fills, and borders, and set a default style for automatic formatting.

Apply table styles quickly with the quick styles gallery to format headers, first columns, last columns, and total rows with one click; recover or clear formatting using right-click options.

Modify table style options to quickly apply or toggle features like header row, banded rows and banded columns, filters, and total row, helping viewers understand data while preserving usability.

Explore creating and applying custom and default table styles in Excel, using theme colors, the table style gallery, and formatting options for borders, fonts, and banding.

Explore how Excel handles calculations in tables, including calculated columns, absolute and relative references, and table total rows, while comparing to normal ranges and mastering formulas and functions.

Review traditional Excel calculations, focusing on relative and absolute references, and how to use fill down with a sales tax example. Emphasize cell references over hardcoded values for accuracy.

Create calculated columns in Excel tables by multiplying order totals by a 5 percent sales tax rate using absolute references, then watch the formula auto-fill down across records.

Understand structured references in Excel tables, using [order total] with the at symbol to reference the current row, enabling efficient, stable calculations across large data sets.

Explore how structured references in Excel tables use absolute and mixed references to keep formulas correct when copying between late percent and prepay percent.

Master Excel tables with structured references and a totals row to dynamically summarize filtered data using functions like sum, average, count, maximum, and minimum.

Explore how tables structure data on worksheets and enable easier formatting, data manipulation, and calculations, then learn to move tables, remove duplicates, and create pivot tables, charts, and prints.

Move tables within or across worksheets or workbooks using drag and drop or copy and paste, preserving formulas as the table entity via structured references.

Maintain data integrity by using Excel's remove duplicates feature on tables to remove duplicate records, selecting field combinations, and understanding that differently displayed values may not count as duplicates.

Explore how Excel tables organize data with quick formatting and calculated columns, then use pivot tables to summarize across rows and columns without changing the source data.

Learn how charts created from Excel tables automatically update as you add columns or records, avoiding manual range adjustments and reducing errors.

Print the selected table in Excel using the backstage print settings, placing the cursor in the table and choosing print the selected table to print only the table.

Discover how to create and work with Excel tables, apply filtering, sorting, and formatting, and use total rows, calculated columns, pivot tables, and charts to manage data.