Surprise Castle
/Books
The Microsoft Excel Step-By-Step Training Guide Book Bundle

The Microsoft Excel Step-By-Step Training Guide Book Bundle - Paperback

by C. J. Benton
$15.99
$17.99
-11%
Quantity
01

Pay over time for orders over $35.00 with

Availability:In StockContributor:C. J. BentonSeries:The Microsoft Excel Step-By-Step Training Guide #4Publish date:2015-10-23Pages:246
Language:EnglishPublisher:Createspace Independent Publishing PlatformISBN-13:9781518628757ISBN-10:1518628753UPC:9781518628757Book Category:ComputersBook Subcategory:Business & Productivity SoftwareBook Topic:SpreadsheetsSize:9.21 x 6.14 x 0.52 inchesWeight:0.7716Product ID:SC3E6D3VDD
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
    • Language:EnglishPublisher:Createspace Independent Publishing PlatformISBN-13:9781518628757ISBN-10:1518628753UPC:9781518628757Book Category:ComputersBook Subcategory:Business & Productivity SoftwareBook Topic:SpreadsheetsSize:9.21 x 6.14 x 0.52 inchesWeight:0.7716Product ID:SC3E6D3VDD
    Publisher: Createspace Independent Publishing Platform

    Contributor(s)

    C. J. Benton

    Author

    C. J. Benton

    Free shipping on orders over $75. Standard shipping takes 3-7 business days. Returns accepted within 30 days of purchase.

    Recently Viewed

    View All