The Microsoft Excel Step-By-Step Training Guide Book Bundle by C J Benton

  •
1 1

The Microsoft Excel Step-By-Step Training Guide Book Bundle by C J Benton

Checking stock...
Checking stock...

Part of The Microsoft Excel Step-By-Step Training Guide series

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!

The Microsoft Excel Step-By-Step Training Guide Book Bundle by C J Benton

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>VLOKUP 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, UPER, & LOWER>

    Part 5 - Logic Formulas

  • IF>
  • Nested IF>

    Part 6 - The VLOKUP Formula

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

    • You might also like

    SKU Unavailable
    ISBN 13 9781518628757
    ISBN 10 1518628753
    Title The Microsoft Excel Step-By-Step Training Guide Book Bundle
    Author C J Benton
    Series The Microsoft Excel Step-By-Step Training Guide
    Condition Unavailable
    Binding Type Paperback
    Publisher Createspace Independent Publishing Platform
    Year published 2015-10-23
    Number of pages 246
    Cover note Book picture is for illustrative purposes only, actual binding, cover or edition may vary.

    Customers who bought this item also bought