Excel 2016 All-in-One For Dummies
By Greg Harvey
Publisher: Wiley / For Dummies
Final Release Date: October 2015
Pages: 816


  • Excel Basics
  • Worksheet Design
  • Formulas and Functions
  • Worksheet Collaboration and Review
  • Charts and Graphics
  • Data Management
  • Data Analysis
  • Macros and VBA

Get up to speed right away with the all-new, all-powerful Excel 2016

Excel, the #1 spreadsheet tool used by millions, has undergone a massive makeover. Each of the self-contained minibooks in this easy-to-follow guide covers one important area of Excel 2016. Find out how to make the most of your worksheets, create eye-popping charts, analyze data like a pro, and even customize Excel with VBA programming!

  • Start here — if you're new to Excel, Book I covers all the essentials
  • Worksheet 101 — learn to enter data and build, format, print, and manage worksheets in Book II
  • Getting functional — Book III shows you how to build formulas to calculate just about anything
  • Let's team up — see how to share spreadsheets safely with other people and programs in Book IV
  • Charts and graphs — in Book V, find out how to choose and create the ideal visual representation for your data
  • What to do with it — discover in Book VI how to maintain, filter, query, and manage volumes of data
  • Analyze everything — Book VII shows you amazing ways to analyze data and summarize it with pivot tables
  • Macro mania — learn to automate common tasks with macros and create custom user-defined functions in Book VIII

Open the book and find:

  • Tips for using Excel on a touchscreen device
  • How to customize the Ribbon and the Quick Access toolbar
  • Advice on editing spreadsheets
  • Ways to find and eliminate formula errors
  • Secrets of sharing on OneDrive ®
  • Steps for querying your data
  • All about Office and Excel Add-ins
Product Details
Recommended for You
Customer Reviews
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook:  $39.99
Formats:  ePub, Mobi, PDF