Microsoft Excel Tables- Ultimate Master Program

Discover how an Excel table turns a rectangular data range into a dynamic, filter-enabled structure. Automatic naming and the name manager, plus built-in filters and styles, simplify data management.

Learn how to create an Excel table using the ribbon, the Ctrl+T shortcut, or the quick analysis tool, and rename tables like EMP table, product table, and student tab.

Learn excel table terminology, add rows and columns, use shortcuts to select rows and columns, and enable a total row with sum, count, max, and subtotals.

Select the table, open table design, set format as none, and convert to range to turn the table into normal data in Excel.

Enable key Excel table options to manage data: include new rows and columns, automatically fill formulas, use table names in formulas, and group dates when filtering.

Explore how calculated columns in Excel tables automate total sales and tax calculations, updating all cells automatically for faster data analysis.

Insert and delete rows and columns in an Excel table using multiple methods. Select rows with shift space, use the home tab, or the end of table to add rows.

Explore dynamic table ranges that automatically expand with data and learn to count rows, columns, and cells using the table name, and compute total sales by multiplying price and quantity.

Convert data to an Excel table and apply filters by ID, department, salary, and dates, using text and number filters such as equals, begins with, contains, and greater than.

Master table sort in Excel by using filter options to sort data from A to Z or Z to A, including sort by color and custom sort with multiple levels.

Master essential Excel table shortcuts to create tables, toggle and clear filters, and quickly select rows, columns, and headers using keyboard commands.

Enable the total row in an Excel table through table design, then choose functions such as sum, min, max, or count to aggregate data like salaries or department counts.

Identify and remove duplicates in an Excel table using the data tab, choose a basis (e.g., product name), and optionally extract unique values with the advanced filter.

Explain how structured references in Excel tables use table and column names in formulas to enable dynamic calculations, with examples of population changes and max percentage via index and match.

Explore structured reference syntax in Excel tables, learning how to reference a table, headers, or specific columns, and understand data versus header selections with practical examples.

Discover how structured references inside an Excel table dynamically update totals as quantity and price change, using currency formatting and lookup functions to pull prices from a related table.

Learn to query Excel tables using rows and columns functions, count blanks, and subtotal for visible rows, with dynamic updates and table references.

Learn how to copy and lock structured references in Excel tables, so formulas dynamically adapt when dragging across columns while preserving locked references and consistent cell addresses.

Learn to use SUMIFS with an Excel table, compare applying to a normal data range versus an Excel table, and see how the table updates totals automatically.

Learn to use vlookup with a table by naming the table, selecting exact match, and using the match function to dynamically return the correct column.

Explore how to use index with match in a table to perform dynamic lookups, selecting rows and columns with exact match, and see how dragging updates row and column indexes.

Learn to set up a running total in an Excel table using the sum function with an index approach to auto update as you add data or insert rows.

Learn to apply conditional formatting formulas in a table, highlight data when conditions are met, and use relative references and dollar signs to ensure correct highlighting.

Apply data validation within an Excel table to enforce dropdown lists and dynamic updates, ensuring only approved stages are entered and the table expands automatically.

Use name manager to define a named range for the table and reference it in data validation to keep inputs updated with the table.

Learn how to add a slicer to an Excel table, filter by department, and manage slicers, clear filters, select multiple items, and delete or add more.

Discover how to configure Excel table slicers, rename display names, adjust sort order, manage items with data or no data, and resize or style slicers.

Learn to apply and customize table slicer styles in Excel by selecting from default styles, duplicating for custom styles, and applying color changes to hover and selected items.

Explore different table styles, including dark styles, and learn to customize headers, striping, and branded columns while mastering how to create and copy a custom table style across worksheets.

Apply and customize table styles in Excel by creating a table, previewing styles, selecting a preferred style, clearing formatting, and setting a default style for new tables across the workbook.

Create and customize a new Excel table style from scratch or from existing styles, applying borders, header colors, and stripes, and modify as needed.

Copy a table style from one workbook to another by pasting or using the copy option, then apply the custom table style to the target table.

Explore why using an Excel table as the pivot table source keeps data dynamic, so the pivot table updates automatically when you add data, unlike normal data ranges.

Learn to build a simple summary table in Excel using two functions, sum and count, with range and criteria, remove duplicates, format currency, and enable automatic updates.

Learn to count items in a filtered Excel table by applying filters, creating and naming a table, and using the subtotal function to count visible rows while excluding hidden data.