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

SuperBookDeals.com is your top source for finding new books at the absolute lowest prices, guaranteed ! We offer big discounts - everyday - on millions of titles in virtually any category, from Architecture to Zoology -- and everything in between. Discover great deals and super-savings, on professional books, text book titles, the newest computer guides, or your favorite fiction authors. You'll find it all - at HUGE SAVINGS - at SuperBookDeals. Browse through our complete online product catalog today. Serving customers around the world for years, we help thousands find just the books they're looking for -- at incredibly low, bargain prices.

Visit Seller's Storefront

Seller's business information

Expert Trading Limited
9220 Rumsey Road, Suite 101, Columbia, MD, 21045, U.S.A.

Sale & Shipping Terms

Terms of Sale

Company Name: GreatBookPrices
Legal Entity: Expert Trading, LLC
Address: 6310 Stevens Forest, suite 200, Columbia MD 21046
Email address: CustomerService@SuperBookDeals.com
Phone number: 410-964-0026
consumer complaints can be addressed to address above
Registration #: 52-1713923
Authorized representative: Danielle Hainsey

Right of cancellation

Shipping Terms

Our warehouses across the globe are fully operational without substantial delays. We are working hard and continue to overcome the daily challenges presented by COVID-19. We appreciate your understanding.

Internal processing of your order will take about 1-2 business days. Please allow an additional 4-14 business days for Media Mail delivery. We have multiple ship-from locations - MD,IL,NJ,UK,IN,NV,TN & GA

Shipping rates from U.S.A. to United Kingdom

Shipping rates from U.S.A. to United Kingdom
Order quantity	21 to 36 business days	21 to 36 business days
First item	� 14.82	� 14.82

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.