Tasuta kohaletoimetamine tellimustele üle 29 €
  • check 10+ miljonit raamatut
  • check Uued tooted iga päev
  • check Meid usaldab üle 1 miljoni kliendi
  • check Hea hind ja allahindlused
  • check Tarne üle kogu Euroopa

The Microsoft Excel Step-By-Step Training Guide Book Bundle - C. J. Benton

inglise keel
2015-10-23
19,05 € 31,75 €

-40% koodiga BOOKS

Meie tarnija laos

Saadetis 10-16 tööpäeva jooksul

30-päevane tagastamisõigus

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 you ... Täielik kirjeldus

Võib-olla meeldib sulle ka

Kirjeldus

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

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 error

Lisateave

Autor C. J. Benton
Kirjastaja CreateSpace Independent Publishing Platform
Väljalaskeaasta 2015
Kaanetüüp Pehme kaanega
EAN 9781518628757
Kirjuta oma arvustus
Te vaatate: The Microsoft Excel Step-By-Step Training Guide Book Bundle
Teie hinnang:

Goodreads'i arvustused

19,05 € 31,75 €