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...
The feel-good place to buy books
  • Free UK delivery over £5
  • 10% off preloved books when you join +Plus
  • Buying preloved emits 46% less CO2 than new
  • 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