Books > Computers & Technology > Programming > Microsoft Programming
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

Product ID: B0711HSHTR Condition: New
No Stock / Cannot Import

Product Description

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

    • Technical Specifications

    Country
    USA
    Binding
    Kindle Edition
    ReleaseDate
    2017-05-08T00:36:12.000Z
    Format
    Kindle eBook

    You might also like

    Excel Pivot Tables & Introduction To Dashboards The Step-By-Step Guide

    The Step-By-Step Guide To The VLOOKUP formula in Microsoft Excel (The Microsoft Excel Step-By-Step Training Guide Series Book 3)

    Mastering Excel: Pivot Tables

    Excel Conditional Formatting: Tips You Can Use Immediately To Make Your Data Stand Out (Data Analysis With Excel Book 3)

    Excel 2016 Bible

    Mastering Excel: Building Dashboards

    Mastering Excel Formula Tips and Tricks

    50 Useful Excel Functions (Excel Essentials Book 3)

    "150 MOST POWERFUL EXCEL SHORTCUTS: SECRETS of SAVING TIME WITH EXCEL!" (Save Your Time With MS Excel! Book 7)