...
click to view more

Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features

by Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features

$13.97

add to favourite
  • In Stock - Guaranteed to ship in 24 hours with Free Online tracking.
  • FREE DELIVERY by Monday, April 28, 2025
  • 24/24 Online
  • Yes High Speed
  • Yes Protection
Tell-A-Friend
Last update:

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:

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

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 Book Bundle

    • Last updated on

    Product Details

    • Aug 24, 2015 Pub Date:
    • 9781516960644 ISBN-13:
    • 1516960645 ISBN-10:
    • English Language