Workshop Objectives

• Insert SmartArt

• Add text to a diagram

• Resize and move a diagram

• Reset a diagram

• Understand the contextual tabs 

• Add pictures from your computer

• Add Clip Art

• Add text boxes

• Draw shapes

• Trace precedent cells

• Trace dependants of a cell

• Display formulas within the sheet

• Work with comments

• Insert a chart

• Use the Chart Tools tab

• Understand the parts of a chart

• Change the chart style

• Resize and move a chart

• 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 dependants and precedents in formulas

• Use the Trace Errors Commands