×

Contact Us

Corporate Headquarters

TeachUcomp, Inc.
1140 Abbot Road
#64
East Lansing MI 48823
USA

Phone

Toll Free (U.S. and Canada): 877-925-8080
International:  +1-517-333-2560

Email

sales@teachucomp.com

Hours of Operation

Monday-Friday 9:00-5:00 Eastern.

Policies

Privacy Policy

Terms and Conditions

Excel Formulas and Functions Quick Reference Guide

$5.95

Available via Printed/Laminated (Shipped/Physical) or PDF (Download Only):

Quantity: Price:
1-49 $5.95
50-99 $4.85
100-499 $4.05
500-999 $3.50
1000+ $3.35

Description

Subject: Excel
Subject Matter: Formulas and Functions
Level: Intermediate/Advanced
Topics Covered: 52
Pages: 4
Dimensions: 11 x 17″ – Folded
Availability: Printed & Laminated or PDF Download
ISBN: 978-1-958446-17-1

Product Description

Designed with the busy professional in mind, this 4-page quick reference guide provides syntax, explanations, and examples for some of Microsoft Excel’s most popular and powerful functions. When you need to write the perfect formula, you will find answers right at your fingertips with our Microsoft Excel Formulas & Functions Quick Reference Guide. Each topic is presented in a concise and easy-to-understand format, allowing you to quickly grasp the essentials of each function. From basic formulas to advanced lookup functions, our guide provides step-by-step instructions and real-world examples to ensure your success. Clear and easy-to-use, quick reference cards are perfect for individuals, businesses and as supplemental training materials.

Topics Covered:

About Formulas and Functions
Formulas and Functions Terminology
Basic Formula Structure
The Formula Bar
Creating a Formula 

Cell Referencing and Naming
Standard Cell Referencing
Relative vs. Absolute Cell References
Referencing Cells in Different Worksheets
Naming Cells and Cell Ranges
Creating a Named Range
Limiting the Scope of a Name
Creating Multiple Names at Once
Selecting a Named Range
Using a Range Name in a Formula
Managing Range Names

Functions
About Functions
Inserting Functions
Using AutoSum and Quick Entry Functions

Financial Functions
About Financial Functions
DB (Depreciation)
PMT (Payment)

Logical Functions
About Logical Functions
IF
AND
OR
NOT

Text Functions
About Text Functions
FIND
LEFT and RIGHT
MID
LEN
TRIM
LOWER, UPPER, and PROPER
VALUE
CONCAT (Concatenate)

Date & Time Functions
About Date & Time Functions
TODAY and NOW
DATE
YEAR, MONTH, and DAY
WEEKDAY
NETWORKDAYS
EDATE (New Date)

Lookup & Reference Functions
About Lookup & Reference Functions
VLOOKUP and HLOOKUP
INDEX
MATCH

Math & Trig Functions
About Math & Trig Functions
Common Math & Trig Functions
SUM
SUMIF
PRODUCT
ROUND
MROUND
ROUNDUP
ROUNDDOWN
INT

Statistical Functions
About Statistical Functions
Common Statistical Functions
AVERAGE
COUNT
COUNTA
MAX
MEDIAN
MIN

Errors and Troubleshooting
Automatic Error Checking
Using Information Functions
Using the Error Checker

You may also like…

  • One Year Subscription- Access to Entire Library

    $99.00 for 1 year
    Add to CartMORE INFO
TOP