The RANK function in Excel - Excel tutorial

Category: Excel tutorials > Functions - Difficulty:

Its easy to chart and list that contains two columns you want to graph one with text labels and one with numeric data. But in real life, you'll need to deal with many different types of data that occupy many different configurations on your worksheet

If your spreadsheet needs to access constantly updated data, or if you need to access services hosted on another computer, Excel's Web Services support will enable you to get connected.

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

If XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into Excel directly, tell Excel how you want to present it, and work with the data through maps.

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