Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features, Paperback / softback Book

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

Part of the The Microsoft Excel Step-By-Step Training Guide series

Paperback / softback

Out of stock

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

    • Information

    • Out of stock

    • Format:Paperback / softback
    • Pages:130 pages
    • Publisher:Createspace Independent Publishing Platform
    • Publication Date:
    • Category:
    • ISBN:9781516960644

    £6.99

    Out of stock
    Add to Basket
    Sign in to add to wishlist
     
    Free Home Delivery

    on all orders

     
    Pick up orders

    from local bookshops

    Information

    • Out of stock

    • Format:Paperback / softback
    • Pages:130 pages
    • Publisher:Createspace Independent Publishing Platform
    • Publication Date:
    • Category:
    • ISBN:9781516960644