Microsoft Office Excel 2007 Inside Out
Published on 17. January 2007
Book
Mixed media product
1088 pages
978-0-7356-2321-7 (ISBN)
Description
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 2007-and challenge yourself to new levels of mastery!
Learn expert techniques for designing powerful spreadsheets
Apply built-in functions-or write your own-and 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 colleagues-and control access to sensitive data
Link and embed Excel data into other documents
Create macros with Microsoft Visual Basic for Applications
CD 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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Learn expert techniques for designing powerful spreadsheets
Apply built-in functions-or write your own-and 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 colleagues-and control access to sensitive data
Link and embed Excel data into other documents
Create macros with Microsoft Visual Basic for Applications
CD 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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
More details
Persons
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.
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.
Content
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 Chaptere 12 Building Formulas Chapter 13 Using Functions Chapter 14 Everday 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 Chapter 24 Collaborating on a Network or by E-Mail Chapter 25 Collaborating Using the Internet Part 9: Automating Excel Chapter 26 Recording Macros Chapter 27 Creating Custom Functions Chapter 28 Debugging Macros and Custom Functions Part 10: Integrating Excel with Other A pplications Chapter 29 Using Hyperlinks Chapter 30 Linking and Embedding Chpater 31 Using Excel Data in Woed Documents Part 11: Appendixes Appendiz A Menu to Ribbon Command Reference Appendix B Keyboard Shortcuts Appendix C Function Refernce