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

ISBN-13: 9781546500247 / Angielski / Miękka / 2017 / 118 str.

C. J. Benton

Opis

In just a few short hours, learn the 30 most common Microsoft(R) Excel(R) Formulas & Features quickly and easily with this detailed step-by-step guide Updated for Excel(R) 2016 this book offers easy to follow examples with screenshots demonstrating how to use the 30 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: Exercise Files Included In addition to the following, this book also includes sections on Excel(R) keyboard shortcuts and how to change the currency symbol, for example to the British Pound or Euro . Part 1 - Excel(R) 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(R) 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(R) Excel(R)