How To Do What If Analysis Data Table Excel 2016 For Mac

Thunderbird email client for mac. Excel® 2016 PIVOT TABLE DATA CRUNCHING. CRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2016 PIVOT TABLES! Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours understand exactly what’s going on in your business take control, and stay in control! Go to the Data tab. Under the Data Tools section, press the What-If Analysis button. Select Data Table from the drop down menu. For the Row input cell select the term input (C4). For the Column input cell select the interest rate (C3). Press the OK button.

In this example we’ll create a data table based on the accumulated value of a bank deposit that earns interest (i.e. Cad software for mac. How much money will we have after a given time at this interest rate). Our inputs for the calculation are the principal amount, term of deposit and interest rate earned.

We’ll use a data table to explore what happens to the accumulated value if the term or interest rate changes. We have our calculation inputs in C2:C5. • Principle ( C2 ) – This will be fixed at $10,000 for our example.

• Interest Rate ( C3 ) – This is one of the inputs that will vary in our data table. • Term ( C4 ) – This is one of the inputs that will vary in our data table. • Accumulated Value ( C5 ) – This is the calculation our data table will be based on. Create the Data Table in the range B7:K13. • Highlight the range where we want the data table. • Calculation ( B7 ) – This cell contains a reference to the calculation found in C5 using a formula =C5. • Column input cells ( B8:B13 ) – This range contains the different term values we want to evaluate our calculation with.

• Row input cells ( C7:K7 ) – This range contains the different interest rate values we want to evaluate our calculation with. • Go to the Data tab. • Under the Data Tools section, press the What-If Analysis button. • Select Data Table from the drop down menu. • For the Row input cell select the term input ( C4).

• For the Column input cell select the interest rate ( C3). • Press the OK button. You might be asking what’s so special about this and why didn’t we just input this accumulated value formula into cell C8 and copy it across the range C8:K13?