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