Strict Standards: Redefining already defined constructor for class XML_Parser in /home/sites/www.americanpoems.com/web/store/aom/includes/os.php on line 1188

Strict Standards: Declaration of XML_Parser::raiseError() should be compatible with PEAR::raiseError($message = NULL, $code = NULL, $mode = NULL, $options = NULL, $userinfo = NULL, $error_class = NULL, $skipmsg = false) in /home/sites/www.americanpoems.com/web/store/aom/includes/os.php on line 1604

Strict Standards: Declaration of XML_Unserializer::startHandler() should be compatible with XML_Parser::startHandler($xp, $elem, &$attribs) in /home/sites/www.americanpoems.com/web/store/aom/includes/os.php on line 3503

Strict Standards: Declaration of Cache_Lite_File::get() should be compatible with Cache_Lite::get($id, $group = 'default', $doNotTestCacheValidity = false) in /home/sites/www.americanpoems.com/web/store/aom/includes/cache.php on line 1020
American Poems: Software: Microsoft Excel 2010 Functions & Formulas Quick Reference Guide (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide)
Home
Apparel
Appliances
Books
DVD
Electronics
Home & Garden
Kindle eBooks
Magazines
Music
Outdoor Living
Software
Tools & Hardware
PC & Video Games
Location:
 Home » Software » Microsoft Excel 2010 Functions & Formulas Quick Reference Guide (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide)

Microsoft Excel 2010 Functions & Formulas Quick Reference Guide (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide)

  • List Price: $5.75
  • Buy New: $4.81
  • as of 8/21/2014 03:46 EDT details
  • You Save: $0.94 (16%)
In Stock
New (4) Used (5) from $4.81
  • Seller:Clocktower-Books
  • Sales Rank:5,939
  • Languages:English (Unknown), English (Published)
  • Media:Pamphlet
  • Pages:4
  • Shipping Weight (lbs):0.1
  • Dimensions (in):12 x 7 x 0.3
  • Publication Date:April 15, 2011
  • ISBN:1936220253
  • EAN:9781936220250
  • ASIN:1936220253
Availability:Usually ships in 1-2 business days


Editorial Reviews:
Synopsis
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. This guide is suitable as a training handout, or simply an easy to use reference guide. The following 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.

This guide is one of several titles available for Excel 2010: Excel 2010 Introduction; Excel 2010 Tables, PivotTables, Sorting & Filtering; Advanced & Macros; Charts & Sparklines; Functions & Formulas.

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
Brought to you by American Poems