Articles liés à The Microsoft Excel Step-By-Step Training Guide Book...

The Microsoft Excel Step-By-Step Training Guide Book Bundle - Couverture souple

Benton, C.J.

 
9781518628757: The Microsoft Excel Step-By-Step Training Guide Book Bundle
Couverture souple
ISBN 10 : 1518628753 ISBN 13 : 9781518628757
Editeur : CreateSpace Independent Publishing Platform, 2015

Synopsis

3 books in 1 a consolidation of three books in the Microsoft® Excel® Step-By-Step Training Guide Series

This book bundle offers easy to follow examples with screenshots demonstrating how to use the most common basic and intermediate Microsoft® Excel® formulas & features, including Pivot Tables, & the VLOOKUP formula. The book bundle is organized into 6 step-by-step sections, allowing you to grow your knowledge of Microsoft® Excel® at your own pace.

In addition to the following, this book bundle 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 & NETWORKDAYS
  • SUMIF

    Part 2 – Pivot Tables & Dashboards

  • Organize and summarize data
  • Format results
  • Insert Pivot Charts
  • Display averages & percentages
  • Group data into predefined ranges
  • Rank results
  • Insert calculated fields
  • How to create and update a basic Dashboard using Pivot Table data

    Part 3 – Excel® Features

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

    Part 4 – Text Functions

  • LEN & TRIM
  • CONCATENATE & MID
  • PROPER, UPPER, & LOWER

    Part 5 – Logic Formulas

  • IF
  • Nested IF

    Part 6 – The VLOOKUP Formula

  • What the VLOOKUP formula does
  • The parts of a VLOOKUP formula
  • Detailed examples on how to use the VLOOKUP formula
  • Incorporating the IFERROR functionality into your VLOOKUP formula
  • How to apply the VLOOKUP formula across multiple tabs & workbooks
  • How to troubleshoot and resolve common VLOOKUP errors, including reasons why you may be getting the #N/A or #REF error

    • Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

    Présentation de l'éditeur

    3 books in 1 a consolidation of three books in the Microsoft® Excel® Step-By-Step Training Guide Series

    This book bundle offers easy to follow examples with screenshots demonstrating how to use the most common basic and intermediate Microsoft® Excel® formulas & features, including Pivot Tables, & the VLOOKUP formula. The book bundle is organized into 6 step-by-step sections, allowing you to grow your knowledge of Microsoft® Excel® at your own pace.

    In addition to the following, this book bundle 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 & NETWORKDAYS
  • SUMIF

    Part 2 – Pivot Tables & Dashboards

  • Organize and summarize data
  • Format results
  • Insert Pivot Charts
  • Display averages & percentages
  • Group data into predefined ranges
  • Rank results
  • Insert calculated fields
  • How to create and update a basic Dashboard using Pivot Table data

    Part 3 – Excel® Features

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

    Part 4 – Text Functions

  • LEN & TRIM
  • CONCATENATE & MID
  • PROPER, UPPER, & LOWER

    Part 5 – Logic Formulas

  • IF
  • Nested IF

    Part 6 – The VLOOKUP Formula

  • What the VLOOKUP formula does
  • The parts of a VLOOKUP formula
  • Detailed examples on how to use the VLOOKUP formula
  • Incorporating the IFERROR functionality into your VLOOKUP formula
  • How to apply the VLOOKUP formula across multiple tabs & workbooks
  • How to troubleshoot and resolve common VLOOKUP errors, including reasons why you may be getting the #N/A or #REF error

    • Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

    Éditeur
    CreateSpace Independent Publishing Platform
    Date d'édition
    2015
    Langue
    anglais
    ISBN 10 
    1518628753
    ISBN 13 
    9781518628757
    Reliure
    Broché
    Nombre de pages
    246
    Coordonnées du fabricant
    Manufactured by Amazon on behalf of the author
    https://www.amazon.fr/hz/contact-us

    c/o Amazon Media EU S.à.r.l., 38 Avenue John F. Kennedy
    Luxembourg
    L-1855
    Luxembourg