Quick and easy 6 page laminated guide loaded with essentials focusing on creating and using formulas efficiently and effectively. For beginners or experienced users, formulas are Excel's superpower that can be yours. Find hundreds of the most popular and useful functions for formulas fast and with clear succinct steps to get the task done. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant use of formulas for users at different levels. Look for Excel 365, Excel 365 "Tips and Tricks", "Advanced" and "Pivot Tables" QuickStudy guides to have a complete power-user reference set.
6 page laminated reference guide includes:

Order of Operations
Creating Formulas
Using Tables in Formulas
Organizing Data Using Named Ranges
Summary & Statistical Functions
Counting Values in Cell Ranges
Performing Financial Calculations
- Principal & Interest Payments
- Calculating Present & Future Value
- Calculating Time to Reach an Investment Goal
Performing Conditional Calculations Using IF & IFERROR
- Logical Comparisons
- Error Codes
Processing Text Using Formulas
- Extracting Text From a Cell
- Cleaning Imported Data
- Combining Multiple Text Strings
Performing Date Calculations
Finding & Displaying Cell Values & Formula Text
- Look Up Cell Values
- Display Formula Text
Division, Decimals & Rounding
- Dividing Values to Find Quotients & Reminders
- Finding the Integer & Decimal Parts of Numbers
- Rounding Numbers Up & Down
- Generating Random Values
Auditing Formulas

Suggested uses:

Workplace - flat for easy storage and access at a moments notice to find a formula function you need to use, or to jog your memory for a function you do not use often
Company Training - reduce help-desk calls and keep productivity flowing for a team or for your entire company
Students/Professors - make lives easier for students in many majors needing Excel for data management and calculation

"About this title" may belong to another edition of this title.

Store Description

SuperBookDeals.com is your top source for finding new books at the absolute lowest prices, guaranteed ! We offer big discounts - everyday - on millions of titles in virtually any category, from Architecture to Zoology -- and everything in between. Discover great deals and super-savings, on professional books, text book titles, the newest computer guides, or your favorite fiction authors. You'll find it all - at HUGE SAVINGS - at SuperBookDeals. Browse through our complete online product catalog today. Serving customers around the world for years, we help thousands find just the books they're looking for -- at incredibly low, bargain prices.

Visit Seller's Storefront

Seller's business information

Expert Trading Limited
9220 Rumsey Road, Suite 101, Columbia, MD, 21045, U.S.A.

Sale & Shipping Terms

Terms of Sale

Company Name: GreatBookPrices
Legal Entity: Expert Trading, LLC
Address: 6310 Stevens Forest, suite 200, Columbia MD 21046
Email address: CustomerService@SuperBookDeals.com
Phone number: 410-964-0026
consumer complaints can be addressed to address above
Registration #: 52-1713923
Authorized representative: Danielle Hainsey

Right of cancellation

Shipping Terms

Our warehouses across the globe are fully operational without substantial delays. We are working hard and continue to overcome the daily challenges presented by COVID-19. We appreciate your understanding.

Internal processing of your order will take about 1-2 business days. Please allow an additional 4-14 business days for Media Mail delivery. We have multiple ship-from locations - MD,IL,NJ,UK,IN,NV,TN & GA

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	8 to 14 business days	5 to 14 business days
First item	� 1.97	� 1.97

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.