You can connect to a named range or an Excel table (also known as an Excel list) in the same way as you connect to a worksheet. Both the named range and Excel table function as a table in Tableau.You create named ranges in Excel by selecting a range of cells and then selecting Define Name on the Formulas tab. Similar to named ranges, you can create an Excel table in Excel by selecting a range of cells, and then selecting Insert - Table. When you connect to a named range or Excel table in Tableau, an icon appears next to the sheet in the Data Source page, as shown below.00:00 - Intro00:16 - When to use this trick01:31 - Named ranges in Excel and how they work04:03 - How to connect to named ranges in Tableau Desktop06:34 - Working with the connections08:53 - Connecting to named range sin Tableau PrepFollow me on Twitter: https://twitter.com/TableauTim My recording gear & what's on my desk. https://kit.co/TableauTim/desk-setup My website: https://www.tableautim.com/ My Screen Annotation Tool: https://j.mp/3HWc4MjMy technology Channel: https://j.mp/3F0d28f
