| |
| Multiple Scenarios
Posted in MS Excel > Functions by tutorialgrub on Apr 02, 2011
The scenario feature allows you to quickly change a number of input cells based on some predefined situations e.g. Low case, High Case, Realistic Case. You can then switch between the various scenarios easily |
| |
| Find/ Replace in Excel
Posted in MS Excel > Functions by tutorialgrub on Mar 09, 2011
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 spreadsheet. |
| |
| Conditional Formatting in Excel
Posted in MS Excel > Functions by tutorialgrub on Mar 09, 2011
Change the format of cells depending on their contents and various other conditions that may be required. |
| |
| Protecting a Workbook in Excel
Posted in MS Excel > Functions by tutorialgrub on Mar 06, 2011
Workbook-level protection- You can apply protection to workbook elements and you can protect a workbook file from viewing and changes. |
| |
| LOWER, UPPER and PROPER functions in Excel
Posted in MS Excel > Functions by tutorialgrub on Mar 03, 2011
These text functions give you the ability to change the capitalization (case) of cells to being all lower, or all UPPER, or Proper. |
| |
| The ISERROR function in Excel
Posted in MS Excel > Functions by tutorialgrub on Feb 26, 2011
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!) errors and is often combined with an IF statement to provide an alternate action if an error is generated. |
<< 1 2 3 4 |
