Cantitate/Preț
Produs

The Microsoft Excel Step-By-Step Training Guide Book Bundle

Autor C. J. Benton
en Limba Engleză Paperback
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) keyboard shortcuts and how to change the currency symbol, for example to the British Pound or Euro .

Part 1 - Excel(r) 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(r) 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

Citește tot Restrânge

Preț: 9929 lei

Preț vechi: 12411 lei
-20% Nou

Puncte Express: 149

Preț estimativ în valută:
1900 2018$ 1574£

Carte disponibilă

Livrare economică 05-19 decembrie

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781518628757
ISBN-10: 1518628753
Pagini: 246
Dimensiuni: 156 x 234 x 13 mm
Greutate: 0.35 kg
Editura: CreateSpace Independent Publishing Platform