Need to prepare a budget

WEEK 2: READ & WATCH Please find below the content and items you need to read and or watch this week. Please note your weekly discussions are tied to each week’s Read & Watch content.   MAIN FOCUS

This week, you will be introduced to Excel’s Auditing and Analysis tools. By reading and/or viewing the assigned materials, you will learn how to use Goal Seek to find a result by adjusting an input value. You will learn how to switch between different sets of values by using scenarios, calculate multiple results in tables by using a data table, learn how to create a PivotTable to analyze worksheet data, and create a PivotChart.

  READ & WATCH

1.  Use Goal Seek to find a result by adjusting an input value  (web page) Functions and formulas usually perform mathematical calculations using known values. Sometimes, however, you may know the results (goals), but not necessarily the values needed to arrive a the goals. The goal seek feature finds the unknown value you need in order to accomplish your goal.

2.  Excel 2013 What-if Analysis - Goal Seek  (4-page web tutorial) Read through all 4 pages and watch the What-If Analysis video on the first page.

3.  Switch between various sets of values by using scenarios  (web page) The scenario manager performs a what-if analysis that lets you change several cells of data

4.  Calculate multiple results by using a data table  (web page)

5.  Creating a PivotTable to analyze worksheet data  (web page) Excel offers a unique method for changing the way data can be displayed by using the PivotTable feature.

6.  Create a Pivot Chart  (web page) A PivotChart is a visual representation of the PivotTable data