Using Tables as Dynamic Named Ranges in Excel | Everyday Office 032

2,087 views · Published 7 February 2017 · 7:27 · Indexed 13 October 2026

Channel: Neil Malek · 2017 · Education

Watch on YouTube

In this video, Neil Malek of Knack Training demonstrates how the Excel Table tool makes calculations easier through dynamic named ranges. 

Download the sample files at: http://blog.knacktraining.com/

Music By JMKM for ProductiveCulture
http://www.steadybeatsupply.com
http://www.soundcloud.com/productiveculture

More from this channel

• 0:22 Word 2010 to Excel Conversion

  Neil Malek

  412 views · 7 June 2011

• 1:14 Add Twitter @ to Outlook Contacts

  Neil Malek

  856 views · 9 June 2011

• 0:25 Transpose a Table

  Neil Malek

  141 views · 17 June 2011

• 2:24 Pivot Table in Excel 2007

  Neil Malek

  65 views · 19 June 2011

• 14:34 knack tv - Episode 1: Speaker Notes

  Neil Malek

  281 views · 6 September 2011

• 14:12 knack tv - Episode 2: Charts

  Neil Malek

  85 views · 7 September 2011

• 13:10 knack tv - Episode 3: Smart Art

  Neil Malek

  64 views · 8 September 2011

• 10:51 knack tv - Episode 4: Diagram.ly

  Neil Malek

  1,501 views · 9 September 2011