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

Benton, C.J.

ISBN 10: 1546500243 / ISBN 13: 9781546500247

Editore: CreateSpace Independent Publishing Platform, 2017

Riguardo questo articolo

Codice articolo U9781546500247

Dati bibliografici

Titolo: Excel 2016 The 30 Most Common Formulas & ...

Casa editrice: CreateSpace Independent Publishing Platform

Data di pubblicazione: 2017

Legatura: Brossura

Condizione: Very Good

Condizione sovraccoperta: 46180715

autografato: 12/20/2024 1:25:10 PM

Edizione: 1734701110.

Descrizione articolo

Riassunto:

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®!