Название: Excel 2016. The 30 Most Common Formulas & Features - The Step-By-Step Guide
Автор: Benton C.J.
Издательство: CreateSpace Independent Publishing Platform
Год: 2017
Страниц: 118
Формат: azw + pdf (conv) + sample files
Размер: 10 mb
Язык: английский
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. Exercise Files Included!
The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel at your own pace:
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!
|
Навигация
Вход на сайт
Реклама
Excel 2016. The 30 Most Common Formulas & Features - The Step-By-Step Guide 
