Books > Best Sellers > Computers & Technology




Price: $5.75

(as of 2012-10-06 20:34:09 PST)

Usually ships in 24 hours

Computers & Technology

Rating: 4.5 / 5.0 (6 votes)

Released: 2011-04-15

Buying Choices

5 new from $5.68
4 used from $5.68

(as of 2012-10-06 20:34:09 PST)








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

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 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.
Check All OffersAdd to Wish ListCustomer Reviews

Book Details

Author: Beezix IncPublisher: Beezix Inc.Binding: PamphletLanguage: EnglishPages: 4

Similar Books

Microsoft Excel 2010 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts..
Microsoft Word 2010 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts ..
Microsoft PowerPoint 2010 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shor..
Microsoft Excel 2010 Tables, PivotTables, Sorting & Filtering Quick Reference Guide (Cheat Sheet of In..
Microsoft Excel 2010 Advanced & Macros Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shor..


Comments




Become a fan of Book Presence on Facebook for the inside scoop on latest and most exclusive books.