The Missing Credits
Introduction
Part 1: Worksheet Basics
1. Creating Your First Spreadsheet
-Creating a Basic Worksheet
-Moving Around the Grid
-A Tour of the Excel Window
-Saving Files
-Opening Files
2. Adding Information to Worksheets
-Adding Different Types of Data
-Handy Timesavers
-Dealing with Change: Undo, Redo, and AutoRecover
-Spell Check
-Adding Hyperlinks
3. Moving Data
-Selecting Cells
-Making Continuous Range Selections
-Making Noncontiguous Selections
-Automatically Selecting Your Data
-Making Selections with the Keyboard
-Moving Cells Around
-A Simple Cut-and-Paste or Copy-and-Paste
-A Quicker Cut-and-Paste or Copy-and-Paste
-Fancy Pasting Tricks
-Paste Special
-Copying Multiple Items with the Clipboard
-Adding and Moving Columns or Rows
-Inserting Columns and Rows
-Inserting Rows
-Inserting Copied or Cut Cells
-Deleting Columns and Rows
4. Managing Worksheets
-Worksheets and Workbooks
-Find and Replace
5. Formatting Cells
-Formatting Cell Values
-Formatting Cell Appearance
6. Smart Formatting Tricks
-The Format Painter
-Styles and Themes
-Conditional Formatting
7. Viewing and Printing Worksheets
-Controlling Your View
-Printing
-Controlling Pagination
Part 2: Formulas and Functions
8. Building Basic Formulas
-Creating a Basic Formula
-Functions
-Formula Errors
-Logical Operators
-Formula Shortcuts
-Copying Formulas
9. Math and Statistical Functions
-Rounding Numbers
-Groups of Numbers
-General Math Functions
-Trigonometry and Advanced Math
-Advanced Statistics
10. Financial Functions
-The World of Finance
-Financial Functions
-Depreciation
-Other Financial Functions
11. Manipulating Dates, Times, and Text
-Manipulating Text
-Manipulating Dates and Times
-Math with Dates and Times
-Date and Time Functions
12. Lookup, Reference, and Information Functions
-The Basic Lookup
-Advanced Lookups
-Information Functions
-Tutorial: Generating Invoices from a Product Catalog
13. Advanced Formula Writing and Troubleshooting
-Conditions in Formulas
-Descriptive Names for Cell References
-Variable Data Tables
-Controlling Recalculation
-Solving Formula Errors
Part 3: Organizing Worksheets
14. Tables: List Management Made Easy
-The Basics of Tables
-Sorting and Filtering a Table
-Dealing with Duplicate Rows
-Performing Table Calculations
15. Grouping and Outlining Data
-Basic Data Grouping
-Grouping Timesavers
16. Templates
-Understanding Templates
-Creating a New Workbook from a Template
-Creating Templates
Part 4: Charts and Graphics
17. Creating Basic Charts
-Charting 101
-Basic Tasks with Charts
-Practical Charting
-Chart Types
18. Formatting and Perfecting Charts
-Chart Styles and Layouts
-Adding Chart Elements
-Selecting Chart Elements
-Formatting Chart Elements
-Improving Your Charts
-Advanced Charting
19. Inserting Graphics
-Adding Pictures to a Worksheet
-Excel's Clip Art Library
-Drawing Shapes
Part 5: Advanced Data Analysis
20. Visualizing Your Data
-Data Bars
-Color Scales
-Icon Sets
-Sparklines
21. Scenarios and Goal Seeking
-Using Scenarios
-Using Goal Seek
-Solver
22. Pivot Tables
-Summary Tables Revisited
-Building Pivot Tables
-Multi-Layered Pivot Tables
-Fine-Tuning Pivot Table Calculations
-Filtering a Pivot Table
-Pivot Charts
23. Analyzing Databases, XML, and Web Pages
-Excel and Databases
-Understanding XML
-Excel and XML
-Web Queries
Part 6: Sharing Data with the Rest of the World
24. Protecting Your Workbooks
-Understanding Excel's Safeguards
-Data Validation
-Locked and Hidden Cells
25. Worksheet Collaboration
-Your Excel Identity
-Preparing Your Workbook
-Distributing a Document
-Adding Comments
-Tracking Changes
-Sharing Your Workbook
26. Using Excel on the Web
-Putting Your Files Online
-Using the Excel Web App
27. Exchanging Data with Other Programs
-Sharing Information in Windows
-Embedding and Linking Objects
-Transferring Data
-Programming Excel
28. Automating Tasks with Macros
-Macros 101
-The Macro Recorder
-Macro Security
-Creating Practical Macros
29. Programming Spreadsheets with VBA
-The Visual Basic Editor
-Understanding Macro Code
-Exploring the VBA Language
Part 8: Appendix
Appendix A: Customizing the Ribbon
-Adding Your Favorites to the QAT
-Personalizing the Ribbon
Index
