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

Benton, C.J.

ISBN 10: 1518628753 / ISBN 13: 9781518628757

Published by CreateSpace Independent Publishi, 2015

About this Item

Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority!

Seller Inventory # S_384399041

Bibliographic Details

• Title: The Microsoft Excel Step-By-Step Training Guide Book Bundle (The Microsoft Excel Step-By-Step Training Guide Series)
• Publisher: CreateSpace Independent Publishi
• Publication Date: 2015
• Language: English
• ISBN 10: 1518628753
• ISBN 13: 9781518628757
• Binding: paperback
• Condition: Very Good

About this title

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