Microsoft Office Excel 2007 inside out
An overview of the latest version of Office Excel 2007 describes the program's new features and capabilities, including formatting and editing advances with Live Preview, graphics capabilities, charting interface, PivotTable, macros, and other custom functions
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | English |
| Published: |
Redmond, Wash.
Microsoft Press
2007
|
| Series: | Inside out
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Part 1: Examining the Excel environment
- What's new in Microsoft Office Excel 2007
- Exploring Excel fundamentals
- Custom-tailoring the Excel workspace
- Security and privacy
- Part 2: Building worksheets
- Planning your worksheet design
- How to work a worksheet
- How to work a workbook
- Part 3: Formatting and editing worksheets
- Worksheet editing techniques
- Worksheet formatting techniques
- Part 4: Adding graphics and print
- Creating spiffy graphics
- Printing and presenting
- Part 5: Creating formulas and performing data analysis
- Building formulas
- Using functions
- Everyday functions
- Formatting and calculating date and time
- Functions for financial analysis
- Functions for analyzing statistics
- Performing what-if analysis
- Part 6: Creating charts
- Basic charting techniques
- Charting beyond the ribbon
- Part 7: Managing databases and tables
- Managing information in tables
- Analyzing data with PivotTable reports
- Working with external data
- Part 8: Collaborating
- Collaborating on a newtork or by e-mail
- Collaborating using the internet
- Part 9: Automating Excel
- Recording macros
- Creating custom functions
- Debugging macros and custom functions
- Part 10: Integrating Excel with other applications
- Using hyperlinks
- Linking and embedding
- Using Excel data in Word documents
- Part 11: Appendices
- A. Menu to Ribbon command reference
- B. Keyboard shortcuts
- C. Function reference