• Excel Functions & Formulas in easy steps
1 1

Excel Functions & Formulas in easy steps

$15.99
$0.00 $15.99
Sold out
Excel Functions and Formulas in easy steps shows you how to use the power of Excel functions and formulas to take full advantage of this popular spreadsheet application. Learn how to: Save time ...
Read More
  • 28 July 2020
View Product Details

Excel Functions and Formulas in easy steps shows you how to use the power of Excel functions and formulas to take full advantage of this popular spreadsheet application. Learn how to:


  • Save time by utilizing Excel functions to carry out often-used operations, for error checking and tracing cells.
  • Build powerful spreadsheets using the features of Excel formulas.
  • Explore all the categories of Excel functions including financial, logical, mathematical, lookup and other data-related functions.
  • Review business-oriented scenarios and examples of functions in each of the groups.
  • Create your own simple macros, and more.

    • Covering all recent versions of Excel including Excel in Office 365, this book will guide you through a myriad of Excel functions and formulas – clearly, concisely and in easy steps!

    files/i.png Icon
    Price: $15.99
    Pages: 192
    Publisher: In Easy Steps Limited
    Imprint: In Easy Steps Limited
    Publication Date: 28 July 2020
    Trim Size: 8.88 X 7.38 in
    ISBN: 9781840788815
    Format: Paperback
    BISACs: Computer programming / software engineering, Games development & programming, Mobile & handheld device programming / Apps programming
    REVIEWS Icon
    1. Values and Formulas
    2. Managing Formulas
    3. Functions
    4. Math & Trig and Logical
    5. Date & Time and Text
    6. Financial and Statistical
    7. Lookup & Reference and Information
    8. Database and Engineering
    9. Compatibility, Cube and Web
    10. User Defined Add-ins and Macros
    11. Support and References


      1. Values and Formulas
        • Cell Contents
        • Values
        • Formulas
        • Operators
        • Order of Calculation
        • Creating Formulas
        • Named References
        • Named Constants
        • Formula Assistance
        • Adding Comments
        • Error Values
      1. Auditing Formulas
        • The Formulas Tab
        • Formula Auditing
        • Trace Precedents
        • Trace Dependents
        • Show Formulas
        • Error Checking
        • Evaluate Formula
        • Watch Window
        • Calculation Options
        • External References
        • Array Formulas
        • Dynamic Arrays
      1. Functions
        • Excel Functions
        • Function Structure
        • Type the Function
        • AutoComplete
        • Function Library
        • Insert Function
        • Function Categories
        • AutoSum
        • Recently Used
        • Alphabetic List
        • Developer Tab
        • Add-ins
      1. Math & Trig and Logical Functions
        • Math & Trig Category
        • SUM Functions
        • Random Numbers
        • Rounding Functions
        • Trig Functions
        • Logical Category
        • IF Function
        • IFS Function
        • Switch Function
      1. Date & Time and Text Functions
        • Date & Time Category
        • Date Formats
        • Time Formats
        • Leap Year Inconsistancy
        • DateDif Function
        • Workday Functions
        • Text Category
        • Concat Function
        • Textjoin Function
        • Case Functions
        • Sentence Case
        • Substitute Function
        • BahtText Function
      1. Financial and Statistical Functions
        • Financial Functions
        • Payments
        • Future Value
        • Depreciation
        • Statistical Functions
        • Averages
        • Standard Deviation
        • Forecasts
        • Counting
      1. Lookup & Reference and Information Functions
        • Lookup & Reference Category
        • Lookup Functions
        • Match Function
        • Index Function
        • Information Category
        • Error.type Function
        • IS Functions
        • Info Funion
        • Cell Function
        • Type Functions
      1. Database and Engineering
        • Database Category
        • Excel Database
        • Dget Function
        • Dsum Function
        • Excel Tables
        • Table used by Database
        • Engineering Category
        • Convert Function
        • Convert Between Bases
        • Delta Function
        • Gestep Function
      1. Web, Cube and Compatibility Functions
        • Web Functions
        • Scenarios
        • Examples
        • Cube Functions
        • Scenarios
        • Examples
        • Compatibility Functions
        • Scenarios
        • Examples
      1. User Defined and VBA & Macros Functions
        • User Defined Functions
        • Scenarios
        • Examples
        • VBA & Macros Functions
        • Scenarios
        • Examples
      1. Function References
        • What If Analysis
        • Templates
        • Microsoft Support
        • Functions in Excel for the Web
        • Functions by Categories
        • Alphabetical Listing
        • Internet Resources