fbpx
Search
Close this search box.

All articles with 'goal seek' Tag

Compound Interest Formula in Excel

Published on Apr 2, 2024 in Learn Excel
Compound Interest Formula in Excel

Classically, known as “interest on interest”, compound interest is the most common type interest used in every day finance situations.

To calculate compound interest in Excel,

on principal amount P
at the rate of interest R
for the number of years N
and compounded T times per year
we can use the formula = P*(1+R/T)^(N*T)

In this article, understand how to calculate various kinds of compound interest values using Excel formulas.

Continue »

How to Solve an Equation in Excel

Published on Sep 19, 2013 in Huis, Posts by Hui
How to Solve an Equation in Excel

How to Solve an Equation in Excel

Continue »

Are you a Solver Virgin? Watch this tutorial video …,

Published on Oct 15, 2010 in Featured, Learn Excel

Do you ever think about questions like this?
1) What is the maximum profit we can make?
2) What is the best way to schedule employees in shifts?
3) What the best combination of tasks we can finish in a given time?

You might have heard about Excel Solver tool while trying to find solutions to questions above. If you have never used Solver or have little idea about it, then this post and video are for you.

Continue »

31 Excel Tutorials – Learn and Be Awesome in Excel

Published on Mar 11, 2010 in Charts and Graphs, Featured, Learn Excel
31 Excel Tutorials – Learn and Be Awesome in Excel

In October 2008, I have started an ambitious series of posts on this blog called – Spreadcheats. These are little tricks, nuggets, tutorials on using Excel that would make anyone a spreadsheet guru.

The spreadcheats series has been wildly successful. I am compiling all this useful information and articles in to one big post so that anyone can follow the links and become good in Excel. Read on,

[Note: This is not for beginners. If you know what a formula is, you would enjoy this 31 articles]

Continue »

Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)

Published on Jul 29, 2009 in Excel Howtos, Featured, Learn Excel, personal finance
Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)

In this installment of spreadcheats, we will learn how to use goal seek feature of excel. We will build a retirement savings calculator using excel. We will learn to use Excel’s FV() formula to estimate the corpus that can be accumulated by saving fixed amount every month.

Continue »