1. ### Worksheet Basics

1. Creating a Basic Worksheet
2. Moving Around the Grid
3. A Tour of the Excel Window
4. Saving Files
5. Opening Files
2. #### Chapter 2 Adding Information to Worksheets

1. Adding Different Types of Data
2. Handy Timesavers
3. Dealing with Change: Undo, Redo, and AutoRecover
4. Spell Check
3. #### Chapter 3 Moving Data

1. Selecting Cells
2. Making Continuous Range Selections
3. Making Noncontiguous Selections
5. Making Selections with the Keyboard
6. Moving Cells Around
7. A Simple Cut-and-Paste or Copy-and-Paste
8. A Quicker Cut-and-Paste or Copy-and-Paste
9. Fancy Pasting Tricks
10. Paste Special
11. Copying Multiple Items with the Clipboard
12. Adding and Moving Columns or Rows
13. Inserting Columns and Rows
14. Inserting Rows
15. Inserting Copied or Cut Cells
16. Deleting Columns and Rows
4. #### Chapter 4 Managing Worksheets

1. Worksheets and Workbooks
2. Find and Replace
5. #### Chapter 5 Formatting Cells

1. Formatting Cell Values
2. Formatting Cell Appearance
6. #### Chapter 6 Smart Formatting Tricks

1. The Format Painter
2. Styles and Themes
3. Conditional Formatting
7. #### Chapter 7 Viewing and Printing Worksheets

2. Printing
3. Controlling Pagination
2. ### Formulas and Functions

1. #### Chapter 8 Building Basic Formulas

1. Creating a Basic Formula
2. Functions
3. Formula Errors
4. Logical Operators
5. Formula Shortcuts
6. Copying Formulas
2. #### Chapter 9 Math and Statistical Functions

1. Rounding Numbers
2. Groups of Numbers
3. General Math Functions
3. #### Chapter 10 Financial Functions

1. The World of Finance
2. Financial Functions
3. Depreciation
4. Other Financial Functions
4. #### Chapter 11 Manipulating Dates, Times, and Text

1. Manipulating Text
2. Manipulating Dates and Times
3. Math with Dates and Times
4. Date and Time Functions
5. #### Chapter 12 Lookup, Reference, and Information Functions

1. The Basic Lookup
3. Information Functions
4. Tutorial: Generating Invoices from a Product Catalog
6. #### Chapter 13 Advanced Formula Writing and Troubleshooting

1. Conditions in Formulas
2. Descriptive Names for Cell References
3. Variable Data Tables
4. Controlling Recalculation
5. Solving Formula Errors
3. ### Organizing Worksheets

1. #### Chapter 14 Tables: List Management Made Easy

1. The Basics of Tables
2. Sorting and Filtering a Table
3. Dealing with Duplicate Rows
4. Performing Table Calculations
2. #### Chapter 15 Grouping and Outlining Data

1. Basic Data Grouping
2. Grouping Timesavers
3. #### Chapter 16 Templates

1. Understanding Templates
2. Creating a New Workbook from a Template
3. Creating Templates
4. ### Charts and Graphics

1. #### Chapter 17 Creating Basic Charts

1. Charting 101
3. Practical Charting
4. Chart Types
2. #### Chapter 18 Formatting and Perfecting Charts

1. Chart Styles and Layouts
3. Selecting Chart Elements
4. Formatting Chart Elements
3. #### Chapter 19 Inserting Graphics

1. Adding Pictures to a Worksheet
2. Excel's Clip Art Library
3. Drawing Shapes

1. #### Chapter 20 Visualizing Your Data

1. Data Bars
2. Color Scales
3. Icon Sets
4. Sparklines
2. #### Chapter 21 Scenarios and Goal Seeking

1. Using Scenarios
2. Using Goal Seek
3. Solver
3. #### Chapter 22 Pivot Tables

1. Summary Tables Revisited
2. Building Pivot Tables
3. Multi-Layered Pivot Tables
4. Fine-Tuning Pivot Table Calculations
5. Filtering a Pivot Table
6. Pivot Charts
4. #### Chapter 23 Analyzing Databases, XML, and Web Pages

1. Excel and Databases
2. Understanding XML
3. Excel and XML
4. Web Queries
6. ### Sharing Data with the Rest of the World

1. #### Chapter 24 Protecting Your Workbooks

1. Understanding Excel's Safeguards
2. Data Validation
3. Locked and Hidden Cells
2. #### Chapter 25 Worksheet Collaboration

3. Distributing a Document
5. Tracking Changes
3. #### Chapter 26 Using Excel on the Web

2. Using the Excel Web App
4. #### Chapter 27 Exchanging Data with Other Programs

1. Sharing Information in Windows
3. Transferring Data
7. ### Programming Excel

1. #### Chapter 28 Automating Tasks with Macros

1. Macros 101
2. The Macro Recorder
3. Macro Security
4. Creating Practical Macros
2. #### Chapter 29 Programming Spreadsheets with VBA

1. The Visual Basic Editor
2. Understanding Macro Code
3. Exploring the VBA Language