| |
| |
| The Missing Credits | |
| |
| |
| Introduction | |
| |
| |
| |
| Worksheet Basics | |
| |
| |
| |
| Creating and Navigating Worksheets | |
| |
| |
| Creating a Basic Worksheet | |
| |
| |
| Starting a New Workbook | |
| |
| |
| Adding the Column Titles | |
| |
| |
| Adding Data | |
| |
| |
| Editing Data | |
| |
| |
| Navigating in Excel | |
| |
| |
| The Tabs of the Ribbon | |
| |
| |
| The Formula Bar | |
| |
| |
| The Status Bar | |
| |
| |
| Excel Options | |
| |
| |
| Saving Files | |
| |
| |
| The Excel 2007 File Format | |
| |
| |
| Saving Your Spreadsheet in Older Formats | |
| |
| |
| Saving Your Spreadsheet As a PDF | |
| |
| |
| Disaster Recovery | |
| |
| |
| Opening Files | |
| |
| |
| Opening Multiple Spreadsheets at Once | |
| |
| |
| |
| Adding Information to Worksheets | |
| |
| |
| Adding Different Types of Data | |
| |
| |
| Controlling Your Data Types | |
| |
| |
| Quick Ways to Add Data | |
| |
| |
| Auto Complete | |
| |
| |
| Auto Correct | |
| |
| |
| Auto Fill | |
| |
| |
| Auto Fit Undo and Redo | |
| |
| |
| |
| Moving Data Around a Worksheet | |
| |
| |
| Selecting Cells | |
| |
| |
| Making Continuous Range Selections | |
| |
| |
| Making Non-Contiguous Selections | |
| |
| |
| Automatically Selecting Your Data | |
| |
| |
| Making Selections with the Keyboard | |
| |
| |
| Moving Cells Around | |
| |
| |
| A Simple Cut-and-Paste or Copy-and-Paste | |
| |
| |
| A Fancy Cut-and-Paste or Copy-and-Paste | |
| |
| |
| The Clipboard | |
| |
| |
| Special Pasting | |
| |
| |
| Adding and Moving Columns or Rows | |
| |
| |
| Inserting Columns | |
| |
| |
| Inserting Rows | |
| |
| |
| Inserting Copied or Cut Cells | |
| |
| |
| Deleting Columns and Rows | |
| |
| |
| |
| Managing Worksheets and Workbooks | |
| |
| |
| Worksheets and Workbooks | |
| |
| |
| Adding, Removing, and Hiding Worksheets | |
| |
| |
| Naming and Rearranging Worksheets | |
| |
| |
| Find and Replace | |
| |
| |
| The Basic Find | |
| |
| |
| Find All | |
| |
| |
| More Advanced Searches | |
| |
| |
| Finding Formatted Cells | |
| |
| |
| Finding and Replacing Values | |
| |
| |
| Spell Check | |
| |
| |
| Spell Checking Options | |
| |
| |
| |
| Formatting Cells | |
| |
| |
| Formatting Cell Values | |
| |
| |
| Formatting Numbers | |
| |
| |
| Formatting Dates and Times | |
| |
| |
| Special Formats for Special Numbers | |
| |
| |
| Formatting Cell Appearance | |
| |
| |
| Alignment and Orientation | |
| |
| |
| Fonts and Color | |
| |
| |
| Borders and Fills | |
| |
| |
| Drawing Borders by Hand | |
| |
| |
| Smart Ways to Apply Formatting | |
| |
| |
| The Format Painter | |
| |
| |
| Styles and Themes | |
| |
| |
| |
| Viewing and Printing Worksheets | |
| |
| |
| Controlling Your View | |
| |
| |
| Zooming | |
| |
| |
| Viewing Distant | |
| |
| |
| Parts of a Spreadsheet at Once | |
| |
| |
| Freezing Columns or Rows | |
| |
| |
| Hiding Data | |
| |
| |
| Saving View Settings | |
| |
| |
| Printing | |
| |
| |
| How to Print an Excel File | |
| |
| |
| Quick Printing | |
| |
| |
| Previewing Your Printout | |
| |
| |
| Creating Headers and Footers | |
| |
| |
| Customizing Print Settings | |
| |
| |
| Controlling Pagination | |
| |
| |
| Page Breaks | |
| |
| |
| Scaling | |
| |
| |
| Page Break Preview: A Bird's-Eye View of Your Worksheet | |
| |
| |
| |
| Worksheet power | |
| |
| |
| |
| Building Basic Formulas | |
| |
| |
| Creating a Basic Formula | |
| |
| |
| Excel's Order of Operations Cell | |
| |
| |
| References | |
| |
| |
| How Excel Formats Cells That Contain Cell | |
| |
| |
| References | |
| |
| |
| Functions | |
| |
| |
| Formula Errors | |
| |
| |
| Logical Operators | |
| |
| |
| Formula Shortcuts | |
| |
| |
| Point-and-Click Formula Creation | |
| |
| |
| Point-and-Click Formula Editing | |
| |
| |
| The Formulas Tab | |
| |
| |
| Using the Insert Function Button to Quickly Find and Insert Functions | |
| |
| |
| Copying Formulas | |
| |
| |
| Absolute Cell | |
| |
| |
| References | |
| |
| |
| Partially Fixed | |
| |
| |
| References | |
| |
| |
| |
| Tables: List Management Made Easy | |
| |
| |
| The Basics of Tables | |
| |
| |
| Creating a Table | |
| |
| |
| Formatting a Table | |
| |
| |
| Editing a Table | |
| |
| |
| Selecting Parts of a Table | |
| |
| |
| Sorting and Filtering a Table | |
| |
| |
| Applying a Simple Sort Order | |
| |
| |
| Sorting with Multiple Criteria | |
| |
| |
| Filtering with the List of Values | |
| |
| |
| Creating Smarter Filters | |
| |
| |
| |
| Creating Basic Charts | |
| |
| |
| Charting 101 Embedded and Standalone Charts | |
| |
| |
| Creating a Chart with the Ribbon | |
| |
| |
| The Chart Tools Ribbon Tabs | |
| |
| |
| Basic Tasks with Charts | |
| |
| |
| Moving and Resizing a Chart | |
| |
| |
| Creating a Standalone Chart | |
| |
| |
| Editing and Adding to Chart Data | |
| |
| |
| Changing the Chart Type | |
| |
| |
| Printing Charts | |
| |
| |
| Practical Charting | |
| |
| |
| Charts with Multiple Series of Numbers | |
| |
| |
| Controlling the Data Excel Plots on the X-Axis | |
| |
| |
| Non-Contiguous Chart Ranges | |
| |
| |
| Changing the Order of Your Data Series | |
| |
| |
| Changing the Way Excel Plots Blank Values | |
| |
| |
| Chart Types | |
| |
| |
| Column | |
| |
| |
| BarLine | |
| |
| |
| PieArea | |
| |
| |
| Appendix | |
| |
| |
| Customizing the Quick Access Toolbar | |
| |
| |
| Index" | |