Book description
Your one-stop guide to all things Excel 2016Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic—and beyond. In no time, your Excel skills will go from 'meh' to excellent.
Written by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros—and everything in between—this hands-on, friendly guide makes working with Excel easier than ever before.
- Serves as the ideal reference for solving common questions and Excel pain points quickly and easily
- Helps to increase productivity and efficiency when working in Excel
- Fully updated for the new version of Excel
- Covers basic and more advanced Excel topics
If working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you'll turn to again and again.
Table of contents
-
- Cover
- Introduction
- Book I: Excel Basics
-
Book II: Worksheet Design
- Chapter 1: Building Worksheets
-
Chapter 2: Formatting Worksheets
- Making Cell Selections
- Adjusting Columns and Rows
- Formatting Tables from the Ribbon
- Formatting Tables with the Quick Analysis Tool
- Formatting Cells from the Ribbon
- Formatting Cell Ranges with the Mini-Toolbar
- Using the Format Cells Dialog Box
- Hiring Out the Format Painter
- Using Cell Styles
- Conditional Formatting
- Chapter 3: Editing and Proofing Worksheets
- Chapter 4: Managing Worksheets
- Chapter 5: Printing Worksheets
- Book III: Formulas and Functions
- Book IV: Worksheet Collaboration and Review
- Book V: Charts and Graphics
- Book VI: Data Management
- Book VII: Data Analysis
- Book VIII: Macros and VBA
- About the Author
- Cheat Sheet
- Connect with Dummies
- End User License Agreement
Product information
- Title: Excel 2016 All-in-One For Dummies
- Author(s):
- Release date: November 2015
- Publisher(s): For Dummies
- ISBN: 9781119077152
You might also like
book
Excel 2013 For Dummies
The bestselling Excel book - completely updated for Excel 2013! As the world's leading spreadsheet application, …
book
Excel 2016 For Dummies
Let your Excel skills sore to new heights with this bestselling guide Updated to reflect the …
book
Microsoft Excel 2010 In Depth
Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their …
book
Excel 2016 In Depth
This is the Rough Cut version of the printed book. Does your life play out in …