Skip to main content

Create and Customize

Learn how to create a workbook and use the available tools, wizards, and controls to customize your workbook.

In this section:

SectionDescription
Create a WorkbookCreate and configure a workbook from scratch.
Workbook ToolsUse built-in tools such as Functions and Hide Zero to enhance your analysis.
Workbook WizardsAccess wizards including the Data Extraction Wizard, Drill Down Wizard, Pivot Wizard, and Formula Wizard.
Workbook ControlsCustomize workbook behavior with Slicers, Cell Types, Cell Dropdowns, Sparklines, and Shortcut Keys.