Skip to main content
SpringerLink
Log in
Apress
Book cover

Essential Excel 2016

A Step-by-Step Guide

  • Book
  • © 2016

Overview

Authors:
  1. David Slager

    1. Fort Wayne, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Written by an Excel expert with many years of experience teaching people of all ages how to use Excel
  • Includes extensive workbooks and reader exercises with every chapter
  • Typical Excel users only use 10% of the functionality available in this software. Readers of this book will come away making much better use of the powerful tool at their fingertips

  • 98k Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (17 chapters)

  1. Front Matter

    Pages i-xxi
    Download chapter PDF

  2. Becoming Acquainted with Excel

    • David Slager
    Pages 1-26

  3. Navigating and Working with Worksheets

    • David Slager
    Pages 27-48

  4. Best Ways to Enter and Edit Data

    • David Slager
    Pages 49-88

  5. Formatting and Aligning Data

    • David Slager
    Pages 89-143

  6. Different Ways of Viewing and Printing Your Workbook

    • David Slager
    Pages 145-172

  7. Understanding Backstage

    • David Slager
    Pages 173-218

  8. Creating and Using Formulas

    • David Slager
    Pages 219-264

  9. Excel’s Pre-existing Functions

    • David Slager
    Pages 265-302

  10. Auditing, Validating, and Protecting Your Data

    • David Slager
    Pages 303-341

  11. Using Hyperlinks, Combining Text, and Working with the Status Bar

    • David Slager
    Pages 343-371

  12. Transferring and Duplicating Data to Other Locations

    • David Slager
    Pages 373-409

  13. Working with Tables

    • David Slager
    Pages 411-444

  14. Working with Charts

    • David Slager
    Pages 445-501

  15. Importing Data

    • David Slager
    Pages 503-539

  16. Using PivotTables and PivotCharts

    • David Slager
    Pages 541-589

  17. Enhancing Workbooks with Multimedia

    • David Slager
    Pages 591-641

  18. Automating Task with Macros

    • David Slager
    Pages 643-664

  19. Back Matter

    Pages 665-673
    Download chapter PDF
Back to top

Keywords

About this book

This book shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it. Loaded with screen shots, step-by-step instructions, and reader exercises, Essential Excel 2016 makes it easy for you to get to grips with this powerful software and what it can do.


What You’ll Learn
  • How to create amazing visualizations of your data
  • Easy and accurate methods for entering data
  • How to extract just the information you want from imported data, and manipulate it and format it the way you want
  • Export your results to other programs or share with others in the cloud
  • Organize, Summarize, Filter, and Consolidate your Data in almost any way imaginable
  • Audit, Validate and Protect your Data


Who This Book Is For

Anyone new to Excel, or looking to take better advantage of the platform and find out its latest features

Authors and Affiliations

  • Fort Wayne, USA

    David Slager

About the author

David Slager has been a computer programmer for over 40 years and has taught Excel for 18 years. He has been working with spreadsheets since their introduction on the PC and has taught people of all ages from 1st graders to senior citizens. 

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation