Items related to The Microsoft Excel Step-By-Step Training Guide Book...

The Microsoft Excel Step-By-Step Training Guide Book Bundle: Volume 4 (The Microsoft Excel Step-By-Step Training Guide Series) - Softcover

 
9781518628757: The Microsoft Excel Step-By-Step Training Guide Book Bundle: Volume 4 (The Microsoft Excel Step-By-Step Training Guide Series)

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
  • "synopsis" may belong to another edition of this title.

    Buy Used

    Condition: As New
    Unread book in perfect condition...
    View this item

    FREE shipping within United Kingdom

    Destination, rates & speeds

    Search results for The Microsoft Excel Step-By-Step Training Guide Book...

    Seller Image

    Benton, C. J.
    ISBN 10: 1518628753 ISBN 13: 9781518628757
    New Softcover

    Seller: GreatBookPricesUK, Woodford Green, United Kingdom

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: New. Seller Inventory # 24974995-n

    Contact seller

    Buy New

    £ 19.74
    Convert currency
    Shipping: FREE
    Within United Kingdom
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Stock Image

    C J Benton
    ISBN 10: 1518628753 ISBN 13: 9781518628757
    New Paperback
    Print on Demand

    Seller: THE SAINT BOOKSTORE, Southport, United Kingdom

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Paperback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 349. Seller Inventory # C9781518628757

    Contact seller

    Buy New

    £ 19.75
    Convert currency
    Shipping: FREE
    Within United Kingdom
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Seller Image

    Benton, C. J.
    ISBN 10: 1518628753 ISBN 13: 9781518628757
    Used Softcover

    Seller: GreatBookPricesUK, Woodford Green, United Kingdom

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: As New. Unread book in perfect condition. Seller Inventory # 24974995

    Contact seller

    Buy Used

    £ 20.12
    Convert currency
    Shipping: FREE
    Within United Kingdom
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Seller Image

    C J Benton
    ISBN 10: 1518628753 ISBN 13: 9781518628757
    New Paperback

    Seller: Rarewaves USA United, OSWEGO, IL, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Paperback. Condition: New. Seller Inventory # LU-9781518628757

    Contact seller

    Buy New

    £ 20.40
    Convert currency
    Shipping: FREE
    From U.S.A. to United Kingdom
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Seller Image

    C J Benton
    ISBN 10: 1518628753 ISBN 13: 9781518628757
    New Paperback

    Seller: Rarewaves.com UK, London, United Kingdom

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Paperback. Condition: New. Seller Inventory # LU-9781518628757

    Contact seller

    Buy New

    £ 21.08
    Convert currency
    Shipping: FREE
    Within United Kingdom
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Stock Image

    C.J. Benton
    ISBN 10: 1518628753 ISBN 13: 9781518628757
    New Paperback

    Seller: CitiRetail, Stevenage, United Kingdom

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Paperback. Condition: new. Paperback. 3 books in 1 a consolidation of three books in the Microsoft(R) Excel(R) 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(R) Excel(R) 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(R) Excel(R) at your own pace. In addition to the following, this book bundle 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 & 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(R) 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 Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability. Seller Inventory # 9781518628757

    Contact seller

    Buy New

    £ 22.99
    Convert currency
    Shipping: FREE
    Within United Kingdom
    Destination, rates & speeds

    Quantity: 1 available

    Add to basket

    Stock Image

    Benton, C.J.
    ISBN 10: 1518628753 ISBN 13: 9781518628757
    New Softcover
    Print on Demand

    Seller: California Books, Miami, FL, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: New. Print on Demand. Seller Inventory # I-9781518628757

    Contact seller

    Buy New

    £ 16.87
    Convert currency
    Shipping: £ 7.44
    From U.S.A. to United Kingdom
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Seller Image

    Benton, C. J.
    ISBN 10: 1518628753 ISBN 13: 9781518628757
    New Softcover

    Seller: GreatBookPrices, Columbia, MD, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: New. Seller Inventory # 24974995-n

    Contact seller

    Buy New

    £ 14.84
    Convert currency
    Shipping: £ 14.88
    From U.S.A. to United Kingdom
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Seller Image

    Benton, C. J.
    ISBN 10: 1518628753 ISBN 13: 9781518628757
    Used Softcover

    Seller: GreatBookPrices, Columbia, MD, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: As New. Unread book in perfect condition. Seller Inventory # 24974995

    Contact seller

    Buy Used

    £ 15.40
    Convert currency
    Shipping: £ 14.88
    From U.S.A. to United Kingdom
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Seller Image

    Benton, C.J.
    ISBN 10: 1518628753 ISBN 13: 9781518628757
    Used Softcover

    Seller: Goodwill of Greater Milwaukee and Chicago, Racine, WI, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: good. Book is considered to be in good or better condition. The actual cover image may not match the stock photo. Hard cover books may show signs of wear on the spine, cover or dust jacket. Paperback book may show signs of wear on spine or cover as well as having a slight bend, curve or creasing to it. Book should have minimal to no writing inside and no highlighting. Pages should be free of tears or creasing. Stickers should not be present on cover or elsewhere, and any CD or DVD expected with the book is included. Book is not a former library copy. Seller Inventory # SEWV.1518628753.G

    Contact seller

    Buy Used

    £ 5.23
    Convert currency
    Shipping: £ 26.06
    From U.S.A. to United Kingdom
    Destination, rates & speeds

    Quantity: 1 available

    Add to basket

    There are 5 more copies of this book

    View all search results for this book