## Best Excel Tutorial

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

#### How to Make Correlation Graph in Excel

Correlation helps to identify the pattern of change between two variables. It has two properties – strength and direction. It is a common statistics concept which can be easily represented in Excel using a scatter chart and a trend line.

#### How to calculate risk-free rate in Excel

A risk-free rate is the rate of interest a borrower has to pay or an investor expects to earn on an asset carrying zero risks. It is the minimum return that an investment must give over a period to be profitable. If you keep the money in a fixed deposit, you will get an assured interest. A risk free rate is like that and can be calculated by using a mathematical formula.

#### How to Calculate CAPM?

The Capital Asset Pricing Model (CAPM) is a financial model that helps to determine the expected return on an investment based on its risk. Here’s how you can calculate CAPM in Microsoft Excel.

#### How to Create New Worksheet in Excel Vba

One of the things that VBA can be used to do is to create new worksheets. In this article, you learn how to create a new worksheet in Excel using VBA.

#### How to Loop Through Rows and Columns in a Range

In this article we will learn how to use Excel macros to loop through a range with different techniques. Lets start with how to create an Excel module and Subroutine to write the code.

#### How to loop without VBA or macros?

Looping is a common task in Excel, and it can be done using VBA or macros. However, there are also ways to loop in Excel without using VBA or macros.

In this article, we will show you how to loop in Excel using the `IF` function and the `INDEX` function.

#### How to Manipulate Strings in Excel Vba

In this article, we will learn to do string operations using Excel VBA. String can be any text or a combination of text and numbers etc.

#### How to Write to a Cell in Excel Vba

In this Excel tutorial lesson, I will guide you through the basics of Excel VBA and how you can use Excel VBA to write to a cell in an Excel sheet.