Advertisment

How to Create a Simple Macro in Excel

Learn to create a simple macro in Excel using step by step instructions with screenshots.

Views: 1155 | | by Simon
MS Excel - Macros

Goalseeking in Excel

The Goalseek feature allows you to specify the result you require and which input can change. Then the computer will calculate the required number....

Views: 1004 | | by Mathew
MS Excel - Functions

Data Tables

Learn how to use Excel's Data Tables feature to automatically run multiple scenarios through a model, based on either one or two variables.

Views: 1083 | | by Sean
MS Excel - Functions

Multiple Scenarios

The scenario feature allows you to quickly change a number of input cells based on some predefined situations e.g. Low case, High Case, Realistic...

Views: 994 | | by Jason
MS Excel - Functions

The watch window in Excel

The watch window allows you to continuously view cells that interest you (no matter where they are on the spreadsheet) while making changes to...

Views: 974 | | by Steve
MS Excel - Functions

Compound Annual Growth Rate

Use the RATE function in Excel to calculate the Compound Annual Growth Rate (CAGR)

Views: 929 | | by Ben
MS Excel - Functions

Show the underlying formulae in all spreadsheet cells

A shortcut which allows you to show either the results in all cells or the underlying formula in the cells

Views: 971 | | by David
MS Excel - Functions

Filling in the blank cells quickly and easily

There are occasions when you would like to fill in all blank cells with a formula. This is a quick and easy way to achieve this. Use is made of the...

Views: 956 | | by Steve
MS Excel - Functions

Cleaning up data using the Data Autofilter

Excel is often used as a means of cleaning up data and producing reports. Often the most time consuming aspect is the data cleanup. Using the Data...

Views: 974 | | by Sarah
MS Excel - Functions

Changing Multiple Worksheets at the same time

In Excel it is possible to change a number of worksheets at the same time. Extremely useful but don't forget to switch it off once you are done!

Views: 952 | | by Source
MS Excel - Functions

Learn to use a drop down menu in excel

In this tutorial you will be able to learn how to incorporate a drop down menu into a pay form.

Views: 993 | | by Nick
MS Excel - Basics

Using the RATE function in Excel

Calculate the interest RATE charged on a constant annuity cash flow.

Views: 979 | | by Tutorial
MS Excel - Functions

Calculate IRR in Excel

Calculate the Internal Rate of Return of a series of cash flows

Views: 985 | | by Daniel
MS Excel - Functions

Using NPV in Excel

Calculate the Net Present Value of a series of cash flows.

Views: 1004 | | by Jarry
MS Excel - Functions

Using the PMT function in Excel

The PMT function calculates the required repayment amount to amortize (pay off) a debt or loan based on the original capital amount, interest...

Views: 944 | | by Donald
MS Excel - Functions

CUMIPMT and CUMPRINC in Excel

The CUMIPMT and CUMPRINC functions allow you calculate the total interest or capital (principal) paid between any two periods without having to...

Views: 969 | | by Donald
MS Excel - Functions

TRANSPOSE in Excel

Two methods to quickly and easily move information from row format into a column format, or a column into a row.

Views: 1013 | | by Source
MS Excel - Functions

CHOOSE in Excel

The Choose function allows you to refer to different cells depending on the results of a cell. Often useful as an alternate to the IF function...

Views: 992 | | by Tutorial
MS Excel - Functions

OFFSET in Excel

Offset allows you to refer to cells above, below, left or right of a reference cell. Very useful for cash flow forecasts where the receipt or...

Views: 1015 | | by Jarry
MS Excel - Functions

The SUMIF and COUNTIF functions in Excel

The Sumif and Countif commands allow you to sum or count cells depending on whether they meet the stated criteria

Views: 977 | | by Tutorial
MS Excel - Functions