How to use excel named ranges in Tableau | Tableau tutorial

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 ... https://www.youtube.com/watch?v=j5VUqMIcr2I