The post Calculate the Compound Interest with Excel’s FV Formula appeared first on Free Microsoft Excel Tutorials.

]]>**What does it do?**

Calculates the compound interest

**Formula breakdown:**

=FV(rate, nper, pmt, [pv])

**What it means:**

=FV(interest rate, number of periods, periodic payment, initial amount)

Say that you turn 18 years today (CONGRATS!) and you find out that your parents deposited an amount with their bank when you were born.

Now that you are 18 years old you can collect this money and go spend it all in one day!

**How much would be available for you to spend?**

Thankfully there is an easy way to calculate this with Excel’s **FV formula! FV **stands for **Future Value.**

The future value (FV) is the value of a current asset at a specified date in the future based on an assumed rate of growth over time.

In our example below, we have the table of values that we need to get the compound interest or Future Value from:

*(Change the NUMBER OF YEARS column to 18 to see the results on your 18th birthday)*

I explain how you can do this below:

**STEP 1:** We need to **enter the FV function in a blank cell**:

**STEP 2:** The **FV **arguments:

**What is the rate of the interest?**

*Select the cell containing the interest rate (make sure that this is in a percentage):*

**How many periods?**

*Select the cell containing the number of years:*

**What is the periodic payment?**

*We have no periodic payment, only an initial amount, so let us put in 0:*

**What is the initial amount?**

*PV stands for present value, the initial amount. We need to change this to a negative value by multiplying -1.*

*The reason why we need this as a negative value as Excel treats this as “money out” for your investment.*

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have all of the compound interest results! GO OUT & SPEND!

**Get the Compound Interest with Excel’s FV Formula**

HELPFUL RESOURCE:

Searching...

The post Calculate the Compound Interest with Excel’s FV Formula appeared first on Free Microsoft Excel Tutorials.

]]>The post Top Excel Formulas & Function Examples To Get Better At Microsoft Excel appeared first on Free Microsoft Excel Tutorials.

]]>Below you will find many Excel formula examples for key functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more.

Click on any Excel formula link below and it will take you to the free example tutorial & downloadable Excel workbook for you to practice!

Searching...

The post Top Excel Formulas & Function Examples To Get Better At Microsoft Excel appeared first on Free Microsoft Excel Tutorials.

]]>The post Addition Formula in Excel appeared first on Free Microsoft Excel Tutorials.

]]>**What does it do?**

Adds two numbers

**Formula breakdown:**

=number1 + number2

**What it means:**

=the number being added to + the number being added

In Excel adding numbers together is really easy with the **Addition Formula** which uses the addition operator: **+**

I will show you in the steps below how you could add numbers together in your Excel worksheet.

This is the table of values that we want to perform addition on:

I explain how you can do this below:

**STEP 1:** We need to **enter the number we want to add**:

**STEP 2:** Enter the **addition operator +**

**STEP 3:** Enter the **number to add**:

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have all of the addition results!

**How to Use the Addition Formula in Excel**

HELPFUL RESOURCE:

Searching...

The post Addition Formula in Excel appeared first on Free Microsoft Excel Tutorials.

]]>The post Subtraction Formula in Excel appeared first on Free Microsoft Excel Tutorials.

]]>**What does it do?**

Subtracts two numbers

**Formula breakdown:**

=number1 – number2

**What it means:**

=the number being deducted from – the number being deducted

In Excel subtracting numbers together is really easy, the **Subtraction Formula** is actually through the use of the subtraction operator: **–**

I will show you in the steps below how you could use this.

This is the table of values that we want to perform subtraction on:

I explain how you can do this below:

**STEP 1:** We need to **enter the number we want to subtract**:

**STEP 2:** Enter the **subtraction operator –**

**STEP 3:** Enter the **number doing the subtracting**:

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have all of the subtraction results!

**How to Use the Subtraction Formula in Excel**

HELPFUL RESOURCE:

Searching...

The post Subtraction Formula in Excel appeared first on Free Microsoft Excel Tutorials.

]]>The post Duplicate Columns Using Power Query or Get & Transform appeared first on Free Microsoft Excel Tutorials.

]]>Power Query (in Excel 2010 & 2013) or Get & Transform (in Excel 2016) lets you perform a series of steps to transform your Excel data.

One of the steps it allows you to do is to** duplicate columns easily**.

This is helpful when you have columns that you want to duplicate & make some **temporary/permanent changes to it in the Query Editor** but not in your source data.

Let’s suppose you have the following source data below. You can see that the marked column is the one we want duplicated, so let us get to work!

**STEP 1**: Select your data and turn it into an Excel Table by pressing the shortcut **Ctrl + T **or by going to** Insert > Table**

**STEP 2**: Go to *Data > Get & Transform > From Table (Excel 2016) **or** Power Query > Excel Data > From Table (Excel 2013 & 2010)*

**Excel 2016:**

**Excel 2013 & 2010:**

**STEP 3: **This will open up the Power Query Editor.

Select the column you want to duplicate.

Go to **Add Column > General > Duplicate Column**

**STEP 4: **Click **Close & Load** from the **Home** tab and this will **open up a brand new worksheet** in your Excel workbook with the updated table.

You now have your new table with the column duplicated!

**Duplicate Columns Using Power Query or Get & Transform:**

HELPFUL RESOURCE:

Searching...

The post Duplicate Columns Using Power Query or Get & Transform appeared first on Free Microsoft Excel Tutorials.

]]>The post Pivot Table Styles appeared first on Free Microsoft Excel Tutorials.

]]>The default Pivot Table style in Excel is very bland and boring, stemming from a lack of creativity from the nerds over at Microsoft!

You can give some life to your Excel Pivot Table by simply **changing the Pivot Table Style!**

For our example, this is our **Pivot Table**:

**STEP 1:** Make sure you have your Pivot Table selected. Go to **PivotTable Tools > Design > PivotTable Styles**

**STEP 2:** Expand the styles list and have fun selecting your preferred style! You can see I selected the orange style below, as today is a hot day

You now have your Excel **Pivot Table **with your new warm style!

**How to Change Pivot Table Styles in Excel**

**Helpful Resource:**

Searching...

The post Pivot Table Styles appeared first on Free Microsoft Excel Tutorials.

]]>The post Division Formula in Excel appeared first on Free Microsoft Excel Tutorials.

]]>**What does it do?**

Divides two numbers

**Formula breakdown:**

=number1 / number2

**What it means:**

=the number being divided / the number you are dividing by

In Excel dividing numbers together is really easy!

The **Division Formula** is done through the use of the division operator which is depicted by a forward slash: **/**

I will show you in the steps below how you can divide in Excel.

This is the table of values that we want to perform division on:

I explain how you can do this below:

**STEP 1:** We need to **enter the number we want to divide**:

**STEP 2:** Enter the **division operator /**

**STEP 3:** Enter the **number we are dividing by**:

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have all of the division results!

**How to Use the Division Formula in Excel**

HELPFUL RESOURCE:

Searching...

The post Division Formula in Excel appeared first on Free Microsoft Excel Tutorials.

]]>