Skip to product information
1 of 1

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

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(R) Excel(R) Formulas & Features quickly and easily with this detailed step-by-step guide! Updated for Excel(R) 2016 this book...

Regular price $10.99
Sale price $10.99 Regular price $15.99
Sale Sold out

272 In stock

Sub total

$10.99

Estimated deliver 5-7 days

People are viewing this right now

View full details
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)!

  • Let us know abour your query!
    Recently Viewed