Using Styles

Cell Styles Themes Editing styles and Themes

Using Scenarios and Goal Seeking

Using the Scenario Manager Creating a Scenario Displaying a Scenario Editing a Scenario Creating a Scenario summary report Using Goal Seek and Solver

Using Data Tables

Creating Data Tables Placing formulas in data tables Creating a one-variable table Creating a two-variable table

Data Manipulation

What is a Table? Inserting a table Text to Columns Adding records Advanced Filtering Eliminating Duplicate Records Creating Subtotals

Validation

Restricting user Entries Creating Drop-down lists Setting entry parameters Working with Error Alters

Pivot Tables

Creating a PivotTable report Adding PivotTable report fields Refreshing a PivotTable report Formatting a PivotTable report Creating a Pivot Chart Using Slicers in Pivot Tables

Recording Macros

What is a Macro? Recording a macro Assigning a shortcut key Using relative references Assigning a macro to a menu Deleting a custom menu item Deleting a macro

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.