Data analysis

Decision making under risk and$/$or uncertainty

Models of decision making

Expected value, including relation to perfect information and sample information

Decision variables

States of nature

Profit$/$loss

Crossover point

Break$-$even point

Probability

Types of costs

Optimization

Decision variables

Objective function

Constraints

Types of problems which can be solved using optimization

How to use optimization $($Solver$)$ in Excel

Simulation

Probability and cumulative probability

Simulating events based on past information

Types of problems you can simulate

There will be simulation problems which you will need to answer, and all information will be given for that problem

Excel Functions $/$ formulas

The list includes but is not limited to

Random

Vlookup

Goalseek

Solver

Sort

PivotTables