Best Tutorials website
Latest tutorials

Advertisment

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: 849 | 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: 799 | 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: 885 | 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: 800 | 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: 876 | 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: 835 | 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: 854 | 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: 827 | 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: 813 | 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: 868 | 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: 896 | 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: 856 | 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: 825 | 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: 857 | 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: 907 | Rating star | by Tutorial
MS Excel - Functions

Conditional Formatting in Excel

Conditional Formatting in Excel

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


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

Pivot Tables in Excel

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: 794 | Rating star | by Troy
MS Excel - Functions

Sorting Data in Excel

Sorting Data in Excel

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


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

HYPERLINKS in Excel

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

Multiple Windows in Excel

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

prev1345679next