Business Analytics Functions

IF function

Returns different values based on a condition.

SUMPRODUCT function

Multiplies corresponding elements and returns the sum.

INDEX function

Returns the value at a specified row and column in an array.

MATCH function

Finds the position of a value in a range.

VLOOKUP function

Searches for a value in the first column of a table and returns a value in the same row from another column.

HLOOKUP function

Similar to VLOOKUP but searches horizontally.

XLOOKUP function

More flexible than VLOOKUP and HLOOKUP, allowing searches in any direction.

SLOPE function

Returns the slope of the best-fit line in regression analysis.

INTERCEPT function

Returns the y-intercept of the best-fit line.

RSQ function

Returns the R-squared value, a measure of how well data fits a regression line.

CORREL function

Returns the correlation coefficient between two datasets.

FORECAST.LINEAR function

Predicts a future value based on existing data.

SUM function

Adds values in a range.

Solver

Finds optimal solutions for decision-making problems.

Goal Seek

Finds the input value needed to achieve a specific output.

Data Tables

Analyzes different scenarios by changing input values.

Scenario Manager

Stores multiple sets of input values.

Creating a Pivot Table

Summarizes large datasets dynamically.