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

  •
1 1

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

Checking stock...
Checking stock...
Proud to be B-Corp

Our business meets the highest standards of verified social and environmental performance, public transparency and legal accountability to balance profit and purpose. In short, we care about people and the planet.

The feel-good place to buy books
  • Free delivery in the UK
  • Supporting authors with AuthorSHARE
  • 100% recyclable packaging
  • B Corp - kinder to people and planet
  • Buy-back with World of Books - Sell Your Books

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)

    • You might also like

    SKU Nicht verfügbar
    ISBN 13 9781546500247
    ISBN 10 1546500243
    Titel Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide
    Autor C J Benton
    Buchzustand Nicht verfügbar
    Bindungsart Paperback
    Verlag Createspace Independent Publishing Platform
    Erscheinungsjahr 2017-05-09
    Seitenanzahl 118
    Hinweis auf dem Einband Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden.
    Hinweis Nicht verfügbar