Search Books

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

Author C.J. Benton
📄 Viewing lite version Full site ›
🌎 Shop on Amazon — choose country
🇺🇸 USA 🇨🇦 Canada 🇬🇧 UK 🇩🇪 Germany 🇫🇷 France 🇮🇳 India
Price not listed
🛒 Buy New on Amazon 🇺🇸
Share:
Book Details
Author(s)C.J. Benton
ISBN / ASINB0149F99GW
ISBN-13978B0149F99G2
Sales Rank749,944
MarketplaceUnited States 🇺🇸

Description ▲

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 !

    •