Ebook: Microsoft Excel 2016 Bible

Wiley, 2015. — 1152 p. — ISBN: 1119067510.Whether 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.
ContentAcknowledgments
IntroductionGetting Started with Excel
Introducing Excel
Entering and Editing Worksheet Data
Essential Worksheet Operations
Working with Cells and Ranges
Introducing Tables
Worksheet Formatting
Understanding Excel Files
Using and Creating Templates
Printing Your WorkWorking with Formulas and Functions
Introducing Formulas and Functions
Creating Formulas That Manipulate Text
Working with Dates and Times
Creating Formulas That Count and Sum
Creating Formulas That Look Up Value
Creating Formulas for Financial Applications
Miscellaneous Calculations
Introducing Array Formulas
Performing Magic with Array FormulasCreating Charts and Graphics
Getting Started Making Charts
Learning Advanced Charting
Visualizing Data Using Conditional Formatting
Creating Sparkline Graphics
Enhancing Your Work with Pictures and DrawingsUsing Advanced Excel Features
Customizing the Excel User Interface
Using Custom Number Formats
Using Data Validation
Creating and Using Worksheet Outlines
Linking and Consolidating Worksheets
Excel and the Internet
Protecting Your Work
Making Your Worksheets Error FreeAnalyzing Data with Excel
Importing and Cleaning Data
Introducing Pivot Tables
Analyzing Data with Pivot Tables
Performing Spreadsheet What-If Analysis
Analyzing Data Using Goal Seeking and Solver
Analyzing Data with the Analysis ToolPak
Working with Get & TransformProgramming Excel with VBAIntroducing Visual Basic for Applications
Creating Custom Worksheet Functions
Creating UserForms
Using UserForm Controls in a Worksheet
Working with Excel Events
VBA Examples
Creating Custom Excel Add-InsAppendixes
Worksheet Function Reference
Excel Shortcut KeysIndex