Master Visually Excel 2007 -- Credits -- About the Author -- Author's Acknowledgments -- WHAT'S INSIDE -- TABLE OF CONTENTS -- HOW TO USE THIS BOOK -- Part I: EXCEL BASICS -- Chapter 1: Getting Started with Excel -- What You Can Do in Excel -- Start and Close Excel -- Understanding the Excel Screen -- Learn Excel Terminology -- Understanding the Ribbon -- Work with the Mini Toolbar and Context Menu -- Enter Information -- Undo and Redo -- Move Around in a Worksheet -- Move Around in a Workbook -- Manage the Status Bar -- Chapter 2: Managing Workbooks -- Save a Workbook -- Open a Workbook -- Convert an Excel 97-2003 Workbook to an Excel 2007 Workbook -- Start a New Workbook -- Switch between Workbooks -- Work with Workspaces -- Add Properties to a Workbook -- Close a Workbook -- Chapter 3: Formatting Cells -- Change Fonts or Font Size -- Apply Boldface, Italics, or Underlining -- Change Font Color -- Apply Font Effects -- Assign a Number Format -- Assign a Currency Format -- Assign an Accounting Format -- Assign a Short Date Format -- Assign a Long Date Format -- Assign a Time Format -- Assign a General Format -- Assign a Percentage Format -- Assign a Fraction Format -- Assign a Scientific Format -- Assign a Text Format -- Assign a Special Format -- Assign a Custom Format -- Fill Cells with Color -- Indent Text within Cells -- Align Cell Content Vertically -- Align Cell Content Horizontally -- Wrap Text within Cells -- Shrink Text within Cells -- Rotate Text in Cells -- Add Borders to Cells -- Apply a Style -- Create a Style -- Copy Formatting -- Clear Formatting -- Part II: DESIGNING WORKSHEETS -- Chapter 4: Editing Worksheets -- Base a Worksheet on a Template -- Apply a Theme -- Mix and Match Themes -- Select Cells -- Move or Copy Information -- Find and Replace Information -- Chapter 5: Proofreading a Worksheet -- Check Spelling.

Edit the Dictionary -- Translate Text -- Using the Thesaurus -- Research Online -- Chapter 6: Adjusting Worksheets -- Insert and Delete Rows -- Insert and Delete Columns -- Swap Rows and Columns -- Adjust Row Height -- Adjust Column Width -- Copy Width from One Column to Another -- Hide and Unhide Rows or Columns -- Merge Cells in Columns or Rows -- Chapter 7: Managing Workbook Structure -- Set Worksheet Tab Colors -- Edit Multiple Worksheets Simultaneously -- Add or Delete a Worksheet -- Move or Copy a Worksheet -- Rename a Worksheet -- Hide and Unhide a Worksheet -- Hide and Unhide a Workbook -- Arrange Open Worksheets or Workbooks -- Switch to Another Workbook -- Merge Styles -- Outline a Worksheet -- Work with Custom Views of Outline Settings -- Manually Create an Outline -- Remove an Outline -- Chapter 8: Working with Views -- Switch Views -- Zoom In and Zoom Out -- Create and Use a Custom View -- Hide or Display Gridlines -- Hide or Display Row Numbers and Column Letters -- Hide or Display the Formula Bar -- Open a New Window -- Freeze Column and Row Titles -- Split a Window -- Chapter 9: Printing Worksheet Information -- Set Margins -- Add Headers and Footers to a Worksheet -- Select an Area to Print -- Insert, Adjust, or Remove Page Breaks -- Set Page Orientation -- Print Row and Column Titles on Each Page -- Set Paper Size -- Control the Width and Height of Printed Output -- Print Gridlines -- Print Row Numbers and Column Letters -- Preview and Print -- Part III: CALCULATING DATA -- Chapter 10: Performing Basic Math -- The Basics of Formulas in Excel -- Fill a Range with Information -- Add Numbers -- Multiply Numbers -- Edit a Formula -- Quickly Calculate Common Values -- Absolute and Relative Cell References -- Copy a Formula -- Change a Formula to a Value -- Add Data in One Range to Another -- Add Data in One Worksheet to Another.

