Microsoft Office Excel 2007 进阶指南

书籍目录

About the Author   Features and Conventions  using the Book's CD  Getting Help   The Microsoft Business Certification Program Quick ReferenceWhat's New in Excel2007?  Becoming Familiar With the New User Interface  Managing Larger Data Collections  Using the New Microsoft Office fIL Format  Formatting Cells and Worksheets  Managing Data tables More Effectively  Creating Formulas More Easily by Using Formula AutoComplete  Summarizing Data Using New Functions   Creating Powerful Conditional FOrmats  Creating More Attractive Charts  Controlling Printouts More CarefullySetting Up a Workbook  Creating Workbooks  Modifying Workbooks  Modifying Worksheets  Customizing the Excel 2007 Program WindowWorking with Data and Data Tables  Entering and Revising Data   Moving Data Within a Workbook  Finding and Replacing Data  Correcting and Expanding Upin Worksheet Data  Defining a Tableperforming Calculations on Data  Naming Groups of Data  Creating Formulas to Calculate Values  Summarizing Data That Meets Specific Conditions  Finding and Correcting Erros in CalculationsChanging Document Appearance  Formatting Cells  Defining styles  Applying Workbook Themes and Table Styles  Making Numbers Easier to Read  Changing the Appearance of Data Based on its Value  Adding images to a Document Focusing on Specific Data Using Filters  Limiting Data That Appears on Your Screen  Manipulating List Data  Defining Valid Sets of Values for Ranges of CellsReordering and Summarizing Data  Sorting Data Lists  Organizing Data Into Levels  Looking Up liformation in a Data List  ……Combining Data from Multiple SourcesAnalyzing Alternative Data SetsCreating Dynamic Lists Winth PivotToblesCreating Charts and Graphicsprinting

作者简介

Experience learning made easy and quickly teach yourself how to organize, analyze, and present data with Excel 2007. With Step By Step, you set the pace building and practicing the skills you need, just when you need them! Create formulas, calculate values, and analyze data Present information visually with graphics, charts, and diagrams Build PivotTable dynamic views even easier with new data tables Reuse information from databases and other documents Share spreadsheets for review and manage changes Create macros to automate repetitive tasks and simplify your workYour all-in-one learning experience includes: Files for building skills and practicing the book s lessons Fully searchable eBook Bonus quick reference to the Ribbon, the new Microsoft Office interface Windows Vista Product Guide eReference plus other resources on CD

 Microsoft Office Excel 2007 进阶指南下载