Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions

[@excelisfun]

I am glad that you liked it!

[@excelisfun]

You are welcome!

[@jaimecarranza2509]

These Excel classes are just awesome! I never thought I could learn Excel having a great time! and in adition I'm proving my listening and english comprehension ! Greetings from Colombia Teacher!

[@excelisfun]

You are welcome!

[@excelisfun]

You are welcome!!

[@excelisfun]

I am glad that they help!

[@excelisfun]

In these videos and in the book and DVD I refer to the Excel Table feature as "Excel Table feature". That way I can still use the word "Table" for other purposes. In earlier version it was called "List feature". If you search this channel for "Excel Table feature" you can find a number of videos on this topic. Here are some videos: Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables

[@excelisfun]

Here are other videos: Excel Dynamic Chart #3: Table Feature (Excel 2010 / 2007) List Feature (Excel 2003) Excel Magic Trick 925: SUMIFS Function & Table Feature To Create Running Total Net Income Formula 10:58 Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature? Mr Excel & excelisfun Trick 74: Dynamic Range For VLOOKUP & Data Validation List - Table Feature Excel Magic Trick 891: Dynamic Subtotals Using Table Feature and SUMIF or SUMIFS functions

[@lovepilly]

Amazing sources of knowledge and tips. Thank you very much for sharing

[@chrisodigwe2680]

These videos are really helping me in my supply chain job. Where do I get the excel files to do the homeworks? Please reply ASAP

[@RichXR]

Amazing stuff Mike

[@ahmedyousuf1990]

hey mate do you provide such awesome videos for word?

[@excelisfun]

You are welcome!

[@iyarpronto]

You are welcome!

[@excelisfun]

You are welcome!