In this section you will learn how to:

• Use Excel’s outlining feature
• Group data manually
• Create subtotals
• Create a pivot table
• Rearrange a pivot table
• Modify and update a pivot table
• Format a pivot table
• Chart a pivot table
• Create a scenario
• Create a summary report
• Save multiple scenarios
• Use a one and two input data table
• Use Goal Seek
• Work with Excel’s solver