Excel in Depth - Table Formulas: Episode 1237

530 views · Published 3 September 2010 · 2:06 · Indexed 31 October 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Mastering Excel Tables: Adding, Formatting, and Automating.

Welcome to the MrExcel podcast. In this episode, we will be diving into chapter 19 of Excel in Depth, where we will be discussing the table functionality that was added in Excel 2007. As always, I am your host Bill Jelen and I am excited to share with you some tips and tricks on how to make the most out of tables in Excel.

Tables are a great way to organize and analyze your data. They allow you to easily filter, sort, and format your data with just a few clicks. To convert your data into a table, simply select your data and press [Ctrl + T] or go to the Home tab and click on "Format as Table". Choose one of the available table formats and voila, your data is now a table!

But the real magic of tables lies in their ability to automatically expand and update as you add new data. For example, if you add a new column to your table, it will automatically become part of the table and any formulas you add will also be included in the table. This means you no longer have to manually copy and paste formulas throughout your data set. Simply enter the formula in the first cell and it will automatically be applied to the entire column.

However, if for some reason you do not want this automatic behavior, you can easily undo it by selecting "Undo Calculated Column" or by converting the table back to a range. This gives you the flexibility to choose whether or not you want your data to be part of a table. So whether you love tables or prefer to work with ranges, Excel has you covered.

Thank you for tuning in to this episode of the MrExcel podcast. I hope you found these tips on tables helpful and will be able to use them in your own projects. Don't forget to subscribe to our channel for more Excel tips and tricks, and I'll see you next time for another netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Tables in Excel 2007
(00:10) Converting a Data Set to a Table
(00:24) Benefits of Using a Table
(00:36) Adding New Columns and Formulas to a Table
(00:50) Formatting a Table
(01:02) Automation in Tables
(01:12) Undoing Calculated Columns
(01:29) Converting a Table to a Range
(01:41) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Adding new columns and formulas to a table
Automating fill handle in a table
Converting a table to a range
Converting data set to a table
Excel in Depth, chapter 19
Formatting a table
Table formatting and behavior options
Tables in Excel 2007
Undoing calculated column in a table


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152918/

When you have a defined table in Excel 2010 and add a formula next to it, the formula will automatically copy to all of the rows of the table - no more double-clicking the Fill Handle! Episodes #1237 shows this intuitive time saver in action.

More from this channel