Learn VLOOKUP formulas quickly and easily with this step-by-step guide

This comprehensive book offers easy to follow examples with screenshots demonstrating how to use the VLOOKUP formula. The book is organized into 3 step-by-step sections, allowing you to grow your knowledge of the VLOOKUP formula at your own pace:

VLOOKUP Basics: What the VLOOKUP formula does The parts of a VLOOKUP formula Detailed examples on how to use the VLOOKUP formula

Taking the VLOOKUP Formula to the Next Level: Incorporating the IFERROR functionality into your VLOOKUP formula How to apply the...

An Excel(r) Macros and VBA book developed for business users

Readers will be able to refer back to this book time and time again. Written with little technical jargon and divided into five easy to follow segments. Business users of all types will learn how to automate tasks, improve productivity, and reduce the occurrence of errors in standardized processes.

The book begins by providing a foundation on how Macros & VBA (Visual Basic for Applications) work, followed by step-by-step examples on recording and troubleshooting macros. Continuing with how to...

Learn how to create Pivot Tables quickly and easily with this step-by-step guide

This book contains several basic, intermediate, and advanced Pivot Table examples with screenshots demonstrating how to: Organize and summarize data Format results Insert Pivot Charts Display averages & percentages Group data into predefined ranges Rank results Insert calculated fields

In addition to the above, you will also learn how to create and update a basic Dashboard using Pivot Table data.

A great resource for: Business Analysts Data Analysts Financial Analysts Administrative and Support staff...

Learn the 25 most common Microsoft(R) Excel(R) Formulas & Features quickly and easily with this detailed step-by-step guide

This book offers easy to follow examples with screenshots demonstrating how to use the 25 most common basic and intermediate Microsoft(R) Excel(R) formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel(R) at your own pace:

****Excel v2016 is now available, with 5 bonus formulas included****

Part 1 - Excel(R) Formula Fundamentals

SUM,...

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)...

Ready to learn more about Microsoft(r) Excel(r), but not sure where to start?

This book is tailored for beginners and will guide you through the basic functionality of Microsoft(r) Excel(r). Providing a review of the most commonly used toolbar commands. How to create a new spreadsheet, including formatting, saving, and printing. In addition to this, you'll learn the fundamental Excel(r) formulas and keyboard shortcuts.

Opening Excel(r) and the Toolbar (Ribbon) How to create and save a new spreadsheet Customizing the Toolbar (Ribbon) & Quick Access Toolbar

Navigation and Printing...

Learn how to create Pivot Tables quickly and easily with this step-by-step guide

Updated for Microsoft(r) Excel(r) 2016 This book provides easy to follow step-by-step examples with screenshots demonstrating how to create Pivot Tables and basic Dashboards. In just a few short hours, you'll learn how to:

Organize and summarize data

Format & filter Pivot Table results

Create Pivot Charts

Display averages & percentages

Group data into predefined ranges

Use Slicers

Rank results

Apply calculated fields

Create Pivot Table...

In just a few short hours, learn the 30 most common Microsoft(R) Excel(R) Formulas & Features quickly and easily with this detailed step-by-step guide

Updated for Excel(R) 2016 this book offers easy to follow examples with screenshots demonstrating how to use the 30 most common basic and intermediate Microsoft(R) Excel(R) formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel(R) at your own pace:

Exercise Files Included

In addition to the following, this book also...