Tableau Key Concepts

These concepts don't really belong to any topic, but they drive the fundamental way in which Tableau works.

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

Up next

Course Videos

How to use a Tableau dashboard: Tableau tutorial for beginners
How to use a Tableau dashboard: Tableau tutorial for beginners
Tableau Tooltips - Full beginners guide including Viz in Tooltips.
Tableau Tooltips - Full beginners guide including Viz in Tooltips.
How to use excel named ranges in Tableau | Tableau tutorial
How to use excel named ranges in Tableau | Tableau tutorial
Tableau .TDE files are getting deprecated in March 2023
Tableau .TDE files are getting deprecated in March 2023
Where to look when formatting gets stuck in Tableau
Where to look when formatting gets stuck in Tableau