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

by C J Benton

Overview

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

Product Details

ISBN-13:	9781516960644
Publisher:	CreateSpace Publishing
Publication date:	08/24/2015
Series:	The Microsoft Excel Step-By-Step Training Guide , #1
Pages:	130
Product dimensions:	6.14(w) x 9.21(h) x 0.28(d)