Excel 2007 in easy steps

Excel 2007 in easy steps introduces the new Ribbon interface provided by Office 2007. It shows you how to create and manipulate worksheets, starting with the basic concepts and then introducing functions and features that allow you to organize and manage vast amounts of information. It covers the Excel Table data list structures, advanced functions and Excel add-ins, and shows you how to present your worksheet data in chart formats.

The book will help you to create macros, recorded or via Visual Basic. You'll learn how to use templates, tools and other resources to help you apply Excel to various tasks. You'll link your worksheets to other workbooks and to data sources on the Internet to get automatic updates.

Written concisely yet comprehensively, this is an ideal book to help you grasp the essentials of Excel 2007 quickly and easily, even if you are new to the spreadsheet concept.

Michael Price is an accomplished author, IT journalist and systems consultant with a wide experience of computing systems ranging from mainframes to personal computers.

1. Introduction
   • The Spreadsheet Concept
   • Microsoft Excel
   • Microsoft Office 2007
   • What's New in Excel 2007
   • System Requirements
   • The Office 2007 Ribbon
   • Start Excel under XP
   • Start Excel under Vista
   • Activation
   • Excel Command Reference
2. Begin with Excel
   • The Excel Window
   • Create a Workbook
   • Add Data to the Worksheet
   • Build the Worksheet
   • Fill Cells
   • Complete the Worksheet
   • Format the Text
   • Number Formats
   • Print the Worksheet
   • Insert, Copy and Paste
   • Excel Help
   • Contextual Help
   • Excel File Formats
3. Manage Data
   • Use Existing Data
   • Import Data
   • Navigate the Worksheet
   • Scroll with Wheel Mouse
   • Navigate with Keystrokes
   • Sort Rows
   • Find Entries
   • Filter Information
   • Remove Duplicate Entries
   • Check Spelling
   • Freeze Headers and Labels
   • Hide Columns or Rows
   • Protect a Worksheet
4. Formulas and Functions
   • Number Formats
   • Text Formats
   • Relative References
   • Absolute References
   • Name References
   • Operators
   • Calculation Sequence
   • Functions
   • AutoSum
   • Formula Errors
   • Add Comments
5. Excel Tables
   • Create an Excel Table
   • Edit Tables
   • Table Styles
   • Table Totals
   • Count Unique Entries
   • Structured References
   • Calculated Columns
   • Insert Rows
   • Custom Sort
   • Print a Table
   • Summarize a Table
   • Convert to a Range
6. Advanced Functions
   • Function Library
   • Logical Functions
   • Lookup/Reference Functions
   • Financial Functions
   • Date & Time Functions
   • Text Functions
   • Math & Trig Functions
   • Random Numbers
   • Other Functions: Statistical
   • Other Functions: Engineering
   • Excel Add-ins
   • Evaluate Formula
7. Control Excel
   • Audit Formulas
   • Protect Formulas
   • Check for Errors
   • Backup
   • AutoSave and AutoRecovery
   • Startup Switches
   • Create a Shortcut
   • Ribbon KeyTips
   • Using KeyTips
   • Minimize the Ribbon
   • Quick Access Toolbar
   • Mini Toolbar
   • Print Worksheets
8. Charts
   • Create a Chart
   • Default Chart Type
   • Change Chart Layout
   • Legend and Data Table
   • Change Chart Type
   • Pie Chart
   • 3-D Pie Chart
   • 3-D Column Chart
   • Share Data
   • Line Chart
   • Stock Chart
   • Mixed Types
   • Print Charts
9. Macros in Excel
   • Macros
   • Create Macros
   • Record a Macro
   • Apply the Macro
   • View the Macro
   • Create a Table
   • Edit the Macro
   • Use the Macro
   • Create Macros with VBA
   • Add Macros to the Toolbar
   • Debug Macros
10. Templates and Scenarios
    • Templates
    • Online Templates
    • More Excel Resources
    • What-If Analysis
    • Summary Reports
    • Goal Seek
    • Optimization
    • Project Worksheet
    • Solver
11. Links and Connections
    • Link to Workbooks
    • Create External References
    • Styles of Reference
    • Source Workbook Changes
    • Apply the Updates
    • Turn Off the Prompt
    • Excel in Word
    • Publish as PDF
    • Exchange Data with the Web
    • Install and Use Stock Quotes
    • Currency Rate Calculator