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

Benton, C.J.

Softcover

ISBN 10: 1518628753 ISBN 13: 9781518628757

Publisher: CreateSpace Independent Publishing Platform, 2015

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

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2015
• Language: English
• ISBN 10: 1518628753
• ISBN 13: 9781518628757
• Binding: Paperback
• Number of pages: 246