Using Cell Names and Range Names -- Edit and Delete Cell or Range Names -- Create Range Names from Headings -- Apply Names to Existing Formulas -- Understanding Arrays -- Create an Array Formula -- Using the SUM Function in an Array Formula -- Chapter 11: Working with Common Formulas -- Sum Numbers -- Calculate a Running Balance -- Install and Use the Conditional Sum Wizard -- Calculate a Percentage -- Calculate an Average -- Determine a Maximum Value -- Identify a Minimum Value -- Round Values -- Count the Number of Cells Containing Information -- Create a Frequency Distribution -- Find the Most Frequently Occurring Value in a Range -- Calculate a Subtotal -- Chapter 12: Mastering Date and Time Formulas -- Calculate Elapsed Days between Dates -- Insert Today's Date in a Cell -- Work with Times -- View the Serial Number for a Date or Time -- Calculate a Serial Date Number -- Convert a Text Date to a Date Value -- Calculate Part of a Date -- Determine the Week of the Year -- Calculate a Due Date -- Convert a Text Time to a Time Value -- Convert a Time Value into Hours, Minutes, or Seconds -- Chapter 13: Working with Financial Formulas -- Calculate the Present Value of an Investment -- Calculate the Net Present Value of an Investment -- Calculate the Future Value of an Investment -- Calculate a Loan Payment -- Depreciate Assets -- Chapter 14: Working with Lookup Formulas -- Look up a Single Value in a Column -- Look up a Single Value in a Row -- Look Up a Value in a Table -- Using the Lookup Wizard -- Choose a Value from a List -- Chapter 15: Applying Reference, Information, and Text Formulas -- Determine the Number of Columns in a Selection -- Determine the Number of Rows in a Selection -- Change Text Case -- Join Text -- Split Up Text -- Change Text to Values -- Combine Text and Values -- Remove Spaces from Imported Data.

Chapter 16: Working with Logical and Error Trapping Formulas -- Understanding Error Values -- Make a Decision -- Test for True or False -- Avoid Displaying Errors -- Chapter 17: Analyzing Tabular Information with Functions -- Understanding Database Functions -- Sum Records That Meet a Single Criterion -- Sum Records That Meet Multiple Criteria -- Count Records That Meet a Single Criterion -- Count Records That Meet Multiple Criteria -- Average Records That Meet a Single Criterion -- Average Records That Meet Multiple Criteria -- Find the Smallest Record That Meets Criteria -- Find the Largest Record That Meets Criteria -- Chapter 18: Analyzing Formulas and Worksheets -- Understanding Excel Errors -- Display and Print Formulas in Cells -- Identify Cells Containing Formulas -- Evaluate Formulas -- Check for Formula Errors -- Trace Cell Relationships -- Control Data Entry -- Part IV: MASTERING EXCEL CHARTS -- Chapter 19: Discovering Chart Basics -- Understanding Charts -- Understanding the Chart Window -- Create a Column Chart -- Create a Pie Chart -- Change the Chart Type -- Select a Chart Layout -- Change the Chart Style -- Move a Chart to a Separate Sheet -- Reposition an Embedded Chart -- Resize an Embedded Chart -- Change the Data Included in the Chart -- Switch Rows and Columns on the Chart -- Create a Combination Chart -- Create a Chart Template -- Chapter 20: Changing Chart Layout Details -- Add a Chart Title -- Format the Chart Title -- Display the Horizontal Axis Title -- Format the Horizontal Axis Title -- Display the Vertical Axis Title -- Format the Vertical Axis -- Reposition or Hide the Chart Legend -- Show Data Labels -- Show the Data Table -- Format the Plot Area -- Format the Chart Walls of a 3-D Chart -- Format the Chart Floor of a 3-D Chart -- Change the Rotation of a 3-D Chart -- Set Axis Options.

Change Horizontal and Vertical Gridlines -- Add a Trendline -- Add Line Markers on a Chart -- Add Bars to Charts -- Chapter 21: Formatting Charts -- Set Chart Element Shape Styles -- Set Fill Colors for Chart Element Shapes -- Set the Shape Outline for a Chart Element -- Set Shape Effects for Chart Elements -- Copy Chart Formatting -- Chapter 22: Working with Graphic Elements -- Understanding Graphic Elements -- Include a Shape in a Worksheet -- Insert a Text Box -- Work with SmartArt -- Apply a SmartArt Style -- Apply a SmartArt Layout -- Change the Color of a SmartArt Graphic -- Add WordArt to a Worksheet -- Insert a Symbol -- Add a Picture to a Worksheet -- Insert Clip Art in a Worksheet -- Move or Resize a Graphic Element -- Change the Shape of a Graphic Element -- Modify a Graphic Element Border -- Add an Effect to a Graphic Element -- Change the Brightness of a Graphic Element -- Change the Contrast of a Graphic Element -- Recolor a Graphic Element -- Compress Graphic Elements -- Crop a Graphic Element -- Position Graphic Elements -- Align Graphic Elements -- Rotate Graphic Elements -- Part V: ANALYZING DATA -- Chapter 23: Working with Tables -- Create a Table -- Change the Size of a Table -- Use a Data Entry Form -- Create a Drop-Down List for Data Entry -- Filter or Sort Table Information -- Change the Table Style -- Apply Special Formatting -- Display or Hide Banding -- Hide or Display the Header Row -- Work with the Total Row -- Filter to Hide Duplicates -- Remove Duplicates from a Table -- Convert a Table to a Range -- Chapter 24: Summarizing Data with PivotTables and PivotCharts -- Understanding PivotTables -- Create a PivotTable Using Numeric Data -- Pivot Elements in a PivotTable -- Change PivotTable Display Options -- Create a PivotTable with Non-Numeric Data -- Filter a PivotTable -- Sort Information in a PivotTable.

Group Items in a PivotTable.