Flylib.com
Excel 2007[c] The Missing Manual
Excel 2007[c] The Missing Manual
ISBN: 596527594
EAN: N/A
Year: 2007
Pages: 173
BUY ON AMAZON
Excel 2007: The Missing Manual
Table of Contents
Copyright
The Missing Credits
Introduction
Part I: Worksheet Basics
Chapter 1. Creating and Navigating Worksheets
Section 1.1. Creating a Basic Worksheet
Section 1.2. Editing Data
Section 1.3. Navigating in Excel
Section 1.4. Saving Files
Section 1.5. Opening Files
Chapter 2. Adding Information to Worksheets
Section 2.1. Adding Different Types of Data
Section 2.2. Quick Ways to Add Data
Chapter 3. Moving Data Around a Worksheet
Section 3.1. Selecting Cells
Section 3.2. Moving Cells Around
Section 3.3. Adding and Moving Columns or Rows
Chapter 4. Managing Worksheets and Workbooks
Section 4.1. Worksheets and Workbooks
Section 4.2. Find and Replace
Section 4.3. Spell Check
Chapter 5. Formatting Cells
Section 5.1. Formatting Cell Values
Section 5.2. Formatting Cell Appearance
Chapter 6. Smart Formatting Tricks
Section 6.1. The Format Painter
Section 6.2. Styles and Themes
Section 6.3. Conditional Formatting
Chapter 7. Viewing and Printing Worksheets
Section 7.1. Controlling Your View
Section 7.2. Printing
Section 7.3. Controlling Pagination
Part II: Formulas and Functions
Chapter 8. Building Basic Formulas
Section 8.1. Creating a Basic Formula
Section 8.2. Formula Shortcuts
Section 8.3. Copying Formulas
Chapter 9. Math and Statistical Functions
Section 9.1. Rounding Numbers
Section 9.2. Groups of Numbers
Section 9.3. General Math Functions
Section 9.4. Trigonometry and Advanced Math
Section 9.5. Advanced Statistics
Chapter 10. Financial Functions
Section 10.1. The World of Finance
Section 10.2. Financial Functions
Section 10.3. Depreciation
Section 10.4. Other Financial Functions
Chapter 11. Manipulating Dates, Times, and Text
Section 11.1. Manipulating Text
Section 11.2. Manipulating Dates and Times
Section 11.3. Math with Dates and Times
Section 11.4. Date and Time Functions
Chapter 12. Lookup, Reference, and Information Functions
Section 12.1. The Basic Lookup
Section 12.2. Advanced Lookups
Section 12.3. Information Functions
Section 12.4. Tutorial: Quickly Generating Invoices from a Product Catalog
Chapter 13. Advanced Formula Writing and Troubleshooting
Section 13.1. Conditions in Formulas
Section 13.2. Descriptive Names for Cell References
Section 13.3. Variable Data Tables
Section 13.4. Controlling Recalculation
Section 13.5. Solving Formula Errors
Part III: Organizing Worksheets
Chapter 14. Tables: List Management Made Easy
Section 14.1. The Basics of tablesTables
Section 14.2. Sorting and Filtering a Table
Section 14.3. Dealing with Duplicate Rows
Section 14.4. Performing Table Calculations
Chapter 15. Grouping and Outlining Data
Section 15.1. Basic Data Grouping
Section 15.2. Grouping Timesavers
Chapter 16. Templates
Section 16.1. Understanding Templates
Section 16.2. Creating a New Workbook from a Template
Section 16.3. Creating Templates
Part IV: Charts and Graphics
Chapter 17. Creating Basic Charts
Section 17.1. Charting 101
Section 17.2. Basic Tasks with Charts
Section 17.3. Practical Charting
Section 17.4. Chart Types
Chapter 18. Formatting and Perfecting Charts
Section 18.1. Chart Styles and Layouts
Section 18.2. Adding Chart Elements
Section 18.3. Selecting Chart Elements
Section 18.4. Formatting Chart Elements
Section 18.5. Improving Your Charts
Section 18.6. Advanced Charting
Chapter 19. Inserting Graphics
Section 19.1. Adding Pictures to a Worksheet
Section 19.2. Excel s Clip Art Library
Section 19.3. Drawing Shapes
Part V: Advanced Data Analysis
Chapter 20. Scenarios and Goal Seeking
Section 20.1. Using Scenarios
Section 20.2. Using Goal Seek
Section 20.3. Solver
Chapter 21. Pivot Tables
Section 21.1. Summary Tables Revisited
Section 21.2. Building Pivot Tables
Section 21.3. Multi-Layered Pivot Tables
Section 21.4. Fine-Tuning Pivot Table Calculations
Section 21.5. Filtering a Pivot Table
Section 21.6. Pivot Charts
Part VI: Sharing Data with the Rest of the World
Chapter 22. Protecting Your Workbooks
Section 22.1. Understanding Excel s Safeguards
Section 22.2. Data Validation
Section 22.3. Locked and Hidden Cells
Chapter 23. Worksheet Collaboration
Section 23.1. Preparing Your Workbook
Section 23.2. Adding Comments
Section 23.3. Tracking Changes
Section 23.4. Sharing Your Workbook
Chapter 24. Querying Databases and XML Files
Section 24.1. Excel and Databases
Section 24.2. Understanding XML
Section 24.3. Excel and XML
Chapter 25. Exchanging Data with Other Programs
Section 25.1. Sharing Information in Windows
Section 25.2. Embedding and Linking Objects
Section 25.3. Transferring Data
Chapter 26. Connecting Worksheets to the Web
Section 26.1. Putting Worksheets on the Web
Section 26.2. Performing Web Queries
Section 26.3. Using Hyperlinks
Part VII: Programming Excel
Chapter 27. Automating Tasks with Macros
Section 27.1. Macros 101
Section 27.2. The Macro Recorder
Section 27.3. Macro Security
Section 27.4. Creating Practical Macros
Chapter 28. Programming Spreadsheets with VBA
Section 28.1. The Visual Basic Editor
Section 28.2. Understanding Macro Code
Section 28.3. Exploring the VBA Language
Part VIII: Appendix
Appendix A. Customizing the Quick Access Toolbar
Section A.1. The Quick Access Toolbar
Colophon
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Excel 2007[c] The Missing Manual
ISBN: 596527594
EAN: N/A
Year: 2007
Pages: 173
BUY ON AMAZON
A+ Fast Pass
Domain 1 Installation, Configuration, and Upgrading
Domain 4 Motherboard/Processors/Memory
Domain 6 Basic Networking
Domain 2 Installation, Configuration, and Upgrading
Domain 4 Networks
Developing Tablet PC Applications (Charles River Media Programming)
The Tablet PC
Obtaining the Tablet PC SDK
Tablet PC Screen Rotation and Special Buttons
Power Management for the Tablet PC
Tablet Fax
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Local Area Network (LAN) Technologies
Wide Area Network (WAN) Technologies
Point-to-Point Protocol (PPP)
Transmission Control Protocol (TCP) Data Flow
Dynamic Host Configuration Protocol (DHCP) Server Service
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 18. Examine Patterns of Criminal Activity
Hacks 2941: Introduction
Hack 33. Why Your Cell Phone Doesnt Work There
Hack 34. Publish Your Own Hiking Trail Maps
Hack 42. Get More out of What You Read
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 426: Fixed Outdoor Electric De-Icing and Snow-Melting Equipment
Article 701 Legally Required Standby Systems
Tables
Example No. D1(a) One-Family Dwelling
Example No. D2(b) Optional Calculation for One-Family Dwelling, Air Conditioning Larger than Heating [See 220.82(A) and 220.82(C)]
Microsoft WSH and VBScript Programming for the Absolute Beginner
Using Procedures to Organize Scripts
Handling Script Errors
Combining Different Scripting Languages
Appendix A WSH Administrative Scripting
Appendix C Whats on the CD-ROM?
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies