Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Title Page
Table of Contents
Introduction
About This Book
Foolish Assumptions
How This Book Is Organized
Conventions Used in This Book
Icons Used in This Book
Where to Go from Here
Book I: Excel Basics
Chapter 1: The Excel 2016 User Experience
Excel 2016’s Sleek Look and Feel
Excel’s Start Screen
Excel’s Ribbon User Interface
Getting Help
Launching and Quitting Excel
Chapter 2: Customizing Excel 2016
Tailoring the Quick Access Toolbar to Your Tastes
Exercising Your Options
Using Office Add-ins
Using Excel’s Own Add-Ins
Book II: Worksheet Design
Chapter 1: Building Worksheets
Designer Spreadsheets
It Takes All Kinds (Of Cell Entries)
Data Entry 101
Saving the Data
Document Recovery to the Rescue
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
Opening a Workbook
Cell Editing 101
A Spreadsheet with a View
Copying and Moving Stuff Around
Find and Replace This Disgrace!
Spell Checking Heaven
Looking Up and Translating Stuff
Marking Invalid Data
Eliminating Errors with Text to Speech
Chapter 4: Managing Worksheets
Reorganizing the Worksheet
Reorganizing the Workbook
Working with Multiple Workbooks
Consolidating Worksheets
Chapter 5: Printing Worksheets
Printing from the Excel 2016 Backstage View
Quick Printing the Worksheet
Working with the Page Setup Options
Headers and Footers
Solving Page Break Problems
Printing the Formulas in a Report
Book III: Formulas and Functions
Chapter 1: Building Basic Formulas
Formulas 101
Copying Formulas
Adding Array Formulas
Range Names in Formulas
Adding Linking Formulas
Controlling Formula Recalculation
Circular References
Chapter 2: Logical Functions and Error Trapping
Understanding Error Values
Using Logical Functions
Error-Trapping Formulas
Whiting-Out Errors with Conditional Formatting
Formula Auditing
Removing Errors from the Printout
Chapter 3: Date and Time Formulas
Understanding Dates and Times
Using Date Functions
Using Time Functions
Chapter 4: Financial Formulas
Financial Functions 101
The PV, NPV, and FV Functions
The PMT Function
Depreciation Functions
Analysis ToolPak Financial Functions
Chapter 5: Math and Statistical Formulas
Math & Trig Functions
Statistical Functions
Chapter 6: Lookup, Information, and Text Formulas
Lookup and Reference
Information, Please …
Much Ado about Text
Book IV: Worksheet Collaboration and Review
Chapter 1: Protecting Workbooks and Worksheet Data
Password-Protecting the File
Protecting the Worksheet
Chapter 2: Using Hyperlinks
Hyperlinks 101
Using the HYPERLINK Function
Chapter 3: Sending Workbooks Out for Review
Preparing a Workbook for Distribution
Workbook Sharing 101
Workbooks on Review
Chapter 4: Sharing Workbooks and Worksheet Data
Sharing Your Workbooks Online
Excel 2016 Data Sharing Basics
Exporting Workbooks to Other Usable File Formats
Book V: Charts and Graphics
Chapter 1: Charting Worksheet Data
Worksheet Charting 101
Adding Sparkline Graphics to a Worksheet
Printing Charts
Chapter 2: Adding Graphic Objects
Graphic Objects 101
Inserting Different Types of Graphics
Drawing Graphics
Adding Screenshots of the Windows Desktop
Using Themes
Book VI: Data Management
Chapter 1: Building and Maintaining Data Lists
Data List Basics
Sorting Data
Subtotaling Data
Chapter 2: Filtering and Querying a Data List
Data List Filtering 101
Filtering Data
Using the Database Functions
External Data Query
Book VII: Data Analysis
Chapter 1: Performing What-If Scenarios
Using Data Tables
Exploring Different Scenarios
Hide and Goal Seeking
Using the Solver
Chapter 2: Performing Large-Scale Data Analysis
Creating Pivot Tables
Formatting a Pivot Table
Sorting and Filtering the Pivot Table Data
Modifying the Pivot Table
Creating Pivot Charts
Using the Power Pivot and Power View Add-Ins
Using the Power Map feature
Creating Forecast Worksheets
Book VIII: Macros and VBA
Chapter 1: Recording and Running Macros
Macro Basics
Assigning Macros to the Ribbon and the Quick Access Toolbar
Macro Security
Chapter 2: VBA Programming
Using the Visual Basic Editor
Creating Custom Excel Functions
About the Author
Cheat Sheet
Connect with Dummies
End User License Agreement
← Prev
Back
Next →
← Prev
Back
Next →