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 - Intro
00:16 - When to use this trick
01:31 - Named ranges in Excel and how they work
04:03 - How to connect to named ranges in Tableau Desktop
06:34 - Working with the connections
08:53 - Connecting to named range sin Tableau Prep
Follow 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/3HWc4Mj
My technology Channel: https://j.mp/3F0d28f
How to use a Tableau dashboard: Tableau tutorial for beginners