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

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

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Seller's business information

Rarewaves USA
10100 West Sample Road, Ste 101, Coral Springs, FL, 33065, U.S.A.

Sale & Shipping Terms

Terms of Sale

Right of cancellation

Shipping Terms

Please note that we do not offer Priority shipping to any country.

We currently do not ship to the below countries:

Canada (due to the Canada Post strike)
Afghanistan
Bhutan
Brazil
Brunei Darussalam
Channel Islands
Chile
Israel
Lao
Mexico
Russian Federation
Saudi Arabia
South Africa
Yemen

Please do not attempt to place orders with any of these countries as a ship to address - they will be cancelled.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	30 to 30 business days	14 to 14 business days
First item	� 37.58	� 50.36

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.