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)

• Authors: Beezix Inc. - Beezix Inc
• ISBN 10: 1936220253
• ISBN 13: 9781936220250
• Release: April 15, 2011
• Format: Pamphlet (4 pages)
• List Price: $5.75
• More Details
  
  

  List Price: $5.75

  Tags: Computers & Internet, Microsoft, Applications,

  Book Description:
  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 NamesMerging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE)Changing Results: IF, AND, ORTable 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 ValidationTroubleshooting: 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.

Filter By Condition

  Used
  New
  Rental
  eBooks
  International
  Local Options

Search By Location

Rental Term

Summer Quarter Semester

Show Prices

Lower to higher Higher to Lower

  Apply Coupons
  Apply Sales Tax (estimate)

Add To My Bookbag Tweet Alert Sell Donate Contact Us

• Home
• Buy Textbooks
• Rent Textbooks
• Sell Textbooks
• New & Used Rental Buyback

Bookbag () | College Textbooks

• • Buy Cheap Textbooks
  • Sell Used Textbooks
  • Browse Textbooks
  • Textbook Information
  • Donate Your Books
• • My Bookbag
  • My Account
  • Price Alerts
  • Track Order
  • Help
• • SmartPhone Apps
  • Bookmark Us
  • Tell A Friend
  • Campus Bookstore Directory
• • Textbook Blog
  • Mobile & Local
  • Press
  • Affiliates
  • Feedback

Content Copyright © 1999-2013 Terms and Conditions of Use, Security and Privacy Policy | Resources: 1 2 3 | Site Map