Microsoft Office Excel 2007 Plain & Simple

Description

Here’s WHAT You’ll Learn

* Easily navigate the new user interface
* Ceate formulas and functions
* Use charts and diagrams to display information visually
* Enhance your spreadsheet with graphic effects
* Reuse data from other Microsoft Office documents
* Team up and share spreadsheets with colleagues

Here’s HOW You’ll Learn It

* Jump in wherever you need answers
* Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
* Handy TIPS teach new techniques and shortcuts
* Quick TRY THIS! exercises help you apply what you learn right away

CONTENTS:

Acknowledgments; Chapter 1: Introduction: About This Book; No Computerese!; A Quick Overview; A Few Assumptions; A Final Word (or Two); Chapter 2: What’s New in Excel 2007?; Touring the New User Interface; Arranging Data into Tables; Introducing Galleries; Using the Mini Toolbar; Creating Formulas Using New Functions; Using More Colors; Creating Better Conditional Formats; Creating More Attractive Charts; Chapter 3: Getting Started with Excel 2007; Surveying the Excel Screen; Starting Excel; Finding and Opening Existing Workbooks; Using File Properties; Creating a New Workbook; Working with Multiple Workbooks; Sizing and Viewing Windows; Zooming In or Out on a Worksheet; Viewing a Worksheet in Full Screen Mode; Saving and Closing an Excel Workbook; Using the Excel Help System; Chapter 4: Building a Workbook; Understanding How Excel Interprets Data Entry; Navigating the Worksheet; Selecting Cells; Entering Text in Cells; Entering Numbers in Cells; Entering Dates and Times in Cells; Entering Data with Other Shortcuts; Creating a Data Table; Editing Cell Contents; Inserting a Symbol in a Cell; Creating Hyperlinks; Cutting, Copying, and Pasting Cell Values; Undoing or Redoing an Action; Finding and Replacing Text; Checking the Spelling of Your Worksheet; Chapter 5: Managing and Viewing Worksheets; Viewing and Selecting Worksheets; Renaming Worksheets; Moving Worksheets; Copying Worksheets; Inserting and Deleting Worksheets; Hiding or Showing a Worksheet; Changing Worksheet Tab Colors; Inserting, Moving, and Deleting Cells; Inserting, Moving, and Deleting Columns and Rows; Hiding and Unhiding Columns and Rows; Entering Data and Formatting Many Worksheets at the Same Time; Changing How You Look at Excel Workbooks; Naming and Using Worksheet Views; Chapter 6: Using Formulas and Functions; Understanding Formulas and Cell References in Excel; Creating Simple Cell Formulas; Assigning Names to Groups of Cells; Using Names in Formulas; Creating a Formula that References Values in a Table; Creating Formulas that Reference Cells in Other Workbooks; Summing a Group of Cells without Using a Formula; Creating a Summary Formula; Summing with Subtotals and Grand Totals; Exploring the Excel Function Library; Using the IF Function; Checking Formula References; Debugging Your Formulas; Chapter 7: Formatting the Worksheet; Formatting Cell Contents; Formatting Cells Containing Numbers; Formatting Cells Containing Dates; Adding Cell Backgrounds and Shading; Formatting Cell Borders; Defining Cell Styles; Aligning and Orienting Cell Contents; Formatting a Cell Based on Conditions; Changing How Conditional Formatting Rules Are Applied; Displaying Data Bars, Icon Sets, or Color Scales Based on Cell Values; Copying Formats with the Format Painter; Merging or Splitting Cells or Data; Chapter 8: Formatting the Worksheet; Applying Workbook Themes; Coloring Sheet Tabs; Changing a Worksheet’s Gridlines; Changing Row Heights and Column Widths; Inserting Rows or Columns; Moving Rows and Columns; Deleting Rows and Columns; Outlining to Hide and Show Rows and Columns; Hiding Rows and Columns; Protecting Worksheets from Changes; Locking Cells to Prevent Changes; Chapter 9: Printing Worksheets; Previewing Worksheets Before Printing; Printing Worksheets with Current Options; Choosing Whether to Print Gridlines and Headings; Choosing Printers and Paper Options; Printing Part of a Worksheet; Printing Row and Column Headings on Each Page; Setting and Changing Print Margins; Setting Page Orientation and Scale; Creating Headers and Footers; Adding Graphics to a Header or a Footer; Setting and Viewing Page Breaks; Chapter 10: Customizing Excel to the Way You Work; Opening Ready-to-Use Workbook Templates; Saving a Workbook as a Template; Adding Commands to the Quick Access Toolbar; Controlling which Error Messages Appear; Defining AutoCorrect and AutoFormat Entries; Controlling Worksheet Gridline Appearance; Chapter 11: Sorting and Filtering Worksheet Data; Sorting Worksheet Data; Creating a Custom Sort List; Filtering Data Quickly with AutoFilter; Creating an Advanced Filter; Validating Data for Correctness during Entry; Getting More out of Advanced Filters; Finding Unique Values in a Data List; Finding Duplicate Values in a Data List; Chapter 12: Summarizing Data Visually Using Charts; Displaying Data Graphically; Creating a Chart Quickly; Changing a Chart’s Appearance; Formatting Chart Legends and Titles; Changing the Body of a Chart; Customizing Chart Data; Working with Common Charts; Working with Uncommon Charts; Adding a Trendline to a Chart; Chapter 13: Enhancing Your Worksheets with Graphicssssss; Working with Graphics in Your Worksheets; Adding Graphics to Worksheets; Adding Drawing Objects to a Worksheet; Adding Fills to Drawing Objects; Adding Effects to Drawing Objects; Customizing Pictures and Objects; Aligning and Grouping Drawing Objects; Using WordArt to Create Text Effects in Excel; Inserting Clip Art into a Worksheet; Inserting and Changing a Diagram; Creating an Organization Chart; Chapter 14: Sharing Excel Data with Other Programs; Introducing Linking and Embedding; Linking and Embedding Other Files; Exchanging Table Data between Excel and Word; Copying Excel Charts and Data into PowerPoint; Exchanging Data between Access and Excel; Importing a Text File; Chapter 15: Using Excel in a Group Environment; Sharing Workbooks in Excel; Commenting in Cells; Tracking Changes in Workbooks; Accepting or Rejecting Changes; Saving Worksheets to the Web; Dynamically Update Worksheets Published to the Web; Retrieving Web Data from Excel; Modifying Web Queries; Introducing XML; Interacting over the Web with XML; Appendix : About the Author; Appendix : Choose the Right Book for You; Published and Upcoming Titles;