| |
| |
| 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 | |
| |
| |
| Saving Your Spreadsheet with a Password | |
| |
| |
| Disaster Recovery | |
| |
| |
| Opening Files | |
| |
| |
| Opening Files-with a Twist | |
| |
| |
| Opening Multiple Spreadsheets at Once | |
| |
| |
| |
| Adding Information to Worksheets | |
| |
| |
| Adding Different Types of Data | |
| |
| |
| Controlling Your Data Types | |
| |
| |
| Quick Ways to Add Data | |
| |
| |
| AutoComplete | |
| |
| |
| AutoCorrect | |
| |
| |
| AutoFill | |
| |
| |
| AutoFitUndo 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 | |
| |
| |
| Grouping Sheets | |
| |
| |
| Moving Worksheets from One Workbook to Another | |
| |
| |
| 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 | |
| |
| |
| Custom Formats | |
| |
| |
| Formatting Cell Appearance | |
| |
| |
| Alignment and Orientation | |
| |
| |
| Fonts and Color | |
| |
| |
| Borders and Fills | |
| |
| |
| Drawing Borders by Hand | |
| |
| |
| |
| Smart Formatting Tricks | |
| |
| |
| The Format Painter | |
| |
| |
| Styles and Themes | |
| |
| |
| Custom Styles | |
| |
| |
| Modifying Styles | |
| |
| |
| Transferring Styles Between Workbooks | |
| |
| |
| Themes: A Package of Styles | |
| |
| |
| Modifying Themes | |
| |
| |
| Conditional Formatting | |
| |
| |
| The Basics of Conditional Formatting | |
| |
| |
| Highlighting Specific Values | |
| |
| |
| Data Bars | |
| |
| |
| Color ScalesIcon Sets | |
| |
| |
| Fine-Tuning a Formatting Rule | |
| |
| |
| Using Multiple Rules | |
| |
| |
| |
| 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 | |
| |
| |
| Viewing Multiple Workbooks at Once | |
| |
| |
| 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 | |
| |
| |
| |
| Formulas and Functions | |
| |
| |
| |
| 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 | |
| |
| |
| Copying Formulas | |
| |
| |
| Absolute Cell References | |
| |
| |
| Partially Fixed References | |
| |
| |
| Referring to Other Worksheets and Workbooks | |
| |
| |
| |
| Math and Statistical Functions | |
| |
| |
| Rounding Numbers | |
| |
| |
| Round( ), Rounddown( ), Roundup( ) | |
| |
| |
| Rounding Numbers | |
| |
| |
| Mround( ), Ceiling( ), and Floor( ) | |
| |
| |
| More Rounding Functions | |
| |
| |
| INT( ) and TRUNC( ) | |
| |
| |
| Chopping Off Non-Whole Numbers | |
| |
| |
| Even( ) and Odd( ) | |
| |
| |
| Rounding Up to Even or Odd Values | |
| |
| |
| Groups of Numbers | |
| |
| |
| Sum( ) | |
| |
| |
| Summing Up Numbers | |
| |
| |
| Count( ), Counta( ), and Countblank( ) | |
| |
| |
| Counting Items in a List | |
| |
| |
| Max( ) and Min( ) | |
| |
| |
| Finding Maximum and Minimum Values | |
| |
| |
| Large( ), Small( ), and Rank( ) | |
| |
| |
| Ranking Your Numbers | |
| |
| |
| Average( ) and Median( ) | |
| |
| |
| Finding Average or Median Values | |
| |
| |
| Mode( ) | |
| |
| |
| Finding Numbers That Frequently Occur in a List | |
| |
| |
| Percentile( ) and Percentrank( ) | |
| |
| |
| Advanced Ranking Functions | |
| |
| |
| Frequency( ) | |
| |
| |
| Identifying to Which Category a Number Belongs | |
| |
| |
| General Math Functions | |
| |
| |
| Product( ), Fact( ), Power( ), and SQRT( ) | |
| |
| |
| Products, Factorials, Powers, and Square Roots | |
| |
| |
| Quotient( ) and MOD( ) | |
| |
| |
| Higher Division | |
| |
| |
| ABS( ) and SIGN( ) | |
| |
| |
| Absolute Value and Determining a Number''s Sign | |
| |
| |
| Rand( ) and Randbetween( ) | |
| |
| |
| Generating Random Numbers | |
| |
| |
| GCD( ) and LCM( ) | |
| |
| |
| Greatest and Least Common DenominatorC | |