Sale!
worldcaribbeanbooks1197276

Excel 2016 The 30 Most Common Formulas Features – The Step-By-Step Guide-Quality Guarantee

Original price was: $10.99.Current price is: $3.29.

SKU: 8658888687668 Category:

Description

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

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

    • Reviews

    There are no reviews yet.

    Be the first to review “Excel 2016 The 30 Most Common Formulas Features – The Step-By-Step Guide-Quality Guarantee”

    Your email address will not be published. Required fields are marked *

    Related products