Advertisment
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)....
The Rank function allows you to rank a selection of cells in ascending or descending order automatically. Easier than using complex IF functions to...
Max and Min allows you to specify the maximum or minimum number that can appear in a cell.
The IF function allows you to perform alternate actions depending on certain criteria.
These functions allow you to check multiple criteria that they either all meet the criteria (AND) or at least some of them do (OR).
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...
These text functions give you the ability to change the capitalization (case) of cells to being all lower, or all UPPER, or Proper.
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...
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!)...
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.
The Data Autofilter allows you to investigate large quantities of information and filter out unnecessary rows. Extremely useful if you work with...
Workbook-level protection- You can apply protection to workbook elements and you can protect a workbook file from viewing and changes.
Excel is often used to link multiple spreadsheets. However, the risks associated with handling these links is often misunderstood. This will show...
Due to the size of spreadsheets it would sometimes be useful to quickly highlight all cells exhibiting the same criteria. This features allows you...
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...
Change the format of cells depending on their contents and various other conditions that may be required.
Pivot tables allow you to report on vast sums of information in a quick and efficient manner. Probably Excels most valuable tool.
Learn how to sort data in Excel, including how to develop customized sort orders to meet your exact needs.
Learn how to use hyperlinks to navigate through a spreadsheet or to other electronic documents. Easier (and safer) than using visual basic and...
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...
| by Brad 
Ciara forum signature
Water in Cinema 4D
Hologram
Star Wars Hailfire Droid
Create a computer case model
CSS graphic menu with rollovers
XP Style Beaker Icon
Creating a Waterfall