How to use Excel

You can use the name box in Excel to select a cell range or named range. You can also use the name box to quickly create a named range (important).

Line charts are used to display trends over time. Use a line chart if you have text labels dates or a few numeric labels on the horizontal axis. Use Scatter with Straight Lines to show scientific XY data. To create a line chart in Excel execute the following steps.

The Union method in Excel VBA returns a Range object that represents the union of two or more ranges. The Intersect method in Excel VBA returns a Range object that represents the intersection of two or more ranges.

The formula bar in Excel displays the value or formula of the active cell. You can use the formula bar to enter or edit formulas. The formula bar is located below the ribbon and above the worksheet area.

Dates and times in Excel can be displayed in a variety of ways. To apply a Date or Time format execute the following steps.

Instead of multiple If Then statements in Excel VBA you can use the Select Case structure. Let's explore this through two examples.

The Offset property in Excel VBA takes the range which is a particular number of rows and columns away from a certain range.

Below we will look at a program in Excel VBA that creates an interactive Userform.

Below we will look at a program in Excel VBA that splits an amount of money into bills and coins.

This example shows you how to create a budget in Excel. Follow our step-by-step guide and take control of your finances. First enter the different types of income and expenses in column A.