This workshop will teach participants how to:
- Add text to a diagram
- Resize and move a diagram
- Reset a diagram
- Understand the contextual tabs
- Add pictures from your computer
- Add text boxes
- Draw shapes
- Display formulas within the sheet
- Work with comments
- Insert a Pivot Table
- Use the Pivot Table Tools tab
- Choose fields and group data in a Pivot Table
- Change Pivot Table data and refresh the view
- Apply a Style to a Pivot table
- Use Real?life examples in a Pivot Table
- Create a Pivot Chart from a Pivot Table
- Create a Pivot Chart from Data
- Display the Developer tab
- Record and run macros
- Change the security level
- Customize and Change the Quick Access Toolbar
- Use named ranges in formulas
- Understand formula errors
- Trace dependents and precedents in formulas
- Use the Trace Errors Commands
