What is included with this book?
Matthew MacDonald is an author and programmer extraordinaire. He's the author of Excel: The Missing Manual, Creating Web Sites: The Missing Manual, the forthcoming Access 2007: The Missing Manual, and over a dozen books about programming with the Microsoft .NET Framework.
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 | |
Table of Contents provided by Publisher. All Rights Reserved. |
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.