Welcome! Enter below articles or choose one from the menu above

Linking Text Box to a specific cell

In this Excel tutorial you will teach yourself how to link a TextBox to a specific cell.

Read more ...

Waterfall chart

In this lesson you can learn how to insert Waterfall Chart.

Read more ...

How to Calculate YTM?

YTM is academically defined as market interest rate, but means Yield to Maturity. It actually takes purchase price, the value of redemption, time between payment of interest, and the yield of coupon.

Read more ...

How to calculate t value?

In this Article we will learn a very useful financial term know as T-Value.

Read more ...

How to print all tabs?

In this article you will learn how to print entire workbook in Excel. This is useful trick which will make printing easier and faster.

Read more ...

In this lesson you will learn how to define name to cells and ranges. It will help you to use these names in your formulas. You can use these defined names as variables.

You can assign names to cells and ranges in Excel. For you it is much better to use name than just address of cells.  It looks also much more professional. Cell named Sales or range of cells named Sales_Atlanta are certainly a lot easier to remember and identify than the corresponding cell addresses A1 or A2:B20.

You can use defined name in formulas and functions instead of cell addresses. When you move a cell or range of cells possessing different place name in the worksheet, Excel automatically updates all the necessary formulas and references.

Defining name of cells (or range of cells)

Select cell (or range) you want to name.

Define Name Range

Go to Ribbon. Click the Formulas tab. Next go to Defined names section. Click Define Name.

Define Name Ribbon

Dialog box appears. Fill it in.

Define Name New Name

Your name is defined. You can see it here.

Define Name Done

You can also define name in other way. Use this method to define name of ranges. Header will become names of range.

Create from Selection

Select range of cells you want to name (with header!).

Define Name Example

Go to Ribbon. Click the Formulas tab. Next go to Defined names section. Click Create from Selection button.

Define Name Create from Selection

Dialog box appears. Click proper check box.

Create Names from Selection

Name is defined.

Define Name Ready

Before you learnt how to define names, you have used such formulas: =SUM(A1:B2)

Now, you can use such formulas: =SUM(ExampleName,BestExcelTutorialExample). Excel remembers names which you defined. Excel will help you as you see at the picture below.

Define Names Formulas

Excel shows your names the same such functions. Just use names and create functions incredibly easy.

Further reading: 
Camera Tool
Chart with Checkboxes
Variables declaration