Advertisment

Create Spreadsheets using SpreadsheetML

While exporting spreadsheets as XML is useful, Excel also lets you import information this way, letting you create spreadsheets using...

Views: 970 | | by Mathew
MS Excel - Functions

VLOOKUP

Learn how to use the VLOOKUP function in Excel

Views: 1001 | | by Jason
MS Excel - Functions

How to use Filter and Advanced Autofilter in Excel

How to Easily use the Autofilter and Advanced Filter Functions in Excel in order to automate repetitive tasks.

Views: 911 | | by Amy
MS Excel - Functions

Function Wizard

The function wizard allows you to use any of Excels functions in a very user friendly way. You therefore do not need to remember the complex syntax...

Views: 960 | | by Mathew
MS Excel - Functions

VLOOKUP with large tables of information

Once you have mastered VLOOKUP you may find that you use it for large datasets. The problem is that when you make changes to your spreadsheet you...

Views: 883 | | by Tutorial
MS Excel - Functions

VLOOKUP Errors

As useful as the VLOOKUP function is, there is a significant risk of errors. Learn what you must watch for.

Views: 905 | | by Sarah
MS Excel - Functions

Automatic sorting of lists in Excel

By combining the VLOOKUP and RANK functions you can have Excel automatically sort a list of data into a specific order.

Views: 927 | | by Nick
MS Excel - Functions

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: 970 | | 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: 1041 | | 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: 959 | | 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: 933 | | by Steve
MS Excel - Functions

Compound Annual Growth Rate

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

Views: 895 | | 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: 942 | | 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: 923 | | 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: 919 | | 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: 916 | | by Source
MS Excel - Functions

Using the RATE function in Excel

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

Views: 924 | | by Tutorial
MS Excel - Functions

Calculate IRR in Excel

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

Views: 945 | | by Daniel
MS Excel - Functions

Using NPV in Excel

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

Views: 967 | | 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: 910 | | by Donald
MS Excel - Functions