| |
| |
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 | |