【图书简介】 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.-读书网|DuShu.com
【作者简介】 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 Privacy Part 2: Building Worksheets Chapter 5 Planning Your Worksheet Design Chapter 6 How to Work a Worksheet Chapter 7 How 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 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 Analysis Part 6: Creating Charts Chapter 19 Basic Charting Techniques Chapter 20 Charting Beyond the Ribbon Part 7: Managing Databases and Tables Chapter 21 Managing Information in Tables Chapter 22 Analyzing Data with PivotTable Reports Chapter 23 Working with External Data Part 8: Collaborating Part 9: Automating Excel Part 10: Integrating Excel with Other Applications