1. ### Worksheet Basics

1. #### Chapter 1 Creating and Navigating Worksheets

1. Creating a Basic Worksheet
2. Editing Data
3. Navigating in Excel
4. Saving Files
5. Opening Files
2. #### Chapter 2 Adding Information to Worksheets

1. Adding Different Types of Data
2. Quick Ways to Add Data
3. #### Chapter 3 Moving Data Around a Worksheet

1. Selecting Cells
2. Moving Cells Around
3. Adding and Moving Columns or Rows
4. #### Chapter 4 Managing Worksheets and Workbooks

1. Worksheets and Workbooks
2. Find and Replace
3. Spell Check
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

1. Controlling Your View
2. Printing
3. Controlling Pagination
2. ### Formulas and Functions

1. #### Chapter 8 Building Basic Formulas

1. Creating a Basic Formula
2. Formula Shortcuts
3. Copying Formulas
2. #### Chapter 9 Math and Statistical Functions

1. Rounding Numbers
2. Groups of Numbers
3. General Math Functions
4. Trigonometry and Advanced Math
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: Quickly 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
2. Basic Tasks with Charts
3. Practical Charting
4. Chart Types
2. #### Chapter 18 Formatting and Perfecting Charts

1. Chart Styles and Layouts
2. Adding Chart Elements
3. Selecting Chart Elements
4. Formatting Chart Elements
5. Improving Your Charts
3. #### Chapter 19 Inserting Graphics

1. Adding Pictures to a Worksheet
2. Excel's Clip Art Library
3. Drawing Shapes
5. ### Advanced Data Analysis

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

1. Using Scenarios
2. Using Goal Seek
3. Solver
2. #### Chapter 21 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
6. ### Sharing Data with the Rest of the World

1. #### Chapter 22 Protecting Your Workbooks

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

1. Preparing Your Workbook
3. Tracking Changes
4. Sharing Your Workbook
3. #### Chapter 24 Querying Databases and XML Files

1. Excel and Databases
2. Understanding XML
3. Excel and XML
4. #### Chapter 25 Exchanging Data with Other Programs

1. Sharing Information in Windows
2. Embedding and Linking Objects
3. Transferring Data
5. #### Chapter 26 Connecting Worksheets to the Web

1. Putting Worksheets on the Web
2. Performing Web Queries
7. ### Programming Excel

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

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

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