Back to Search
ISBN 9781546500247 is currently unpriced. Please contact us for pricing.
Available options are listed below:

Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide

AUTHOR Benton, C. J.
PUBLISHER Createspace Independent Publishing Platform (05/09/2017)
PRODUCT TYPE Paperback (Paperback)
Description
In just a few short hours, learn the 30 most common Microsoft(R) Excel(R) Formulas & Features quickly and easily with this detailed step-by-step guide

Updated for Excel(R) 2016 this book offers easy to follow examples with screenshots demonstrating how to use the 30 most common basic and intermediate Microsoft(R) Excel(R) formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel(R) at your own pace:

Exercise Files Included

In addition to the following, this book also includes sections on Excel(R) keyboard shortcuts and how to change the currency symbol, for example to the British Pound or Euro .

Part 1 - Excel(R) Formula Fundamentals

  • SUM, SUBTRACTION, MULTIPLICATION, & DIVISION
  • AVERAGE
  • MIN & MAX
  • TODAY, NOW, & NETWORKDAYS
  • SUMIF, AVERAGEIF, COUNTIF, & COUNTIFS

    Part 2 - Introduction to Pivot Tables

  • How to create a Pivot Table report
  • Formatting Pivot Table results
  • Adding Pivot Charts

    Part 3 - Excel(R) Features

  • Data Sorting
  • Conditional Formatting & Filtering
  • Data Validation
  • Text-To-Columns
  • Formula Trace

    Part 4 - Text Functions

  • LEN & TRIM
  • CONCATE (CONCATENATE) & MID
  • PROPER, UPPER, & LOWER

    Part 5 - Logic & Lookup Formulas

  • IF
  • AND
  • VLOOKUP

    Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using Microsoft(R) Excel(R)

    • Show More
    Product Format
    Product Details
    ISBN-13: 9781546500247
    ISBN-10: 1546500243
    Binding: Paperback or Softback (Trade Paperback (Us))
    Content Language: English
    More Product Details
    Page Count: 118
    Carton Quantity: 68
    Product Dimensions: 6.14 x 0.25 x 9.21 inches
    Weight: 0.39 pound(s)
    Country of Origin: US
    Subject Information
    BISAC Categories
    Computers | Desktop Applications - Spreadsheets
    Descriptions, Reviews, Etc.
    publisher marketing
    In just a few short hours, learn the 30 most common Microsoft(R) Excel(R) Formulas & Features quickly and easily with this detailed step-by-step guide

    Updated for Excel(R) 2016 this book offers easy to follow examples with screenshots demonstrating how to use the 30 most common basic and intermediate Microsoft(R) Excel(R) formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel(R) at your own pace:

    Exercise Files Included

    In addition to the following, this book also includes sections on Excel(R) keyboard shortcuts and how to change the currency symbol, for example to the British Pound or Euro .

    Part 1 - Excel(R) Formula Fundamentals

  • SUM, SUBTRACTION, MULTIPLICATION, & DIVISION
  • AVERAGE
  • MIN & MAX
  • TODAY, NOW, & NETWORKDAYS
  • SUMIF, AVERAGEIF, COUNTIF, & COUNTIFS

    Part 2 - Introduction to Pivot Tables

  • How to create a Pivot Table report
  • Formatting Pivot Table results
  • Adding Pivot Charts

    Part 3 - Excel(R) Features

  • Data Sorting
  • Conditional Formatting & Filtering
  • Data Validation
  • Text-To-Columns
  • Formula Trace

    Part 4 - Text Functions

  • LEN & TRIM
  • CONCATE (CONCATENATE) & MID
  • PROPER, UPPER, & LOWER

    Part 5 - Logic & Lookup Formulas

  • IF
  • AND
  • VLOOKUP

    Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using Microsoft(R) Excel(R)

    • Show More
    Paperback