Best Tutorials website
Latest tutorials

Advertisment

Create Spreadsheets using SpreadsheetML

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: 874 | Rating star | by Mathew
MS Excel - Functions

VLOOKUP

VLOOKUP

Learn how to use the VLOOKUP function in Excel


Views: 893 | Rating star | by Jason
MS Excel - Functions

How to use Filter and Advanced Autofilter in Excel

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: 833 | Rating star | by Amy
MS Excel - Functions

Function Wizard

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: 851 | Rating star | by Mathew
MS Excel - Functions

VLOOKUP with large tables of information

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: 787 | Rating star | by Tutorial
MS Excel - Functions

VLOOKUP Errors

VLOOKUP Errors

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


Views: 811 | Rating star | by Sarah
MS Excel - Functions

Automatic sorting of lists in Excel

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: 829 | Rating star | by Nick
MS Excel - Functions

Goalseeking in Excel

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: 861 | Rating star | by Mathew
MS Excel - Functions

Data Tables

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: 885 | Rating star | by Sean
MS Excel - Functions

Multiple Scenarios

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: 837 | Rating star | by Jason
MS Excel - Functions

The watch window in Excel

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: 833 | Rating star | by Steve
MS Excel - Functions

Compound Annual Growth Rate

Compound Annual Growth Rate

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


Views: 796 | Rating star | by Ben
MS Excel - Functions

Show the underlying formulae in all spreadsheet cells

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: 812 | Rating star | by David
MS Excel - Functions

Filling in the blank cells quickly and easily

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: 836 | Rating star | by Steve
MS Excel - Functions

Cleaning up data using the Data Autofilter

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: 833 | Rating star | by Sarah
MS Excel - Functions

Changing Multiple Worksheets at the same time

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: 819 | Rating star | by Source
MS Excel - Functions

Using the RATE function in Excel

Using the RATE function in Excel

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


Views: 823 | Rating star | by Tutorial
MS Excel - Functions

Calculate IRR in Excel

Calculate IRR in Excel

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


Views: 842 | Rating star | by Daniel
MS Excel - Functions

Using NPV in Excel

Using NPV in Excel

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


Views: 862 | Rating star | by Jarry
MS Excel - Functions

Using the PMT function in Excel

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: 806 | Rating star | by Donald
MS Excel - Functions