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

Benton, C.J.

 
9781546500247: Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide
Softcover
ISBN 10: 1546500243 ISBN 13: 9781546500247
Verlag: CreateSpace Independent Publishing Platform, 2017

Inhaltsangabe

In just a few short hours, learn the 30 most common Microsoft® Excel® Formulas & Features quickly and easily with this detailed step-by-step guide!

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

Exercise Files Included!

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

Part 1 - Excel® 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® 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® Excel®!

    • Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

    Reseña del editor

    In just a few short hours, learn the 30 most common Microsoft® Excel® Formulas & Features quickly and easily with this detailed step-by-step guide!

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

    Exercise Files Included!

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

    Part 1 - Excel® 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® 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® Excel®!

    • „Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

    Verlag
    CreateSpace Independent Publishing Platform
    Erscheinungsdatum
    2017
    Sprache
    Englisch
    ISBN 10 
    1546500243
    ISBN 13 
    9781546500247
    Einband
    Tapa blanda
    Anzahl der Seiten
    118
    Kontakt zum Hersteller
    Nicht verfügbar
    Verantwortliche Person
    Nicht verfügbar