## Best Excel Tutorial

The largest Excel knowledge base ✅ The best place to learn Excel online ❤️

#### How to perform a DCF analysis in Excel

In this Excel tutorial you will learn how to perform a DCF analysis in Excel.

A discounted cash flow (DCF) analysis is a financial model used to estimate the intrinsic value of an investment or project. This method takes into account the future cash flows generated by an investment, discounted to their present value using a discount rate.

#### How to do regression with non numeric data in Excel

Regression analysis is a statistical method that is used to find the relationship between two or more variables. Typically, the variables are numeric. However, it is also possible to do regression analysis with non-numeric data.

Categorical data is data that can be categorized into groups, such as gender, age, or product type.

Regression analysis with non-numeric data can be used to predict future behavior, such as which products a customer is likely to buy or which customers are likely to churn.

#### How To Do A Two Variable Sensitivity Analysis In Excel?

We can use two variable sensitivity analysis to evaluate the validity of a matrix containing a range of values for two variables related to a goal.

#### How To Use SQL Statements In Excel

SQL statements can be used to retrieve information from records that may be held in an Excel spreadsheet or a database.

#### How to use countif to remove duplicates?

In this Excel tutorial lesson, you will write the countif to remove duplicates.

#### Monte Carlo simulation in Excel

In this Excel tutorial you will learn how to perform Monte Carlo simulation in Excel.

#### How to handle prime numbers in Excel

In this Excel tutorial, you can learn how to handle prime numbers in Excel.

#### How to standardize data in Excel

Standardizing data transforms values in a dataset so they have a mean of zero and a standard deviation of one. This process, also known as normalizing or z-scoring, makes the data consistent and suitable for statistical analysis.

#### How to subtract in Excel

In this Excel tutorial, you will learn how to subtract.

#### Matrix multiplication in Excel

In this Excel tutorial you teach yourself about matrix multiplication in Excel. You see how to use MMULT Excel function to multiply matrixes.