The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features: Volume 1 (The Microsoft Excel Step-By-Step Training Guide Series) - Softcover

Benton, C.J.

 
9781516960644: The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features: Volume 1 (The Microsoft Excel Step-By-Step Training Guide Series)
Softcover
ISBN 10: 1516960645 ISBN 13: 9781516960644
Publisher: CreateSpace Independent Publishing Platform, 2015

Synopsis

Learn the 25 most common Microsoft® Excel® Formulas & Features quickly and easily with this detailed step-by-step guide!

This book offers easy to follow examples with screenshots demonstrating how to use the 25 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:

****Excel v2016 is now available, with 5 bonus formulas included****

Part 1 - Excel® Formula Fundamentals

  • SUM, SUBTRACTION, MULTIPLICATION, & DIVISION
  • AVERAGE
  • MIN & MAX
  • TODAY & NETWORKDAYS
  • SUMIF

    Part 2 – Introduction to Pivot Tables

  • How to create a basic Pivot Table
  • Formatting Pivot Table results
  • Inserting Pivot Charts

    Part 3 – Excel® Features

  • Data Sorting
  • Formula Trace
  • Text-To-Columns
  • Conditional Formatting & Filtering

    Part 4 – Text Functions

  • LEN & TRIM
  • CONCATENATE & MID
  • PROPER, UPPER, & LOWER

    Part 5 – Logic & Lookup Formulas

  • IF
  • Nested IF
  • 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 of Microsoft® Excel®!

    Book 1 in The Microsoft Excel Step-By-Step Training Guide Series

  • Book 1 - The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features
  • Book 2 - The Step-By-Step Guide To Pivot Tables & Introduction To Dashboards
  • Book 3 - The Step-By-Step Guide To The VLOOKUP formula in Microsoft Excel
  • Book 4 - The Microsoft Excel Step-By-Step Training Guide Book Bundle

    • "synopsis" may belong to another edition of this title.

    Product Description

    Learn the 25 most common Microsoft(r) Excel(r) Formulas & Features quickly and easily with this detailed step-by-step guide! This book offers easy to follow examples with screenshots demonstrating how to use the 25 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: Part 1 - Excel(r) Formula Fundamentals SUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGE MIN & MAX TODAY & NETWORKDAYS SUMIF Part 2 - Introduction to Pivot Tables How to create a basic Pivot Table Formatting Pivot Table results Inserting Pivot Charts Part 3 - Excel(r) Features Data Sorting Formula Trace Text-To-Columns Conditional Formatting & Filtering Part 4 - Text Functions LEN & TRIM CONCATENATE & MID PROPER, UPPER, & LOWER Part 5 - Logic & Lookup Formulas IF Nested IF 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 of Microsoft(r) Excel(r)! Book 1 in The Microsoft Excel Step-By-Step Training Guide Series Book 1 - The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features Book 2 - The Step-By-Step Guide To Pivot Tables & Introduction To Dashboards Book 3 - The Step-By-Step Guide To The VLOOKUP formula in Microsoft Excel Book 4 - The Microsoft Excel Step-By-Step Training Guide Boo

    "About this title" may belong to another edition of this title.

    Publisher
    CreateSpace Independent Publishing Platform
    Publication date
    2015
    Language
    English
    ISBN 10 
    1516960645
    ISBN 13 
    9781516960644
    Binding
    Paperback
    Number of pages
    130