Microsoft Excel 2010 Functions & Formulas Quick Reference Guide

mi/6493774

Издательство: Beezix, Inc.

Год: 2011

Дополнительные характеристики

Страниц
4 стр.

Цена на OZON:

70600 руб.



Описание:

Geared toward the intermediate to advanced user, this example-rich 4-page laminated quick reference guide provides explanations and context for many powerful functions and formulas. Step-by-step instructions for many function/formula-related features. Topics include:
Conditionally Summing Data (SUMIF, COUNTIF)
Being Precise (Rounding functions)
Improving Clarity with Range Names
Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE)
Changing Results: IF, AND, OR
Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH)
Error Recovery (ISNA, ISERROR)
Array Formulas (Single Cell & Multi-Cell Arrays)
Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAY)
Using a Formula for Data Validation
Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Show/Hide Formulas, Watching Cells, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows.



Отзывы:

Возможность скачать PDF:


Чтобы Microsoft Excel 2010 Functions & Formulas Quick Reference Guide скачать в PDF формате, нажмите на одной из кнопок социльных сетей: