1. ### Worksheet Basics

1. Starting a Workbook
2. Adding Information to a Worksheet
3. Using the Ribbon
4. Using the Status Bar
5. Going Backstage
6. Saving Files
7. 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. Moving Cells Around
3. Adding and Moving Columns or 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
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

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

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

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

1. Using the Office Online 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. Formatting Chart Elements
3. #### Chapter 19 Inserting Graphics

1. Adding Pictures to a Worksheet
2. Excel’s Clip Art Library
3. Drawing Shapes
4. SmartArt
4. #### Chapter 20 Visualizing Your Data

1. Data Bars
2. Color Scales
3. Icon Sets
4. Sparklines
5. ### Sharing Data with the Rest of the World

1. #### Chapter 21 Protecting Your Workbooks

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

5. Tracking Changes
7. Reviewing Workbooks with Inquire
3. #### Chapter 23 Using Excel on the Web

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

1. Sharing Information in Windows
3. Transferring Data

1. #### Chapter 25 Scenarios and Goal Seeking

1. Using Scenarios
2. Using Goal Seek
3. Solver
2. #### Chapter 26 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
3. #### Chapter 27 Analyzing Databases

1. Excel and Databases
2. Creating a Data Connection
3. The Data Model: Boosting Pivot Tables
4. #### Chapter 28 Analyzing XML and Web Data

1. Understanding XML
2. Retrieving Information from XML
3. Creating Web Queries
4. Connecting to Online Data Services with OData
7. ### Programming Excel

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

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

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