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

ISBN-13: 9781516960644 / Angielski / Miękka / 2015 / 130 str.

C. J. Benton; s. J. Benton

Opis

Learn the 25 most common Microsoft(R) Excel(R) 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(R) Excel(R) formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel(R) at your own pace: ****Excel v2016 is now available, with 5 bonus formulas included**** Part 1 - Excel(R) 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(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 & 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(R) Excel(R) 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