Book description
The complete guide to Excel 2016, from Mr. Spreadsheet himselfWhether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.
Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible.
- Create functional spreadsheets that work
- Master formulas, formatting, pivot tables, and more
- Get acquainted with Excel 2016's new features and tools
- Customize downloadable templates and worksheets
Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2016 Bible has you covered with complete coverage and clear expert guidance.
Table of contents
- Introduction
-
Part I: Getting Started with Excel
- Chapter 1: Introducing Excel
- Chapter 2: Entering and Editing Worksheet Data
- Chapter 3: Essential Worksheet Operations
- Chapter 4: Working with Cells and Ranges
- Chapter 5: Introducing Tables
- Chapter 6: Worksheet Formatting
- Chapter 7: Understanding Excel Files
- Chapter 8: Using and Creating Templates
- Chapter 9: Printing Your Work
-
Part II: Working with Formulas and Functions
- Chapter 10: Introducing Formulas and Functions
- Chapter 11: Creating Formulas That Manipulate Text
- Chapter 12: Working with Dates and Times
- Chapter 13: Creating Formulas That Count and Sum
- Chapter 14: Creating Formulas That Look Up Values
- Chapter 15: Creating Formulas for Financial Applications
- Chapter 16: Miscellaneous Calculations
- Chapter 17: Introducing Array Formulas
- Chapter 18: Performing Magic with Array Formulas
-
Part III: Creating Charts and Graphics
- Chapter 19: Getting Started Making Charts
-
Chapter 20: Learning Advanced Charting
- Selecting Chart Elements
- User Interface Choices for Modifying Chart Elements
- Modifying the Chart Area
- Modifying the Plot Area
- Working with Titles in a Chart
- Working with a Legend
- Working with Gridlines
- Modifying the Axes
- Working with Data Series
- Creating Chart Templates
- Learning Some Chart-Making Tricks
- Chapter 21: Visualizing Data Using Conditional Formatting
- Chapter 22: Creating Sparkline Graphics
- Chapter 23: Enhancing Your Work with Pictures and Drawings
-
Part IV: Using Advanced Excel Features
- Chapter 24: Customizing the Excel User Interface
- Chapter 25: Using Custom Number Formats
- Chapter 26: Using Data Validation
- Chapter 27: Creating and Using Worksheet Outlines
- Chapter 28: Linking and Consolidating Worksheets
- Chapter 29: Excel and the Internet
- Chapter 30: Protecting Your Work
- Chapter 31: Making Your Worksheets Error Free
-
Part V: Analyzing Data with Excel
- Chapter 32: Importing and Cleaning Data
- Chapter 33: Introducing Pivot Tables
-
Chapter 34: Analyzing Data with Pivot Tables
- Working with Nonnumeric Data
- Grouping Pivot Table Items
- Creating a Frequency Distribution
- Creating a Calculated Field or Calculated Item
- Filtering Pivot Tables with Slicers
- Filtering Pivot Tables with a Timeline
- Referencing Cells Within a Pivot Table
- Creating Pivot Charts
- Another Pivot Table Example
- Using the Data Model
- Learning More About Pivot Tables
- Chapter 35: Performing Spreadsheet What-If Analysis
- Chapter 36: Analyzing Data Using Goal Seeking and Solver
- Chapter 37: Analyzing Data with the Analysis ToolPak
-
Chapter 38: Working with Get & Transform
- Get & Transform: An Overview
- Data Source for Get & Transform
- Example: A Simple Query
- How Your Actions Are Recorded
- Example: Returning Summarized Data
- Example: Transforming Data from a Web Query
- Example: Merging Two Web Queries
- Example: Getting a List of Files
- Example: Choosing a Random Sample
- Example: Unpivoting a Table
- Tips for Using Get & Transform
- Learning More
- Part VI: Programming Excel with VBA
- Part VII: Appendixes
Product information
- Title: Excel 2016 Bible
- Author(s):
- Release date: October 2015
- Publisher(s): Wiley
- ISBN: 9781119067511
You might also like
book
Excel 2016 Formulas
Leverage the full power of Excel formulas Excel 2016 Formulas is fully updated to cover all …
book
Microsoft Excel 365 Bible
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365 Excel …
book
Excel 2019 Bible
The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, …
book
Excel Formulas & Functions For Dummies, 6th Edition
Unlock the power of Excel with a step-by-step roadmap to its formulas and functions There's a …