The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features (The Microsoft Excel Step-By-Step Training Guide)

Benton, C.J.

ISBN 10: 1516960645 / ISBN 13: 9781516960644

Editore: CreateSpace Independent Publishing Platform, 2015

In. Codice articolo ria9781516960644_new

Riassunto:

Learn the 25 most common Microsoft® Excel® Formulas & Features quickly and easily with this detailed step-by-step guide!

This book offers easy to follow examples with screenshots demonstrating how to use the 25 most common basic and intermediate Microsoft® Excel® formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel® at your own pace:

****Excel v2016 is now available, with 5 bonus formulas included****

Part 1 - Excel® Formula Fundamentals

SUM, SUBTRACTION, MULTIPLICATION, & DIVISION

AVERAGE

MIN & MAX

TODAY & NETWORKDAYS

SUMIF

Part 2 – Introduction to Pivot Tables

How to create a basic Pivot Table

Formatting Pivot Table results

Inserting Pivot Charts

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 & Lookup Formulas

IF

Nested IF

VLOOKUP

Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using of Microsoft® Excel®!

Book 1 in The Microsoft Excel Step-By-Step Training Guide Series

Book 1 - The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features

Book 2 - The Step-By-Step Guide To Pivot Tables & Introduction To Dashboards

Book 3 - The Step-By-Step Guide To The VLOOKUP formula in Microsoft Excel

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

Dati bibliografici

Titolo: The Step-By-Step Guide To The 25 Most Common...
Casa editrice: CreateSpace Independent Publishing Platform
Data di pubblicazione: 2015
Legatura: Brossura
Condizione: New