Advertisment

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: 770 | | by Brad
MS Excel - Functions

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: 725 | | by Slicer
MS Excel - Functions

MAX and MIN in Excel

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

Views: 809 | | by Sarah
MS Excel - Functions

The IF function in Excel

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

Views: 722 | | by Jarry
MS Excel - Functions

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: 798 | | by John
MS Excel - Functions

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: 754 | | by John
MS Excel - Functions

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: 767 | | by Amy
MS Excel - Functions

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: 748 | | by Source
MS Excel - Functions

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: 737 | | by Brad
MS Excel - Functions

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: 795 | | by Colin
MS Excel - Functions

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: 819 | | by Ben
MS Excel - Functions

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: 781 | | by Stephen
MS Excel - Functions

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: 753 | | by Isac
MS Excel - Functions

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: 777 | | by David
MS Excel - Functions

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: 828 | | by Tutorial
MS Excel - Functions

Conditional Formatting in Excel

Change the format of cells depending on their contents and various other conditions that may be required.

Views: 714 | | by Tutorial
MS Excel - Functions

Pivot Tables in Excel

Pivot tables allow you to report on vast sums of information in a quick and efficient manner. Probably Excels most valuable tool.

Views: 721 | | by Troy
MS Excel - Functions

Sorting Data in Excel

Learn how to sort data in Excel, including how to develop customized sort orders to meet your exact needs.

Views: 766 | | by Tutorial
MS Excel - Functions

HYPERLINKS in Excel

Learn how to use hyperlinks to navigate through a spreadsheet or to other electronic documents. Easier (and safer) than using visual basic and...

Views: 814 | | by Sean
MS Excel - Functions

Multiple Windows in Excel

Learn how to split and freeze your window so that you can view more than one section of a spreadsheet at the same time. Also learn how to arrange...

Views: 715 | | by Mathew
MS Excel - Functions