Final answer:
To connect to an Excel workbook in Tableau, open Tableau, select 'Microsoft Excel' under the 'Connect' section, choose the Excel file, open it, and import the needed sheets or named ranges by dragging them to the canvas area.
Step-by-step explanation:
To connect to an Excel workbook from Tableau, you can follow these steps: Open Tableau and select ‘Microsoft Excel’ under the ‘Connect’ section on the start page. Navigate to the location of the Excel file you want to connect to and select it. Click the 'Open' button to establish the connection to the workbook.
Tableau will then display the sheets or named ranges available for import as tables. Select the sheet or range you wish to analyze by dragging it to the canvas area. Once you have your data in Tableau, you can start creating visualizations by dragging and dropping fields onto the Tableau workspace.
Remember that if your Excel workbook has multiple sheets, you can combine these by using the Tableau's data joining or blending features. Always ensure your data is well-structured in Excel to facilitate a smooth import process into Tableau.