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格式下载