Office 365 All-in-One For Dummies, 2nd Edition

Book 3

Excel 365

Contents at a Glance

1. Chapter 1: Up and Running with Excel
   1. Creating a New Excel Workbook
   2. Getting Acquainted with Excel
   3. Entering Data in a Worksheet
   4. Quickly Entering Lists and Serial Data with the AutoFill Command
   5. Formatting Numbers, Dates, and Time Values
   6. Establishing Data-Validation Rules
2. Chapter 2: Refining Your Worksheet
   1. Editing Worksheet Data
   2. Moving Around in a Worksheet
   3. Getting a Better Look at the Worksheet
   4. Notes for Documenting Your Worksheet
   5. Comments for Collaborating with Others on a Workbooks
   6. Selecting Cells in a Worksheet
   7. Deleting, Copying, and Moving Data
   8. Handling the Worksheets in a Workbook
   9. Keeping Others from Tampering with Worksheets
3. Chapter 3: Formulas and Functions for Crunching Numbers
   1. How Formulas Work
   2. The Basics of Entering a Formula
   3. Speed Techniques for Entering Formulas
   4. Copying Formulas from Cell to Cell
   5. Detecting and Correcting Errors in Formulas
   6. Working with Functions
   7. A Look at Some Very Useful Functions
4. Chapter 4: Making a Worksheet Easier to Read and Understand
   1. Laying Out a Worksheet
   2. Decorating a Worksheet with Borders and Colors
   3. Getting Ready to Print a Worksheet
5. Chapter 5: Advanced Techniques for Analyzing Data
   1. Getting Quick Analyses from Excel
   2. Conditional Formats for Calling Attention to Data
   3. Managing Information in Lists
   4. Forecasting with the Goal Seek Command
   5. Performing What-If Analyses with Data Tables
   6. Analyzing Data with PivotTables