Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide by C J Benton

Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide by C J Benton

Regular price
Checking stock...
Regular price
Checking stock...
World of Books

At World of Books, you’ll find millions of preloved reads at great prices, from bestsellers to hidden gems. Every book you buy saves money and helps reduce waste, so you can read more for less while giving stories a second life.

The feel-good place to buy books
  • Free US shipping over $15
  • Buying preloved emits 41% less CO2 than new
  • Millions of affordable books
  • Give your books a new home - sell them back to us!

Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide by C J Benton

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, UPER, & LOWER>

    Part 5 - Logic & Lookup Formulas

  • IF>
  • AND>
  • VLOKUP>

    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)

  • SKU Unavailable
    ISBN 13 9781546500247
    ISBN 10 1546500243
    Title Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide
    Author C J Benton
    Condition Unavailable
    Binding Type Paperback
    Publisher Createspace Independent Publishing Platform
    Year published 2017-05-09
    Number of pages 118
    Cover note Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
    Note Unavailable