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

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Descrizione libreria

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.

Visita la pagina della libreria

Informazioni sull?azienda del venditore

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

Condizioni di vendita:

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

Condizioni di spedizione:

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

Metodi di pagamento
accettati dalla libreria

Aggiungi ai desiderata

Articoli correlati a Microsoft Excel Step-by-step Training Guide Book Bundle

Microsoft Excel Step-by-step Training Guide Book Bundle

Benton, C. J.

Nuovi - Brossura

Informazioni sull?azienda del venditore