Best Tutorials website
Latest tutorials

Advertisment

CUMIPMT and CUMPRINC in Excel

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

TRANSPOSE in Excel

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

CHOOSE in Excel

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

OFFSET in Excel

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: 762 | Rating star | by Jarry
MS Excel - Functions

The SUMIF and COUNTIF functions in Excel

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

End of Month function in Excel

End of Month function in Excel

The EOMONTH (end of month) function allows you to generate a month end date no matter what the original date (even taking into account leap years)....


Views: 764 | Rating star | by Brad
MS Excel - Functions

The RANK function in Excel

The RANK function in Excel

The Rank function allows you to rank a selection of cells in ascending or descending order automatically. Easier than using complex IF functions to...


Views: 719 | Rating star | by Slicer
MS Excel - Functions

MAX and MIN in Excel

MAX and MIN in Excel

Max and Min allows you to specify the maximum or minimum number that can appear in a cell.


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

The IF function in Excel

The IF function in Excel

The IF function allows you to perform alternate actions depending on certain criteria.


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

AND & OR in Excel

AND & OR in Excel

These functions allow you to check multiple criteria that they either all meet the criteria (AND) or at least some of them do (OR).


Views: 787 | Rating star | by John
MS Excel - Functions

The CONCATENATE function in Excel

The CONCATENATE function in Excel

The Concatenate (or &) can be used to join up the contents of multiple cells into one cell. This text function is extremely useful for generating...


Views: 744 | Rating star | by John
MS Excel - Functions

LOWER, UPPER and PROPER functions in Excel

LOWER, UPPER and PROPER functions in Excel

These text functions give you the ability to change the capitalization (case) of cells to being all lower, or all UPPER, or Proper.


Views: 762 | Rating star | by Amy
MS Excel - Functions

LEFT, RIGHT and MID in Excel

LEFT, RIGHT and MID in Excel

These text functions give you the ability to to extract certain segments of a cell (normally text). Useful if only part of a cell's text...


Views: 738 | Rating star | by Source
MS Excel - Functions

The ISERROR function in Excel

The ISERROR function in Excel

The ISERROR function allows you to test whether a cell has generated an error message. This is particularly useful for division by zero (#DIV/0!)...


Views: 728 | Rating star | by Brad
MS Excel - Functions

GROUP and UNGROUP in Excel

GROUP and UNGROUP in Excel

Learn how to group and ungroup rows and columns so that you can easily hide or unhide the rows and columns you are interested in.


Views: 785 | Rating star | by Colin
MS Excel - Functions

Data AutoFilter in Excel

Data AutoFilter in Excel

The Data Autofilter allows you to investigate large quantities of information and filter out unnecessary rows. Extremely useful if you work with...


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

Protecting a Workbook in Excel

Protecting a Workbook in Excel

Workbook-level protection- You can apply protection to workbook elements and you can protect a workbook file from viewing and changes.


Views: 771 | Rating star | by Stephen
MS Excel - Functions

External Links in Excel

External Links in Excel

Excel is often used to link multiple spreadsheets. However, the risks associated with handling these links is often misunderstood. This will show...


Views: 743 | Rating star | by Isac
MS Excel - Functions

GoTo Special in Excel

GoTo Special in Excel

Due to the size of spreadsheets it would sometimes be useful to quickly highlight all cells exhibiting the same criteria. This features allows you...


Views: 768 | Rating star | by David
MS Excel - Functions

Find/ Replace in Excel

Find/ Replace in Excel

The find replace tool is more commonly used in MS Word. However, it is extremely useful in Excel and can be used to quickly make changes to a...


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