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

World of Books

At World of Books, you’ll find millions of preloved reads at great prices, from bestsellers to hidden gems. Every book you buy saves money and helps reduce waste, so you can read more for less while giving stories a second life.

The feel-good place to buy books
  • Free US shipping over $15
  • Buying preloved emits 41% less CO2 than new
  • Millions of affordable books
  • 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

    More books in the The Microsoft Excel Step-By-Step Training Guide series
    View all
    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.
    Note Unavailable

    Customers who bought this item also bought