Highline Excel Class 15: Excel 2007 Tables 7 Examples

See the Amazing Excel 2007 Tables do these things:
1. Keyboard shortcut to create table
2. Automatic Formatting (Including how to create Table Style and Set As Default)
3. Sorting & Filtering from drop down arrows
4. Dynamic Ranges for formulas, charts and PivotTables
5. Change Table Name
6. Formula Table Nomenclature
7. Convert To Range
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Category:

Science & Technology

Tags:

• Excel
• Table
• List
• Dynamic
• Range
• chart
• formula
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[prudhvirajreddyable]

amazing video

[ExcelIsFun]

@prudhvirajreddyable , Thanks!

[tomasek262]

Hi there, I have a table where I insert data manully. I need to create next table for exporting purposes which will automatically copy (load) data from original table. So when I insert a new line into the original table, it will create a new line in "exportable" table automatically. Is something like this possible? Thanks

[ExcelIsFun]

I am overwhelmed at work. No Time... Try:

mrexcel[dot]com/forum

There are 100s of people there who can help.

[tomasek262]

@ExcelIsFun Thank you

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

A TON of You Are Welcome!

Thanks for the 5 star rating!

[6642633]

A TONS of Thanks and Stars

this have been very Helpfulllllllllll

[ExcelIsFun]

I do not know of one. But as soon as you type the first few characters, you should see a drop-down with a list of functions, Defined Names and Table names.

[aman1245singh]

While formulating a cell and adding this formula, =sum(salestable01[sales])

what is the shortcut( if any) for getting a dialogue box showing the name of the tables which I can insert, like the f3 shortcut for inserting range names.