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

Description:

keywords:microsoft office training,microsoft office 2010 training,microsoft office button excel,microsoft office training videos,hosted microsoft office,

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!

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!

keywords:microsoft office training,microsoft office 2010 training,microsoft office button excel,microsoft office training videos,hosted microsoft office,

./upload/Misc/Excel_2016_The_30_Most_Common__5_9_2017_11_58_47_AM.jpg
eBook Details:
Category: Microsoft Office
Author: C.J. Benton
Language: English
ISBN10: B0711HSHTR
ISBN13:
Pages: 63
PubDate: 2017-05-08 00:00:00
UploadDate: 5/9/2017 11:58:47 am

The Latest Upload

The Most Related

Category