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