Excel 2016 The 30 Most Common Formulas & Features - The

Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide

In 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!****
In addition to the following, this book also includes sections on ExcelÂ® keyboard shortcuts and how to change the currency symbol, for example to the British Pound Â£ or Euro â‚¬.
Part 1 - ExcelÂ® Formula Fundamentals
SUM, SUBTRACTION, MULTIPLICATION, & DIVISION
AVERAGE
MIN & MAX
TODAY, NOW, & NETWORKDAYS
SUMIF, AVERAGEIF, COUNTIF, & COUNTIFS

Part 2 â€“ Introduction to Pivot Tables
How to create a Pivot Table report
Formatting Pivot Table results
Adding Pivot Charts

Part 3 â€“ ExcelÂ® Features
Data Sorting
Conditional Formatting & Filtering
Data Validation
Text-To-Columns
Formula Trace

Part 4 â€“ Text Functions
LEN & TRIM
CONCATE (CONCATENATE) & MID
PROPER, UPPER, & LOWER

Part 5 â€“ Logic & Lookup Formulas
IF
AND
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 MicrosoftÂ® ExcelÂ®!
Country USA
Binding Kindle Edition
ReleaseDate 2017-05-08
Format Kindle eBook

Country	USA
Binding	Kindle Edition
ReleaseDate	2017-05-08
Format	Kindle eBook

Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide

In just a few short hours, learn the 30 most common MicrosoftÂ® ExcelÂ® Formulas & Features quickly and easily with this detailed step-by-step guide!