Search Books

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

Author C.J. Benton
📄 Viewing lite version Full site ›
🌎 Shop on Amazon — choose country
🇺🇸 USA 🇨🇦 Canada 🇬🇧 UK 🇩🇪 Germany 🇫🇷 France 🇮🇳 India
Price not listed
🛒 Buy New on Amazon 🇺🇸
Share:
Book Details
Author(s)C.J. Benton
ISBN / ASINB0172Q0ZCC
ISBN-13978B0172Q0ZC6
Sales Rank475,050
MarketplaceUnited States 🇺🇸

Description ▲

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. This 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
    •