Example: =SUM([jan_sales.xls!A1:D1],[feb_sales.xls!A1:D1]) GOAL SEEK: Goal Seek allows you to calculate an unknown value in a given formula, but is only useful for problems that involve finding a single variable. When the desired result of a calculated cell is known, but not the input value that calculation needs to reach that result, you can use Goal Seek. SOLVER: Solver is a tool that helps you find solutions involving multiple variables. SCENARIOS: Scenarios are part of a group of commands that can be called what-if analysis tools. A scenario is a set of values that a user can create and save and then substitute at any time in the worksheet. The user can then switch to any of these new scenarios to view different results in the worksheet. To compare several scenarios, you can create a report that summarizes them on the same page. "WHAT-IF" TABLES: What-If Tables allow you to analyze data and produce a table to show the results. When a single variable like the unit price changes, use a one-input What-If Table. If the unit price AND number of units sold changes, use the two-input What-If Table. MACROS: Create Absolute and/or Relative Macros to automate common, repetitive tasks. PROTECT A WORKSHEET/WORKBOOK: PREREQUISITES:
Beginning
& Intermediate Excel or comparable experience. Course handout covers version 2007. Students will
use version 2007 in class. |
