Microsoft Office Excel 2007 揭秘(光盘)Microsoft Office Excel 2007 Inside Out

分类: 图书,进口原版书,计算机 Computers & Internet ,
作者: Mark Dodge 著
出 版 社: Oversea Publishing House
出版时间: 2007-2-1字数:版次: 1页数: 1056印刷时间: 2007/02/01开本: 16开印次: 1纸张: 胶版纸I S B N : 9780735623217包装: 平装内容简介
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 1What's New in Microsoft Office Excel 2007,
Chapter 2Exploring Excel Fundamentals
Chapter 3Custom-Tailoring the Excel Workspace
Chapter 4Security and Privacy
Part 2: Building Worksheets
Chapter 5Planning Your Worksheet Design
Chapter 6How to Work a Worksheet
Chapter 7How to Work a Workbook
Part 3: Formatting and Editing Worksheets
Chapter 8 Worksheet Editing Techniques
Chapter 9 Worksheet Formatting Techniques
Part 4: Adding Graphics and Printing
Chapter 10 Creating Spiffy Graphics
Chapter 11 Printing and Presenting
Part 5: Creating Formulas and Performing Data Analysis
Chapter 12Building Formulas
Chapter 13Using Functions
Chapter 14Everyday Functions
Chapter 15Formatting and Calculating Date and Time
Chapter 16Functions for Financial Analysis
Chapter 17Functions for Analyzing Statistics
Chapter 18Performing What-If Analysis
Part 6: Creating Charts
Chapter 19Basic Charting Techniques
Chapter 20Charting Beyond the Ribbon
Part 7: Managing Databases and Tables
Chapter 21Managing Information in Tables
Chapter 22Analyzing Data with PivotTable Reports
Chapter 23Working with External Data
Part 8: Collaborating
Part 9: Automating Excel
Part 10: Integrating Excel with Other Applications