Tools and resources to Excel

Tools and resources to Excel

Самые популярные статьи этого раздела

Conditional formatting is one of the most useful tools in EXCEL. The ability to use it can save the user a lot of time and effort.

Дата публикации: 26.10.2012

If the value in cell satisfies a user-specified condition, use the Conditional formatting it is possible to allocate this cell (for example, change its background). In this article, go ahead - will highlight the entire table row containing this cell.

Дата публикации: 10.10.2013

the Main drawback of the standard filter (Data/ Sort & filter/ Filter) – is the lack of visual information about applied at the moment the filter is necessary every time to go into the filter menu to remember the selection criteria of the records. This is especially inconvenient when applied several criteria. Advanced filter does not have this drawback all criteria are placed in separate plates over the filtered records.

Дата публикации: 31.03.2013

Normally when you create a formula, the user specifies the parameter values and the formula (equation) returns the result. For example, you have the equation 2*a+3*b=x, given the parameters a=1, b=2, it is required to find x (2*1+3*2=8). Tool Selection setting allows to solve the inverse problem: to choose the parameter value at which the equation returns the desired target outcome X. For example, if a=3, is required to find a parameter value b for which X is equal to 21 (the answer is b=5). Pick up the parameter manually boring, so in MS EXCEL there is a tool Selection option.

Дата публикации: 18.11.2012