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 »
2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide, Paperback / softback Book

2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide Paperback / softback

Paperback / softback

Out of stock

Description

Learn Excel By Example - Updated for Office version 2019!

Ready to learn Microsoft Excel(R), but not sure where to start? This user-friendly and practical resource is tailored for beginners and will teach you how to navigate Excel and 30 of the most frequently used formulas & features. Each example includes step-by-step instructions with screenshots.

Organized into 3 step-by-step sections, allowing you to grow your knowledge of Excel at your own pace:

Exercise Files Included!

Section 1 - Basic Commands

  • Opening Excel and the Toolbar (Ribbon)
  • Customizing the Ribbon & Quick Access Toolbar
  • How to create and save a new spreadsheet
  • The segments of a worksheet
  • Printing tips
  • How to add Headers & Footers to your spreadsheets

    Section 2 - Toolbar (Ribbon) Navigation

  • Review of the various Copy, Cut, & Paste options
  • Font & number formatting, including currency examples for the British Pound GBP and Euro €
  • Inserting charts
  • Conditional formatting
  • Sorting & filtering data based on specific criteria
  • Protecting workbooks & worksheets

    Section 3 - Formulas

  • Sum (addition), Subtraction, Multiplication, & Division
  • Average, Min, & Max
  • Today, Now, & NetWorkDays
  • Text, Len, Trim, Concat, & Mid
  • The VLOOKUPwith 2 step-by-step examples
  • IF, SumIF, AverageIF, CountIF, & CountIFS
  • How to create and format a Pivot Table
  • And More!

    • Information

    • Out of stock

    • Format:Paperback / softback
    • Pages:160 pages
    • Publisher:Independently Published
    • Publication Date:
    • Category:
    • ISBN:9781674846804

    £8.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:160 pages
    • Publisher:Independently Published
    • Publication Date:
    • Category:
    • ISBN:9781674846804