Microsoft Office Excel 2007 Inside Out

by Stinson, Craig; Dodge, Mark

• ISBN13: 9780735623217
• ISBN10: 073562321X
• Edition: 1st
• Format: Paperback
• Copyright: 2007-01-17
• Publisher: Microsoft Press

Summary

You're beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Excel 2007and challenge yourself to new levels of mastery! Learn expert techniques for designing powerful spreadsheets Apply built-in functionsor write your ownand carry out complex calculations Use rich charting capabilities and new SmartArt graphics to visually represent data Perform sophisticated data analysis: financial, statistical, and "what-if" Design PivotTable reports to dynamically analyze data Share spreadsheets and collaborate with colleaguesand control access to sensitive data Link and embed Excel data into other documents Create macros with Microsoft Visual Basic for ApplicationsCD includes: Fully searchable eBook Sample spreadsheets from inside the book Add-ins and other resources to help you extend Microsoft Office programs Links to demos, user communities, and product support References for finding Excel 2003 commands in Excel 2007 Windows Vista Product Guide eReference and other eBooks

Author Biography

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. Craig Stinson is a computer journalist and author. He has written or coauthored more than 20 books, including Microsoft Windows XP Inside Out, Deluxe Edition and Windows Vista Inside Out.

Table of Contents

What's new in Microsoft Office Excel 2007	p. 3
Exploring Excel fundamentals	p. 21
Custom-tailoring the Excel workspace	p. 83
Security and privacy	p. 103
Planning your worksheet design	p. 117
How to work a worksheet	p. 125
How to work a workbook	p. 165
Worksheet editing techniques	p. 181
Worksheet formatting techniques	p. 265
Creating spiffy graphics	p. 345
Printing and presenting	p. 403
Building formulas	p. 427
Using functions	p. 487
Everyday functions	p. 497
Formatting and calculating date and time	p. 521
Functions for financial analysis	p. 535
Functions for analyzing statistics	p. 553
Performing what-if analysis	p. 583
Basic charting techniques	p. 615
Charting beyond the ribbon	p. 633
Managing information in tables	p. 667
Analyzing data with PivotTable reports	p. 711
Working with external data	p. 745
Collaborating on a network or by e-mail	p. 789
Collaborating using the Internet	p. 807
Recording macros	p. 827
Creating custom functions	p. 847
Debugging macros and custom functions	p. 859
Using hyperlinks	p. 873
Linking and embedding	p. 881
Using Excel data in Word documents	p. 891
Table of Contents provided by Blackwell. All Rights Reserved.