Skip navigation

On September 14th, 2017, we published revised versions of our Privacy Policy, Terms of Service and Website Use Policy and published a Cookie Policy. Your continued use of Lynda.com means you agree to these revised documents, so please take a few minutes to read and understand them.

Create objective and control formulas

Create objective and control formulas: Microsoft Excel: Using Solver for Decision Analysis
Create objective and control formulas: Microsoft Excel: Using Solver for Decision Analysis

Now that you have organized your worksheet and added the data used in your analysis, you can define the summary formulas that will calculate the output of a given portfolio’s overall beta and expected return.

Resume Transcript Auto-Scroll
Skill Level Intermediate
1h 43m
Duration
26,372
Views
Show More Show Less
Skills covered in this course
Business Business Intelligence Spreadsheets Excel

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now