Free shipping on orders over $99
Microsoft Excel 365 Formulas

Microsoft Excel 365 Formulas

A QuickStudy Laminated Reference Guide

by Curtis Frye
Fold-out book or chart
Publication Date: 01/05/2021

Share This Book:

RRP  $19.99

RRP means 'Recommended Retail Price' and is the price our supplier recommends to retailers that the product be offered for sale. It does not necessarily mean the product has been offered or sold at the RRP by us or anyone else.

$19.75
or 4 easy payments of $4.94 with
afterpay
    Please Note: We will source your item through a special order. Generally sent within 120 days.
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
ISBN:
9781423246664
9781423246664
Category:
Personnel & human resources management
Format:
Fold-out book or chart
Publication Date:
01-05-2021
Language:
English
Publisher:
BarCharts Publishing, Inc.
Country of origin:
United States
Dimensions (mm):
279.4x215.9x1.52mm
Weight:
0.07kg

Our Australian supplier has this title on order. You can place a backorder for this title now and we will ship it to you when it becomes available. 

While we are unable to provide a delivery estimate, most backorders will be delivered within 120 days. If we are informed by our supplier that the title is no longer available during this time, we will cancel and refund you for this item.  Likewise, if no delivery estimate has been provided within 120 days, we will contact our supplier for an update.  If there is still no delivery estimate we will then cancel the item and provided you with a refund.

If we are able to secure you a copy of the title, our supplier will despatch it to our Sydney warehouse.  Once received we make sure it is in perfect condition and then despatch it to you via the Australia Post eParcel service, which includes online tracking.  You will receive a shipping notice from us when this occurs.

Reviews

Be the first to review Microsoft Excel 365 Formulas.