Advertisment
The CUMIPMT and CUMPRINC functions allow you calculate the total interest or capital (principal) paid between any two periods without having to...
Two methods to quickly and easily move information from row format into a column format, or a column into a row.
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...
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...
The Sumif and Countif commands allow you to sum or count cells depending on whether they meet the stated criteria
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...
| by Donald 
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