Searching... Searching...

Total Subscribers Receiving Our Weekly Excel Lessons

+55,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

Calculate the Compound Interest with Excel’s FV Formula

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 Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Top Excel Formulas & Function Examples To Get Better At Microsoft Excel

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 Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Addition Formula in Excel

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 Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Subtraction Formula in Excel

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 Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Duplicate Columns Using Power Query or Get & Transform

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 Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Pivot Table Styles

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: DOWNLOAD EXCEL WORKBOOK STEP 1: Make sure you have Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Division Formula in Excel

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 Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+
Searching... Searching...
Get better at Excel!

Do you want to get better at Excel?

If so, join over 45,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis & DOWNLOAD my 80 page Excel Resource Guide eBook for Free!