Microsoft Office Excel 2007 揭秘

2007-2  

Microsoft Press  

Mark Dodge,Craig Stinson  

1056  

This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using Office Excel 2007. Whether you are upgrading from Office 97 or Office 2003, youll be able to dig in to the work-ready resources that help you take your Office Excel 2007 experience to the next level. This information-packed complete reference shows you how to get the most out of Office Excel 2007. You will learn how to navigate the products new features and capabilities, including the new formatting and editing advances such as Live Preview. Youll explore new graphics capabilities, master the charting interface, and learn how to create dynamic lists with PivotTable reports. Youll even learn how to automate Office Excel with macros, custom functions, and more. Plus, youll get tools, eBooks, and more on the companion CD.

Mark Dodge has coauthored several popular books on Excel, including Microsoft Office Excel 2003 Inside Out He is a former senior technical writer for the Microsoft Office User Assistance group.

Part 1: Examining the Excel Environment　Chapter 1　What's New in Microsoft Office Excel 2007,　Chapter 2　Exploring Excel Fundamentals　Chapter 3　Custom-Tailoring the Excel Workspace　Chapter 4　Security and PrivacyPart 2: Building Worksheets　Chapter 5　Planning Your Worksheet Design　Chapter 6　How to Work a Worksheet　Chapter 7　How to Work a WorkbookPart 3: Formatting and Editing Worksheets Chapter 8 Worksheet Editing Techniques Chapter 9 Worksheet Formatting TechniquesPart 4: Adding Graphics and Printing Chapter 10 Creating Spiffy Graphics Chapter 11 Printing and PresentingPart 5: Creating Formulas and Performing Data Analysis Chapter 12　Building Formulas　Chapter 13　Using Functions　Chapter 14　Everyday Functions　Chapter 15　Formatting and Calculating Date and Time　Chapter 16　Functions for Financial Analysis　Chapter 17　Functions for Analyzing Statistics　Chapter 18　Performing What-If AnalysisPart 6: Creating Charts　Chapter 19　Basic Charting Techniques　Chapter 20　Charting Beyond the RibbonPart 7: Managing Databases and Tables　Chapter 21　Managing Information in Tables　Chapter 22　Analyzing Data with PivotTable Reports　Chapter 23　Working with External DataPart 8: CollaboratingPart 9: Automating ExcelPart 10: Integrating Excel with Other Applications

Microsoft Office Excel 2007 揭秘 PDF格式下载