Benton C.J. Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide

CreateSpace Independent Publishing Platform, 2017. — 118 p. — ISBN: 978-1546500247.+Sample FilesIn just a few short hours, learn the 30 most common Microsoft Excel Formulas & Features quickly and easily with this detailed step-by-step guide!
Updated for Excel 2016 this book offers easy to follow examples with screenshots demonstrating how to use the 30 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:Exercise Files Included!Excel Formula Fundamentals
Sum, Subtraction, Multiplication, & Division
Average
min & Max
Today, Now, & Networkdays
Sumif, Averageif, countif, & Countifs
Introduction to Pivot Tables
How to create a Pivot Table report
Formatting Pivot Table results
Adding Pivot Charts
Excel Features
Data Sorting
Conditional Formatting & Filtering
Data Validation
Text-To-Columns
Formula Trace
Text Functions
Len & Trim
Concate (concatenate) & Mid
Proper, upper, & Lower
Logic & Lookup Formulas
If
and
vlookupImagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using Microsoft Excel!