The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features (The Microsoft Excel Step-By-Step Training Guide Series Book 1)
Description
Learn the 25 most common Microsoft Excel Formulas & Features quickly and easily with this detailed step-by-step guide!
****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
How to create a basic Pivot Table
Formatting Pivot Table results
Inserting Pivot Charts
Data Sorting
Formula Trace
Text-To-Columns
Conditional Formatting & Filtering
LEN & TRIM
CONCATENATE & MID
PROPER, UPPER, & LOWER
IF
Nested IF
VLOOKUP
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
Part 2 Introduction to Pivot Tables
Part 3 Excel Features
Part 4 Text Functions
Part 5 Logic & Lookup Formulas
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 !
More Books by C.J. Benton
