## Microsoft Excel Formulas and Functions Quick Reference Guide

Subject: Excel
Subject Matter: Formulas and Functions
Topics Covered: 52
Pages: 4
Dimensions: 11 x 17″ – Folded
Price: \$5.95     Quantity Discounts Available
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:

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
Inserting Functions
Using AutoSum and Quick Entry Functions

Financial Functions
DB (Depreciation)
PMT (Payment)

Logical Functions
IF
AND
OR
NOT

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

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

Lookup & Reference Functions
VLOOKUP and HLOOKUP
INDEX
MATCH

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

Statistical Functions
Common Statistical Functions
AVERAGE
COUNT
COUNTA
MAX
MEDIAN
MIN

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

### Recent Excel Posts

Read more +31 October 2023 By Joseph Brownell

### Excel Tables, PivotTables, and Charts Cheat Sheet

Read more +30 June 2023 By Joseph Brownell

### Excel Formulas and Functions Cheat Sheet

Read more +25 May 2023 By Joseph Brownell

TOP