Excel Magic Trick #200: Excel Table Formula Nomenclature




About this tutorial:

Video duration: 9:18
See how to use the new Excel 2007 Table Nomenclature in formulas. See 9 examples of how to create formulas with Table Nomenclature.
See how the Table Nomenclature allows you to create formulas on different sheets without having to use sheet references in formulas.
Learn about Field Names in formulas as well as the All, Header, Totals, and This Row aspects of the Excel 2007 Table Nomenclature.
See how to Name A Excel 2007 Table.
See How To Create An Excel 2007 Table.

Incoming search terms:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

5 thoughts on “Excel Magic Trick #200: Excel Table Formula Nomenclature

    Stephen Putnam

    (January 13, 2019 - 8:13 am)

    Big fan and I LOVE all of your videos!! I have a problem and I can't seem to find exactly the right video to help answer my question.

    I have a table [Ctl + t, meaning not a range] where I have products in the rows and customers in the columns. I'm using data validation to select the right customer and product and using the index and match function to find a specific customers price for a specific product. However, the challenge is that I need to add more products [rows at the bottom of the table] and customers [columns on the right side of the table] and not lose functionality of the formulas. Can you please help me in finding the right video? I believe it has something to do with how nomenclature I'm using in the index and match formula. Please help!!

    Example…

    Customer 1 Customer 2 Customer 3 Customer 4….. [Add more customers this way]
    Product 1 $3.00 $3.50 $3.25
    Product 2 $5.00 $4.75 $5.25
    Product 3 $4.50 $4.25 $3.75
    Product 4…..
    Add more products this way

    ExcelIsFun

    (January 13, 2019 - 8:13 am)

    Dear buji81 ,

    No, I know only a few things, The Excelers that know everything are at the Mr Excel Message board!! People like Aladin, Houdini and DonkeyOte.

    But I am having fun making the videos and I am glad that you find some use with them!

    –excelisfun

    Ovidiu Ionut Bujor

    (January 13, 2019 - 8:13 am)

    YOU seem to know everything is to know about EXCEL:)..Thank YOU for doing this channel..It's a blessing!

    ExcelIsFun

    (January 13, 2019 - 8:13 am)

    Dear planiolro,

    EXCELlent!!!

    –excelisfun

    planiolro

    (January 13, 2019 - 8:13 am)

    very useful

Leave a Reply

Your email address will not be published. Required fields are marked *