Optimizing formulas in Excel

Citizen Data Scientist 201 Day 1

 

Review slides 44 – 94 for the following topics:

Cell validation
What-if analysis
Data tables
Excel Solver

Complete the following exercises:

Exercise 3 – Cell validation

Exercise 4 – Goal seek & sensitivity analysis

Exercise 5 – Scenarios analysis

Exercise 6 – Solver

Complete Concept Review 2: formula optimization in Excel in the Assessment tab to complete this lesson

[LF_dataworld]

Course Forum